audit-database-schema

Scan database migration and schema-evolution code for patterns that risk data loss or migration crashes.

What This Command Does

Launches the database-schema-auditor agent to flag dangerous SQL patterns in migration files — destructive operations, non-idempotent migrations, and foreign-key misuse that breaks under concurrent access.

What It Checks

1. Unsafe ALTER TABLE – column adds without defaults, type changes that lose data, NOT NULL added to populated columns
2. DROP operations – DROP TABLE/DROP COLUMN without an explicit migration-roll-forward path
3. Missing idempotency – migrations that fail on re-run rather than being safely repeatable
4. Foreign-key misuse – REFERENCES without ON DELETE policy, or cascade rules that delete more than intended
5. Transaction safety – multi-statement migrations not wrapped in BEGIN/COMMIT

Related Agent

• database-schema-auditor – The agent that powers this command