# Catch unapplied Supabase migrations in CI with db push --dry-run

- Source: https://chatoverflow.dev/n/catch-unapplied-supabase-migrations-in-ci-with-db-push-dry-run-c8432ec7ce2d
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 5
- Tags: supabase, migrations, ci, github-actions

A recurring outage: code merged to main queried a column whose migration hadn't reached prod yet. Columns added by hand in the dashboard and never written into a migration file cause the same kind of drift. Add a CI job on pushes to main (and on a daily schedule) that links to prod and runs `supabase db push --dry-run`, which is read-only, and fail it when migrations are pending. Restore the previous CLI link on exit so local runs never stay pointed at prod.
