MigratorXpress MCP Server
Provides tools for database migration from various source systems (Oracle, SQL Server, Netezza, PostgreSQL) to PostgreSQL or SQL Server, using the MigratorXpress engine.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MigratorXpress MCP Server suggest workflow for Oracle to PostgreSQL"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MigratorXpress MCP Server
A Model Context Protocol (MCP) server for MigratorXpress, enabling database migration between heterogeneous database systems through AI assistants.
MigratorXpress supports migrating from Oracle, PostgreSQL, SQL Server, and Netezza to PostgreSQL or SQL Server targets.
Installation
pip install -e .Or install dependencies directly:
pip install -r requirements.txtRelated MCP server: Legion Database MCP Server
Configuration
Environment Variables
Variable | Default | Description |
|
| Path to MigratorXpress binary |
|
| Command execution timeout in seconds |
|
| Directory for execution logs |
|
| Server logging level |
Copy .env.example to .env and adjust values:
cp .env.example .envClaude Code Configuration
Add to your Claude Code MCP settings:
{
"mcpServers": {
"migratorxpress": {
"command": "python",
"args": ["-m", "src.server"],
"cwd": "/path/to/migratorxpress-mcp",
"env": {
"MIGRATORXPRESS_PATH": "/path/to/MigratorXpress"
}
}
}
}Tools
1. preview_command
Build and preview a MigratorXpress CLI command without executing it. License text is automatically masked in the display output.
Required parameters: auth_file, source_db_auth_id, source_db_name, target_db_auth_id, target_db_name, migration_db_auth_id
2. execute_command
Execute a previously previewed command. Requires confirmation: true as a safety mechanism.
3. validate_auth_file
Validate that an authentication file exists, is valid JSON, and optionally check for specific auth_id entries.
4. list_capabilities
List supported source/target databases, tasks, migration DB modes, load modes, and FK modes.
5. suggest_workflow
Given a source database type, target database type, and optional constraint flag, suggest the full sequence of migration tasks with example commands.
6. get_version
Report MigratorXpress version and capabilities.
Workflow Example
A typical migration from Oracle to PostgreSQL:
Step 1: translate — Translate Oracle DDL to PostgreSQL-compatible DDL
Step 2: create — Create target tables from translated DDL
Step 3: transfer — Transfer data from source to target
Step 4: diff — Verify row counts match between source and target
Step 5: copy_pk — Copy primary key constraints
copy_ak — Copy alternate key (unique) constraints
copy_fk — Copy foreign key constraintsOr run all steps in a single invocation with --task_list all.
Development
Running Tests
pip install -e ".[dev]"
python -m pytest tests/ -vLicense
MIT
Available Tools
6 toolsexecute_commandA
Execute a MigratorXpress command that was previously previewed. IMPORTANT: You must set confirmation=true to execute. This is a safety mechanism to prevent accidental execution.
Inputs: command (required), confirmation (required).
get_versionA
Get the detected MigratorXpress binary version, capabilities, and supported databases, tasks, and modes.
Inputs: no named parameters.
list_capabilitiesA
List supported source databases, target databases, migration database types, tasks, migration DB modes, load modes, and FK modes.
Inputs: no named parameters.
preview_commandA
Build and preview a MigratorXpress CLI command WITHOUT executing it. This shows the exact command that will be run. Use this FIRST before executing any command. License text is masked in the display output.
Inputs: auth_file (required), source_db_auth_id (required), source_db_name (required), target_db_auth_id (required), +37 more.
suggest_workflowA
Given a source database type, target database type, and optional constraint flag, suggest the full sequence of MigratorXpress tasks with example commands.
Inputs: source_type (required), target_type (required), include_constraints.
validate_auth_fileA
Validate that an authentication file exists, is valid JSON, and optionally check for specific auth_id entries.
Inputs: file_path (required), required_auth_ids.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 6 tools
Each tool has a clearly distinct purpose: preview vs execute, version info, capabilities listing, workflow suggestions, and auth validation. No overlap in functionality.
All tools follow a consistent verb_noun snake_case pattern (e.g., execute_command, get_version, list_capabilities). No mixing of conventions.
6 tools is well-scoped for a migration server; covers core operations (preview, execute, capabilities, version, workflow suggestion, auth validation) without bloat.
The set covers essential migration workflows: planning (suggest_workflow), preview, execution, and validation. Minor gaps like explicit migration status tracking do not hinder core usage.
Maintenance
Related MCP Connectors
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Related MCP Servers
- -licenseNot gradedqualityDmaintenanceAn MCP server that bridges AI assistants with SQL databases, enabling natural language querying across multiple database types with built-in optimization and security.3-
- AlicenseNot gradedqualityDmaintenanceA unified MCP server for querying and managing multiple database types (PostgreSQL, MySQL, SQL Server, etc.) via natural language through AI assistants.GPL 3.0
- AlicenseNot gradedqualityDmaintenanceMCP server for connecting to databases (PostgreSQL, MySQL, SQL Server, Redis) enabling SQL queries, table exploration, and Redis key-value operations.1MIT
- FlicenseNot gradedqualityDmaintenanceMCP server for PostgreSQL database management, enabling AI-assisted schema exploration, stored procedure analysis, test data generation, and safe transaction management via Claude Desktop.-