Skip to main content
Glama
MigratorXpress MCP Server

MigratorXpress MCP Server

by aetperf

MigratorXpress MCP Server

PyPI License: MIT MCP Registry

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.txt

Related MCP server: Legion Database MCP Server

Configuration

Environment Variables

Variable

Default

Description

MIGRATORXPRESS_PATH

./MigratorXpress

Path to MigratorXpress binary

MIGRATORXPRESS_TIMEOUT

3600

Command execution timeout in seconds

MIGRATORXPRESS_LOG_DIR

./logs

Directory for execution logs

LOG_LEVEL

INFO

Server logging level

Copy .env.example to .env and adjust values:

cp .env.example .env

Claude 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 constraints

Or run all steps in a single invocation with --task_list all.

Development

Running Tests

pip install -e ".[dev]"
python -m pytest tests/ -v

License

MIT

Available Tools

6 tools
execute_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

    A4/5.0

    Scored across 6 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: preview vs execute, version info, capabilities listing, workflow suggestions, and auth validation. No overlap in functionality.

    Naming Consistency5/5

    All tools follow a consistent verb_noun snake_case pattern (e.g., execute_command, get_version, list_capabilities). No mixing of conventions.

    Tool Count5/5

    6 tools is well-scoped for a migration server; covers core operations (preview, execute, capabilities, version, workflow suggestion, auth validation) without bloat.

    Completeness4/5

    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

    ActivityNo data
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • -
      license
      Not graded
      quality
      D
      maintenance
      An MCP server that bridges AI assistants with SQL databases, enabling natural language querying across multiple database types with built-in optimization and security.
      3
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      A unified MCP server for querying and managing multiple database types (PostgreSQL, MySQL, SQL Server, etc.) via natural language through AI assistants.
      GPL 3.0
    • A
      license
      Not graded
      quality
      D
      maintenance
      MCP server for connecting to databases (PostgreSQL, MySQL, SQL Server, Redis) enabling SQL queries, table exploration, and Redis key-value operations.
      1
      MIT
    • F
      license
      Not graded
      quality
      D
      maintenance
      MCP server for PostgreSQL database management, enabling AI-assisted schema exploration, stored procedure analysis, test data generation, and safe transaction management via Claude Desktop.
      -