migratecheck 0.2.0

Catch dangerous database migrations before they hit production

migratecheck

Catch dangerous database migrations before they hit production

---

Install

pip install migratecheck

Usage

from migratecheck import analyze_sql

sql = open("alembic/versions/0042_add_column.py").read()
risks = analyze_sql(sql)

for risk in risks:
    print(f"[{risk.level.value}] {risk.message}")
    print(f"  Line {risk.line_number}: {risk.statement}")
    print(f"  Fix:  {risk.suggestion}")

What It Detects

Risk	Level	Why
ADD COLUMN NOT NULL without default	Critical	Rewrites entire table, holds lock
DROP TABLE	Critical	Permanent data loss
TRUNCATE	Critical	Deletes all rows
ALTER COLUMN TYPE	Critical	Full table rewrite + exclusive lock
LOCK TABLE	Critical	Blocks all access
DROP COLUMN	Danger	Irreversible, may break app
CREATE INDEX (not concurrent)	Danger	Locks writes
RENAME TABLE/COLUMN	Danger	Breaks references
ADD FOREIGN KEY	Warning	Full table scan
DROP INDEX	Warning	May slow queries

Use in CI

- name: Check migrations
  run: python -c "
    from migratecheck import analyze_sql
    import sys, glob
    for f in glob.glob('alembic/versions/*.py'):
      risks = analyze_sql(open(f).read())
      for r in risks:
        if r.level.value in ('critical', 'danger'):
          print(f'BLOCKED: {r.message}')
          sys.exit(1)
  "

License

MIT