---
name: migration-workflow
description: Create, validate, and apply Supabase migrations with idempotent SQL, RLS checks, and types regeneration. Use when the user mentions migrations, db diff, schema changes, or type generation.
---
# Migration Workflow

## Quick Start

1. Identify schema change intent and target tables.
2. Create a new migration using the documented workflow.
3. Validate idempotency and RLS policy coverage.
4. Apply migration to hosted Supabase.
5. Regenerate types and verify.

## Steps

- Follow `docs/DATABASE_PIPELINE.md` and `docs/supabase_branching.md` for the approved flow.
- Prefer repo scripts when available:
  - `scripts/apply-single-migration.mjs`
  - `scripts/apply-remote-migrations.mjs`
- Ensure migration SQL uses `IF NOT EXISTS` and is safe to re‑run.
- After applying: regenerate types in `src/lib/generated/database.types.ts`.

## Checks

- RLS enabled on new tables.
- Policies tested or verified.
- No Docker‑dependent Supabase commands.