An ALTER TABLE that takes an exclusive lock reads exactly like one that does not, right up until production stops. Scoring the file first — and getting the reverse DDL and the conflicting changeSet with it — moves that discovery to before the deploy.
An MCP server for database migration risk analysis. It parses Flyway `V__*.sql` and `R__*.sql` files and Liquibase XML and YAML changelogs natively, extracting changeSets rather than pattern-matching raw text, and works across database types rather than PostgreSQL alone.
- A SQL migration analysed for lock risks, data loss potential and unsafe patterns
- Liquibase XML and YAML changelogs analysed the same way, with changeSets extracted
- A combined risk score from 0 to 100, aggregating lock severity and data loss potential
- Reverse DDL generated to undo a migration, with warnings on the operations that cannot be reversed
- Structural conflicts detected between two migrations — same-table modifications, same-column changes
- A specific safe alternative attached to every risk it reports
Node — run it with `npx mcp-migration-advisor`, or install globally with npm. The analysis is static: the tools read migration files and changelogs, not a live database. A paid Pro tier is advertised for exportable HTML and PDF reports, though the README's purchase link is still a placeholder.
One command — npx -y mcp-migration-advisor