supabase

Setup

npm i -g supabase

Verify installation:

supabase --version

Always use --output json flag when calling commands programmatically (where supported).

Authentication

supabase login

Resources

Local Development

Command	Description
supabase init	Initialize a new Supabase project locally
supabase start	Start local Supabase stack (Postgres, Auth, Storage, etc.)
supabase stop	Stop local Supabase stack
supabase status	Show status of local Supabase services

Projects

Command	Description
supabase projects list	List all remote projects
supabase link --project-ref <ref>	Link local project to remote

Database

Command	Description
supabase db push	Push local migrations to remote database
supabase db pull	Pull remote schema changes into local migrations
supabase db reset	Reset local database to current migrations
supabase db diff --schema public	Diff local database against migrations
supabase db lint	Lint database for common issues

Migrations

Command	Description
supabase migration new <name>	Create a new migration file
supabase migration list	List all migrations and their status
supabase migration repair --status applied <version>	Repair migration history

Edge Functions

Command	Description
supabase functions new <name>	Create a new edge function
supabase functions serve	Serve functions locally
supabase functions deploy <name>	Deploy a function to remote
supabase functions delete <name>	Delete a remote function
supabase functions list	List all deployed functions

Type Generation

Command	Description
supabase gen types typescript	Generate TypeScript types from database schema
supabase gen types typescript --local	Generate types from local database
supabase gen types typescript --project-id <ref>	Generate types from remote project

Secrets

Command	Description
supabase secrets list	List all secrets
supabase secrets set KEY=value	Set a secret
supabase secrets unset KEY	Remove a secret

Storage

Command	Description
supabase storage ls	List storage buckets
supabase storage ls s3://<bucket>	List objects in a bucket
supabase storage cp <local> s3://<bucket>/<path>	Upload a file
supabase storage rm s3://<bucket>/<path>	Remove a file

Global Flags

Flag	Description
--output json	Output result as JSON
--project-ref <ref>	Specify remote project reference
--debug	Enable debug output
--workdir <path>	Set working directory