AI Migration Works on Dev, Fails on Prod Schema: The Fix
An AI-written migration runs clean on an empty dev DB but blows up on prod with constraint, lock, or NULL errors. Fix it with prod-clone testing and safe SQL patterns.
#Database
Articles tagged with #Database
AI-Generated SQL Locks a Hot Table for Minutes
AI wrote an UPDATE or DELETE that holds long locks on a production Postgres table and blocks reads and writes. Cancel it, then rewrite it into lock-friendly batches.
Postgres Autovacuum Stalled by a Long-Running Transaction
Dead tuples climb, the table bloats, and VACUUM logs say dead but not yet removable. One forgotten transaction is pinning the xmin horizon so vacuum reclaims nothing. Find and kill it.
Database Migration Review Prompts for Safe Schema Changes
12 migration review prompts that catch table-locking ALTERs, backfill races, and silent column drops across Postgres, MySQL, and SQLite. Tested against Opus 4.7 and GPT-5.5.