Supabase Skill
Use the supabase CLI to manage Supabase projects and local development.
Projects
List all projects:
supabase projects list
Link to a remote project:
supabase link --project-ref <project-id>
Local Development
Start local Supabase stack (Postgres, Auth, Storage, etc.):
supabase start
Stop local stack:
supabase stop
Check status of local services:
supabase status
Database
Run SQL query:
supabase db execute --sql "SELECT * FROM users LIMIT 10"
Pull remote schema to local:
supabase db pull
Push local migrations to remote:
supabase db push
Reset local database:
supabase db reset
Diff local vs remote schema:
supabase db diff
Migrations
Create a new migration:
supabase migration new <migration-name>
List migrations:
supabase migration list
Apply migrations locally:
supabase migration up
Squash migrations:
supabase migration squash
Edge Functions
List functions:
supabase functions list
Create a new function:
supabase functions new <function-name>
Deploy a function:
supabase functions deploy <function-name>
Deploy all functions:
supabase functions deploy
Serve functions locally:
supabase functions serve
View function logs:
supabase functions logs <function-name>
Storage
List buckets:
supabase storage ls
List objects in a bucket:
supabase storage ls <bucket-name>
Copy file to storage:
supabase storage cp <local-path> ss:///<bucket>/<path>
Download from storage:
supabase storage cp ss:///<bucket>/<path> <local-path>
Secrets
Set a secret for Edge Functions:
supabase secrets set <NAME>=<value>
List secrets:
supabase secrets list
Unset a secret:
supabase secrets unset <NAME>
Type Generation
Generate TypeScript types from database schema:
supabase gen types typescript --local > types/supabase.ts
Generate types from remote:
supabase gen types typescript --project-id <project-id> > types/supabase.ts
Authentication
Login to Supabase:
supabase login
Check current status:
supabase projects list