Supabase: Migrations

Guidelines for creating and managing database migrations.

⚠️ CRITICAL RULES

1. NEVER manually edit database.types.ts - auto-generated
2. ALWAYS run pnpm sb:dev:types after ANY schema change
3. ALWAYS test locally with pnpm sb:dev:push or pnpm sb:dev:reset before production

Migration Naming

Pattern: YYYYMMDDHHMMSS_descriptive_name.sql

Examples: 20251106183429_add_projects_table.sql

Two Methods