1
AI-assisted Migration Pre-Flight Check: catch data-loss and lock risk before db push
Source: supabase/supabase#45217 · opened by @abhijeet-rane
TL;DR Add an AI-assisted "pre-flight check" that runs before supabase db push (CLI) or "Apply migration" (dashboard). It reads the pending migration, analyzes it against a ruleset plus AI review, and surfaces data-loss risks, lock-duration risks, and structural red flags *before* they hit production — not after. The scenario we keep hitting In production this is three separate foot-guns: 1. SET NOT NULL on a non-empty column does a full table scan under AccessExclusiveLock — every row must be validated, and every other query on orders blocks during it. 2. Adding NOT NULL + DEFAULT on a large table rewrites the whole table in Postgres < 11, and on modern versions still takes an exclusive lock. 3. DROP COLUMN legacy_code is destructive and irreversible once replication completes — no confirmation, no dry-run. The CLI and dashboard currently accept all of this without warning. supabase db push just applies it. Splinter catches *runtime* problem…
No pledges yet. Be the first to back this.
Comments
Similar requests
Login Issue: CORS Policy & Preflight Redirect Error on auth.supabase.io
2 votes · 0 comments
DBT Cloud Console
3 votes · 0 comments
Supabase Edge Functions: Deno Lock File v5 Support Request
31 votes · 0 comments
It would be nice to have a jdbc fdw. As the already existing are dead.
1 vote · 0 comments
Using other DBs like Surrealdb or Neo4j for socializing
2 votes · 0 comments
No comments yet.