# Migration Workflow > 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. Use when this capability is needed. - Skill: `tomevault-io/migration-workflow` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/migration-workflow` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/migration-workflow/raw - Safety review: pending - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Data & Analytics - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/migration-workflow --- # 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. --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/jeduardo622) — claim your Tome and manage your conversions.