MCP server for database migration risk analysis — Flyway and Liquibase XML/YAML/SQL support with lock detection and conflict analysis
MCP server for database migration risk analysis — Flyway and Liquibase XML/YAML/SQL support with lock detection and conflict analysis. Exposed over MCP by the mcp migration advisor mcp server, that capability becomes something an assistant can invoke while it works, not something you go and do afterwards.
MCP server for database migration risk analysis. Detects dangerous schema changes before they hit production.
Everything the assistant can do here goes through one of these:
analyze_migration — Full analysis of a SQL migration file. Returns lock risks, data loss analysis, and recommendationsanalyze_liquibase — Full analysis of a Liquibase XML changelog. Parses changeSets and applies the same lock risk and data loss analysisanalyze_liquibase_yaml — Full analysis of a Liquibase YAML changelog. Parses changeSets from YAML format and applies the same lock risk and data loss analysis. Supports allscore_risk — Quick risk score (0-100) with verdict (LOW/MODERATE/HIGH RISK)generate_rollback — Generate reverse DDL to undo a SQL migration. Produces rollback SQL with warnings for irreversible operationsdetect_conflicts — Detect conflicts between two SQL migration files. Identifies same-table modifications, same-column changes, lock contention risks, and dropInstallation goes through your MCP client rather than a global install: point it at mcp-migration-advisor on npm and it is fetched when the client starts. The copy-paste blocks for Claude Desktop, Claude Code and Cursor are further down this page.
Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. MCP Migration Advisor's toolset — analyze_migration, analyze_liquibase, analyze_liquibase_yaml and 3 more — is a fair guide to whether it matches your workflow. It is maintained by dmitriusan; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against MCP Migration Advisor's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| analyze_migration | Full analysis of a SQL migration file. Returns lock risks, data loss analysis, and recommendations. |
| analyze_liquibase | Full analysis of a Liquibase XML changelog. Parses changeSets and applies the same lock risk and data loss analysis. |
| analyze_liquibase_yaml | Full analysis of a Liquibase YAML changelog. Parses changeSets from YAML format and applies the same lock risk and data loss analysis. Supports all standard change types: createTable, dropTable, addColumn, dropColumn, mo |
| score_risk | Quick risk score (0-100) with verdict (LOW/MODERATE/HIGH RISK). |
| generate_rollback | Generate reverse DDL to undo a SQL migration. Produces rollback SQL with warnings for irreversible operations. |
| detect_conflicts | Detect conflicts between two SQL migration files. Identifies same-table modifications, same-column changes, lock contention risks, and drop dependencies that could cause failures if applied concurrently or in the wrong o |
{
"mcpServers": {
"migration-advisor": {
"command": "npx",
"args": ["-y", "mcp-migration-advisor"]
}
}
}Configuration as documented by the project. Restart the client after saving.
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.