supabase-deployment

What problem does it solve?

Solves the problem of safely deploying Supabase migrations across multiple environments.

Core Features & Use Cases

• Idempotent migrations: Create and apply SQL changes that can be re-run without duplicating effects, preserving data integrity.
• Local testing & validation: Test migrations locally with standard Supabase commands and compare changes before production.
• Type generation & integration: Generate TypeScript types from the database schema to keep frontend and backend in sync.
• Production deployment workflow: Push migrations to production with verification and rollback considerations, following documented best practices.
• Reference-guided workflow: Access migration patterns, troubleshooting, and deployment steps from the provided refs for consistent operations.

Quick Start

• Create migration: npx supabase migration new your_change_description
• Write idempotent SQL (see refs/migration-patterns.md)
• Test locally: npx supabase db reset
• Generate types: npx supabase gen types typescript --local > src/lib/database/types/database-generated.ts
• Deploy to production: npx supabase db push