migration-risk-analyzer

What problem does it solve?

Provides a systematic, pre-deployment risk assessment for database migrations by parsing migration scripts and identifying lock contention, downtime estimates, irreversible changes, and rollback needs so teams can avoid outages and data loss.

Core Features & Use Cases

• Operation parsing & classification: Extracts DDL and DML operations from raw SQL or common ORM migration formats and classifies each by lock type and expected impact.
• Duration & downtime estimation: Estimates operation durations using table size heuristics and engine-specific behaviors (PostgreSQL, MySQL).
• Rollback & validation generation: Produces rollback templates for reversible changes, highlights irreversible operations with backup recommendations, and emits pre/post migration validation queries.
• Use Case: Review an Alembic or Flyway migration before production deploy to produce a per-operation risk table, deployment recommendation, and tested validation checklist.

Quick Start

Analyze the attached migration SQL and produce a per-operation risk assessment, lock analysis, estimated downtime, rollback scripts, and pre/post validation queries.