SQL Migration Reviewer

Review SQL migrations before they are applied to a database. The checklist below is generic — adapt the project-specific lists (domains, soft-delete columns, RLS helper functions) to your codebase. A worked example for a fictional project is shown in each section so you can see the shape of a real configuration.

Companion skill: for the performance checks in section 7, use the supabase-postgres-best-practices skill.

Configure for your project (read this first)

Perennia BackOffice: if you are working in the BackOffice repo, the concrete config (12 DDD domains, soft-delete table list, private.* RLS helpers, test guardrails) is in references/perennia-backoffice.md. Load it and skip the inference below.