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

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