Agent skill

supabase

Manage Supabase projects, databases, migrations, Edge Functions, and storage using the `supabase` CLI.

View SKILL.md on GitHub Repository
Stars 232
Forks 15

Install this agent skill to your Project

npx add-skill https://github.com/aiskillstore/marketplace/tree/main/skills/dicklesworthstone/supabase

SKILL.md

Supabase Skill

Use the supabase CLI to manage Supabase projects and local development.

Projects

List all projects:

bash
supabase projects list

Link to a remote project:

bash
supabase link --project-ref <project-id>

Local Development

Start local Supabase stack (Postgres, Auth, Storage, etc.):

bash
supabase start

Stop local stack:

bash
supabase stop

Check status of local services:

bash
supabase status

Database

Run SQL query:

bash
supabase db execute --sql "SELECT * FROM users LIMIT 10"

Pull remote schema to local:

bash
supabase db pull

Push local migrations to remote:

bash
supabase db push

Reset local database:

bash
supabase db reset

Diff local vs remote schema:

bash
supabase db diff

Migrations

Create a new migration:

bash
supabase migration new <migration-name>

List migrations:

bash
supabase migration list

Apply migrations locally:

bash
supabase migration up

Squash migrations:

bash
supabase migration squash

Edge Functions

List functions:

bash
supabase functions list

Create a new function:

bash
supabase functions new <function-name>

Deploy a function:

bash
supabase functions deploy <function-name>

Deploy all functions:

bash
supabase functions deploy

Serve functions locally:

bash
supabase functions serve

View function logs:

bash
supabase functions logs <function-name>

Storage

List buckets:

bash
supabase storage ls

List objects in a bucket:

bash
supabase storage ls <bucket-name>

Copy file to storage:

bash
supabase storage cp <local-path> ss:///<bucket>/<path>

Download from storage:

bash
supabase storage cp ss:///<bucket>/<path> <local-path>

Secrets

Set a secret for Edge Functions:

bash
supabase secrets set <NAME>=<value>

List secrets:

bash
supabase secrets list

Unset a secret:

bash
supabase secrets unset <NAME>

Type Generation

Generate TypeScript types from database schema:

bash
supabase gen types typescript --local > types/supabase.ts

Generate types from remote:

bash
supabase gen types typescript --project-id <project-id> > types/supabase.ts

Authentication

Login to Supabase:

bash
supabase login

Check current status:

bash
supabase projects list

Didn't find tool you were looking for?

Be as detailed as possible for better results