Use Supabase with SolidJS

Learn how to create a Supabase project, add some sample data to your database, and query the data from a SolidJS app.

Create a Supabase project

Go to database.new and create a new Supabase project.

Alternatively, you can create a project using the Management API:

1
# First, get your access token from https://supabase.com/dashboard/account/tokens
2
export SUPABASE_ACCESS_TOKEN="your-access-token"
3
4
# List your organizations to get the organization ID
5
curl -H "Authorization: Bearer $SUPABASE_ACCESS_TOKEN" \
6
  https://api.supabase.com/v1/organizations
7
8
# Create a new project (replace <org-id> with your organization ID)
9
curl -X POST https://api.supabase.com/v1/projects \
10
  -H "Authorization: Bearer $SUPABASE_ACCESS_TOKEN" \
11
  -H "Content-Type: application/json" \
12
  -d '{
13
    "organization_id": "<org-id>",
14
    "name": "My Project",
15
    "region": "us-east-1",
16
    "db_pass": "<your-secure-password>"
17
  }'

When your project is up and running, go to the Table Editor, create a new table and insert some data.

Alternatively, you can run the following snippet in your project's SQL Editor. This will create a instruments table with some sample data.

1
-- Create the table
2
create table instruments (
3
  id bigint primary key generated always as identity,
4
  name text not null
5
);
6
-- Insert some sample data into the table
7
insert into instruments (name)
8
values
9
  ('violin'),
10
  ('viola'),
11
  ('cello');
12
13
alter table instruments enable row level security;

Make the data in your table publicly readable by adding an RLS policy:

1
create policy "public can read instruments"
2
on public.instruments
3
for select to anon
4
using (true);

Create a SolidJS app

Create a SolidJS app using the degit command.

Terminal

1
npx degit solidjs/templates/js my-app

Install the Supabase client library

The fastest way to get started is to use the supabase-js client library which provides a convenient interface for working with Supabase from a SolidJS app.

Navigate to the SolidJS app and install supabase-js.

Terminal

1
cd my-app && npm install @supabase/supabase-js

Declare Supabase Environment Variables

Create a .env.local file and populate with your Supabase connection variables:

Project URL

Publishable key

Anon key

1
VITE_SUPABASE_URL=<SUBSTITUTE_SUPABASE_URL>
2
VITE_SUPABASE_PUBLISHABLE_KEY=<SUBSTITUTE_SUPABASE_PUBLISHABLE_KEY>

Query data from the app

In App.jsx, create a Supabase client to fetch the instruments data.

Add a getInstruments function to fetch the data and display the query result to the page.

src/App.jsx

1
import { createClient } from "@supabase/supabase-js";
2
import { createResource, For } from "solid-js";
3
4
const supabase = createClient('https://<project>.supabase.co', '<sb_publishable_... or anon key>');
5
6
async function getInstruments() {
7
  const { data } = await supabase.from("instruments").select();
8
  return data;
9
}
10
11
function App() {
12
  const [instruments] = createResource(getInstruments);
13
14
  return (
15
    <ul>
16
      <For each={instruments()}>{(instrument) => <li>{instrument.name}</li>}</For>
17
    </ul>
18
  );
19
}
20
21
export default App;

Start the app

Start the app and go to http://localhost:3000 in a browser and you should see the list of instruments.

Terminal

1
npm run dev