Supabase Deployment

Deploy database migrations safely with idempotent SQL and multi-tenant isolation.

When to Use

• •Creating new database migrations
• •Deploying schema changes to production
• •Troubleshooting migration issues
• •Setting up new environments

Quick Start

# 1. Create migration
npx supabase migration new your_change_description

# 2. Write idempotent SQL (see refs/migration-patterns.md)

# 3. Test locally
npx supabase db reset

# 4. Generate types
npx supabase gen types typescript --local > src/lib/database/types/database-generated.ts

# 5. Deploy to production
npx supabase db push

Project Details

• •Project ID: yvnuayzslukamizrlhwb
• •Region: ap-southeast-2 (Sydney)
• •Pooler (6543): Serverless, API routes
• •Direct (5432): Migrations, admin ops

Pre-Deployment Checklist

• • Migration is idempotent (IF NOT EXISTS, OR REPLACE)
• • Foreign keys have CASCADE/RESTRICT
• • RLS policies created
• • Indexes added for performance
• • Types generated and committed
• • Tested locally with db reset
• • Cultural review (if storyteller-facing)

Critical Tables (Review Required)

• •elder_review_queue - Elder approval workflow
• •cultural_protocols - Community protocols
• •consent_change_log - GDPR audit trail

Reference Files

Related Skills

• •supabase-connection - Database clients
• •supabase-sql-manager - SQL operations
• •cultural-review - Cultural safety check