mcp-migration-advisor

[](https://www.npmjs.com/package/mcp-migration-advisor) [](https://opensource.org/licenses/MIT)

MCP server for database migration risk analysis. Detects dangerous schema changes before they hit production.

Database migration failures cause outages. This tool analyzes your Flyway and Liquibase migrations before they run — detecting destructive operations, lock risks, and data loss patterns.

Unlike MigrationPilot (PG-only, raw SQL analysis), this tool parses Liquibase XML and YAML changelogs natively — extracting changeSets, detecting conflicts between changeSet IDs, and validating rollback completeness. It works across database types, not just PostgreSQL.

• Lock Risk Analysis: Detects DDL operations that acquire heavy table locks (ACCESS EXCLUSIVE, SHARE locks)
• Data Loss Detection: Finds column drops, type changes that truncate, TRUNCATE/DELETE without WHERE
• Risk Scoring: Calculates 0-100 risk score based on severity of detected issues
• Flyway Support: Parses V__*.sql and R__*.sql migration filenames
• Liquibase Support: Parses XML and YAML changelogs with changeSet extraction
• Conflict Detection: Identifies duplicate changeSet IDs and ordering issues
• Rollback Validation: Checks rollback completeness for each changeSet
• Actionable Recommendations: Every risk includes a specific safe alternative

npx mcp-migration-advisor

Or install globally:

npm install -g mcp-migration-advisor

Add to ~/.claude/claude_desktop_config.json:

{
  "mcpServers": {
    "migration-advisor": {
      "command": "npx",
      "args": ["-y", "mcp-migration-advisor"]
    }
  }
}

Try these prompts in Claude:

1. **"Analyze this migration for risks: ALTER