Use Supabase with SolidJS

<$Partial path="quickstart_db_setup.mdx" />

3. Create a SolidJS app

Create a SolidJS app using the degit command.

npx degit solidjs/templates/js my-app

4. Install Supabase's Agent Skills (optional)

Supabase's Agent Skills is a curated set of instructions that give your AI agent procedural knowledge about working with Supabase.

Install them so your AI coding agent can produce more accurate, reliable code using current Supabase patterns, such as authentication, server-side rendering, and database migrations, rather than relying solely on training data.

To install, run the following command in the root of your project:

npx skills add supabase/agent-skills

5. 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.

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

6. Declare Supabase environment variables

Create a .env.local file and populate with your Supabase connection variables that you can get from the helper below, or from the project Connect panel:

VITE_SUPABASE_URL=<SUBSTITUTE_SUPABASE_URL>
VITE_SUPABASE_PUBLISHABLE_KEY=<SUBSTITUTE_SUPABASE_PUBLISHABLE_KEY>

<$Partial path="api_settings.mdx" variables={{ "framework": "solidjs", "tab": "frameworks" }} />

7. 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.

import { createClient } from '@supabase/supabase-js'
import { createResource, For } from 'solid-js'

const supabase = createClient(
  import.meta.env.VITE_SUPABASE_URL,
  import.meta.env.VITE_SUPABASE_PUBLISHABLE_KEY
)

async function getInstruments() {
  const { data } = await supabase.from('instruments').select()
  return data
}

function App() {
  const [instruments] = createResource(getInstruments)

  return (
    <ul>
      <For each={instruments()}>{(instrument) => <li>{instrument.name}</li>}</For>
    </ul>
  )
}

export default App

8. Start the app

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

npm run dev

Next steps

• Set up Auth for your app
• Insert more data into your database
• Upload and serve static files using Storage