supabase（Supabase 后端开发）

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