Menü
Use when running Supabase CLI commands or investigating local/production database operations
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Use when deploying Cloudflare Workers, managing R2 storage, or working with Cloudflare infrastructure
Use when working with ANTD components, theme tokens, icons, forms, or feedback components (message/notification/modal)
Use when adding, referencing, or serving static assets (images, fonts, videos, 3D models) through the R2 CDN pipeline with type-safe imports
Use when writing or reviewing JavaScript/TypeScript code for style patterns like concise arrows, inline handlers, expression formatting, or when tempted to use eslint-disable
Use when working with environment variables in frontend code
Use when creating or modifying keyboard shortcuts/hotkeys in frontend code
| name | supabase-supabase-cli |
| description | Use when running Supabase CLI commands or investigating local/production database operations |
Reference for Supabase CLI commands for development, testing, and deployment.
general-pnpm-scripts skill to verify wrappers existpnpm sb:dev:types| Command | Purpose |
|---|---|
pnpm sb:dev:start | Start local stack |
pnpm sb:dev:stop | Stop local stack |
npx supabase status | Check running services |
| Command | Purpose |
|---|---|
pnpm sb:dev:new <name> | Create empty migration |
pnpm sb:dev:diff <name> | Generate from UI changes |
pnpm sb:dev:push | Apply migrations (preserves data) |
pnpm sb:dev:reset | Reset + re-run all migrations |
supabase migration list --local | List local migrations |
| Command | Purpose |
|---|---|
supabase status | Get Database URL and service info |
supabase db lint --local | Lint schema for issues |
supabase db push --dry-run | Preview production push |
pnpm sb:prod:push | Push to production |
Use supabase status to get the Database URL for direct psql access:
# Get connection info
supabase status
# Output includes: Database URL: postgresql://postgres:postgres@127.0.0.1:54322/postgres
# Run SQL directly
psql "postgresql://postgres:postgres@127.0.0.1:54322/postgres" -c "SELECT * FROM my_table"
# Complex queries with INSERT/UPDATE
psql "postgresql://postgres:postgres@127.0.0.1:54322/postgres" -c "
INSERT INTO table_name (col1, col2)
SELECT col1, col2 FROM source_table WHERE condition
RETURNING id;
"
When to use direct psql:
| Command | Purpose |
|---|---|
pnpm sb:dev:types | Generate TS types from local |
| Command | Purpose |
|---|---|
supabase functions serve --env-file .env.local | Serve locally |
supabase functions deploy <name> | Deploy to production |
| Flag | Target | Use Case |
|---|---|---|
--local | Local stack | Development, testing |
--linked | Production | Production operations |
--project-ref <ref> | Specific project | Explicit selection |
pnpm sb:dev:start && supabase migration up --local && pnpm sb:dev:types
pnpm sb:dev:new add_feature # Create
# Edit migration file
pnpm sb:dev:push && pnpm sb:dev:types # Apply + types
pnpm sb:dev:reset # Verify from scratch
supabase db lint --local # Check for issues
supabase db push --dry-run # Preview
pnpm sb:prod:push # Deploy
Services won't start (port conflict):
supabase stop && supabase start
Types out of sync:
pnpm sb:dev:types
Migrations out of sync:
supabase migration list --local
supabase migration list --linked
pnpm sb:dev:reset # If corrupted