Registry / devops / mcp-migration-advisor

mcp-migration-advisor

library0.2.14jsnpmunverified

MCP server for database migration risk analysis. Version 0.2.14, released under MIT. Supports Flyway (V__*.sql, R__*.sql) and Liquibase XML/YAML changelogs with native parsing. Detects destructive operations, lock risks (ACCESS EXCLUSIVE, SHARE), data loss patterns (column drops, type changes), duplicate changeSet IDs, and rollback incompleteness. Unlike MigrationPilot (PG-only raw SQL), this tool parses Liquibase changelogs natively and works across databases. Requires Node >=20.0.0. Pro tier ($9/month) adds HTML+PDF reports.

devops

npm install mcp-migration-advisor

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · MCP-MIGRATION-ADVI

mcp-migration-advisor

devopsjavascriptv0.2.14

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

server

✓ import { Server } from '@modelcontextprotocol/sdk/server/index.js'

✗ const Server = require('@modelcontextprotocol/sdk')

ESM-only since v1.0. Full path required for type exports.

StdioServerTransport

✓ import { StdioServerTransport } from '@modelcontextprotocol/sdk/server/stdio.js'

✗ import { StdioServerTransport } from '@modelcontextprotocol/sdk'

Subpath export; not available from root.

CallToolRequestSchema

✓ import { CallToolRequestSchema } from '@modelcontextprotocol/sdk/types.js'

✗ import { CallToolRequestSchema } from '@modelcontextprotocol/sdk'

Type schemas are in separate types.js file.

Claude Desktop configuration to enable MCP Migration Advisor for database migration risk analysis.

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

Debug

Known issues

breakingRequires Node.js >= 20.0.0. Older versions will throw an error.

fix

Upgrade Node.js to v20 or later.

affects: >=0.1.0

gotchaThe `analyze_migration` tool expects both `filename` and `sql` parameters; missing either causes a silent failure.

fix

Always provide both filename (e.g., 'V2__add_user_email.sql') and the full SQL content.

affects: >=0.1.0

gotchaLiquibase XML parsing fails if the XML contains a DOCTYPE declaration or external entities (XXE risk blocked).

fix

Remove DOCTYPE declarations from Liquibase changelogs before analysis.

affects: >=0.1.0

deprecatedThe `analyze_liquibase_yaml` tool uses 'yaml' parameter name, but future versions may rename to 'content'.

fix

Pass content under key 'yaml' for now; watch changelog for renaming.

affects: >=0.2.0

gotchaPro license key activation for generate_report tool requires environment variable PRO_LICENSE_KEY; no config file support.

fix

Set PRO_LICENSE_KEY environment variable before starting the MCP server.

affects: >=0.2.0

Errors

Common errors & fixes

Error: Cannot find module '@modelcontextprotocol/sdk/server/index.js'

Missing or wrong version of @modelcontextprotocol/sdk dependency.

fix

Run 'npm install @modelcontextprotocol/sdk' in the project directory.

Error: No such tool: analyze_migration

Tool name mistyped or server not configured correctly.

fix

Use exactly 'analyze_migration' (case-sensitive). Check MCP server configuration in Claude Desktop.

Error: Invalid YAML: ...

Liquibase YAML changelog has syntax errors.

fix

Validate YAML with a YAML linter; ensure indentation is correct and changeSets are properly structured.

Warning: Rollback not defined for changeSet ID '...'

A changeSet is missing rollback instructions.

fix

Add a <rollback> block for each changeSet in Liquibase XML/YAML, or use generate_rollback tool to auto-create rollback SQL.

Upgrade

Version history

0.2.14latest on npm

Audit

Dependencies

@modelcontextprotocol/sdkrequiredMCP protocol implementation

Agent activity

9 hits · last 30 days

node

Resources

githubhttps://github.com/Dmitriusan/mcp-migration-advisor ↗

packagemcp-migration-advisor ↗

homepagehttps://github.com/Dmitriusan/mcp-migration-advisor#readme ↗