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

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>

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>

Set a secret for Edge Functions:

supabase secrets set <NAME>=<value>

List secrets:

supabase secrets list

Unset a secret:

supabase secrets unset <NAME>

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

supabase login

Check current status:

supabase projects list