AgentSkillsCN

supabase-connection

Supabase-Connection

SKILL.md

Supabase Connection

Database connections, migrations, and operational processes for Empathy Ledger.

Project Details

  • •ID: yvnuayzslukamizrlhwb
  • •Region: ap-southeast-2 (Sydney)
  • •Dashboard: supabase.com/dashboard/project/yvnuayzslukamizrlhwb

Connection Types

TypePortUse For
Pooler6543API routes, serverless, high concurrency
Direct5432Migrations, admin tasks

Client Selection

ScenarioClientFile
Client componentsBrowser@/lib/supabase/client
Server/API routesServer@/lib/supabase/client-ssr
Admin/bypasses RLSService Role@/lib/supabase/service-role-client

Quick Commands

bash
# Link project
npx supabase link --project-ref yvnuayzslukamizrlhwb

# Migration workflow
npx supabase migration new feature_name
npx supabase db push --dry-run
npx supabase db push

# Generate types
npx supabase gen types typescript --project-ref yvnuayzslukamizrlhwb > src/types/database-generated.ts

Reference Files

TopicFile
Client types & usagerefs/clients.md
Migration processrefs/migrations.md
Troubleshootingrefs/troubleshooting.md

Environment Variables

Check .env.local for:

  • •NEXT_PUBLIC_SUPABASE_URL
  • •NEXT_PUBLIC_SUPABASE_ANON_KEY
  • •SUPABASE_SERVICE_ROLE_KEY (server only)
  • •DATABASE_URL

Related Skills

  • •supabase-sql-manager - SQL patterns
  • •supabase-deployment - Deploy process
  • •empathy-ledger-codebase - Architecture