Use Supabase with Vue
Learn how to create a Supabase project, add some sample data to your database, and query the data from a Vue 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/tokens2export SUPABASE_ACCESS_TOKEN="your-access-token"34# List your organizations to get the organization ID5curl -H "Authorization: Bearer $SUPABASE_ACCESS_TOKEN" \6 https://api.supabase.com/v1/organizations78# Create a new project (replace <org-id> with your organization ID)9curl -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 table2create table instruments (3 id bigint primary key generated always as identity,4 name text not null5);6-- Insert some sample data into the table7insert into instruments (name)8values9 ('violin'),10 ('viola'),11 ('cello');1213alter table instruments enable row level security;Make the data in your table publicly readable by adding an RLS policy:
1create policy "public can read instruments"2on public.instruments3for select to anon4using (true);Create a Vue app
-
Create a Vue app using the
npm initcommand.Explore drop-in UI components for your Supabase app.
UI components built on shadcn/ui that connect to Supabase via a single command.
Explore Components
Terminal
1npm init vue@latest my-appInstall 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 Vue app.
Navigate to the Vue app and install supabase-js.
Terminal
1cd my-app && npm install @supabase/supabase-jsDeclare Supabase Environment Variables
Create a .env.local file and populate with your Supabase connection variables:
Project URL
Publishable key
Anon key
1VITE_SUPABASE_URL=<SUBSTITUTE_SUPABASE_URL>2VITE_SUPABASE_PUBLISHABLE_KEY=<SUBSTITUTE_SUPABASE_PUBLISHABLE_KEY>Create the Supabase client
Create a /src/lib directory in your Vue app, create a file called supabaseClient.js and add the following code to initialize the Supabase client:
src/lib/supabaseClient.js
1import { createClient } from '@supabase/supabase-js'23const supabaseUrl = import.meta.env.VITE_SUPABASE_URL4const supabasePublishableKey = import.meta.env.VITE_SUPABASE_PUBLISHABLE_KEY56export const supabase = createClient(supabaseUrl, supabasePublishableKey)Query data from the app
Replace the existing content in your App.vue file with the following code.
src/App.vue
1<script setup>2import { ref, onMounted } from 'vue'3import { supabase } from './lib/supabaseClient'45const instruments = ref([])67async function getInstruments() {8 const { data } = await supabase.from('instruments').select()9 instruments.value = data10}1112onMounted(() => {13 getInstruments()14})15</script>1617<template>18 <ul>19 <li v-for="instrument in instruments" :key="instrument.id">{{ instrument.name }}</li>20 </ul>21</template>Start the app
Start the app and go to http://localhost:5173 in a browser and you should see the list of instruments.
Terminal
1npm run dev