{
  "markdown": "# FastTransfer MCP Server\n\n<!-- mcp-name: io.github.arpe-io/fasttransfer-mcp -->\n\n[![PyPI](https://img.shields.io/pypi/v/fasttransfer-mcp)](https://pypi.org/project/fasttransfer-mcp/)\n[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)\n[![MCP Registry](https://img.shields.io/badge/MCP-Registry-blue)](https://registry.modelcontextprotocol.io/?q=arpe-io)\n\nA [Model Context Protocol (MCP)](https://modelcontextprotocol.io/) server that exposes [FastTransfer](https://aetperf.github.io/FastTransfer-Documentation/) functionality for efficient data transfer between various database systems.\n\n## Overview\n\nFastTransfer is a high-performance CLI tool for transferring data between databases. This MCP server wraps FastTransfer functionality and provides:\n\n- **Safety-first approach**: Preview commands before execution with user confirmation required\n- **Password masking**: Credentials and connection strings are never displayed in logs or output\n- **Intelligent validation**: Parameter validation with database-specific compatibility checks\n- **Smart suggestions**: Automatic parallelism method recommendations\n- **Version detection**: Automatic binary version detection with capability registry\n- **Comprehensive logging**: Full execution logs with timestamps and results\n\n## MCP Tools\n\n### 1. `preview_transfer_command`\nBuild and preview a FastTransfer command WITHOUT executing it. Shows the exact command with passwords masked. Always use this first.\n\n### 2. `execute_transfer`\nExecute a previously previewed command. Requires `confirmation: true` as a safety mechanism.\n\n### 3. `validate_connection`\nValidate database connection parameters (parameter check only, does not test actual connectivity).\n\n### 4. `list_supported_combinations`\nList all supported source-to-target database combinations.\n\n### 5. `suggest_parallelism_method`\nRecommend the optimal parallelism method based on source database type and table characteristics.\n\n### 6. `get_version`\nReport the detected FastTransfer binary version, supported types, and feature flags.\n\n## Installation\n\n### Prerequisites\n\n- Python 3.10 or higher\n- FastTransfer binary v0.16+ (obtain from [Arpe.io](https://arpe.io))\n- Claude Code or another MCP client\n\n### Setup\n\n1. **Clone or download this repository**:\n   ```bash\n   cd /path/to/fasttransfer-mcp\n   ```\n\n2. **Install Python dependencies**:\n   ```bash\n   pip install -r requirements.txt\n   ```\n\n3. **Configure environment**:\n   ```bash\n   cp .env.example .env\n   # Edit .env with your FastTransfer path\n   ```\n\n4. **Add to Claude Code configuration** (`~/.claude.json`):\n   ```json\n   {\n     \"mcpServers\": {\n       \"fasttransfer\": {\n         \"type\": \"stdio\",\n         \"command\": \"python\",\n         \"args\": [\"/absolute/path/to/fasttransfer-mcp/src/server.py\"],\n         \"env\": {\n           \"FASTTRANSFER_PATH\": \"/absolute/path/to/fasttransfer/FastTransfer\"\n         }\n       }\n     }\n   }\n   ```\n\n5. **Restart Claude Code** to load the MCP server.\n\n6. **Verify installation**:\n   ```\n   # In Claude Code, run:\n   /mcp\n   # You should see \"fasttransfer: connected\"\n   ```\n\n## Configuration\n\n### Environment Variables\n\nEdit `.env` to configure:\n\n```bash\n# Path to FastTransfer binary (required)\nFASTTRANSFER_PATH=./fasttransfer/FastTransfer\n\n# Execution timeout in seconds (default: 1800 = 30 minutes)\nFASTTRANSFER_TIMEOUT=1800\n\n# Log directory (default: ./logs)\nFASTTRANSFER_LOG_DIR=./logs\n\n# Log level (default: INFO)\nLOG_LEVEL=INFO\n```\n\n## Connection Options\n\nThe server supports multiple ways to authenticate and connect:\n\n| Parameter | Description |\n|-----------|-------------|\n| `server` | Host:port or host\\instance (optional with `connect_string` or `dsn`) |\n| `user` / `password` | Standard credentials |\n| `trusted_auth` | Windows trusted authentication |\n| `connect_string` | Full connection string (excludes server/user/password/dsn) |\n| `dsn` | ODBC DSN name (excludes server/provider) |\n| `provider` | OleDB provider name |\n| `file_input` | File path for data input (source only, excludes query) |\n\n## Transfer Options\n\n| Option | CLI Flag | Description |\n|--------|----------|-------------|\n| `method` | `--method` | Parallelism method |\n| `distribute_key_column` | `--distributeKeyColumn` | Column for data distribution |\n| `degree` | `--degree` | Parallelism degree (0=auto, >0=fixed, <0=CPU adaptive) |\n| `load_mode` | `--loadmode` | Append or Truncate |\n| `batch_size` | `--batchsize` | Batch size for bulk operations |\n| `map_method` | `--mapmethod` | Column mapping: Position or Name |\n| `run_id` | `--runid` | Run ID for logging |\n| `data_driven_query` | `--datadrivenquery` | Custom SQL for DataDriven method |\n| `use_work_tables` | `--useworktables` | Intermediate work tables for CCI |\n| `settings_file` | `--settingsfile` | Custom settings JSON file |\n| `log_level` | `--loglevel` | Override log level (error/warning/information/debug/fatal) |\n| `no_banner` | `--nobanner` | Suppress banner output |\n| `license_path` | `--license` | License file path or URL |\n\n## Usage Examples\n\n### PostgreSQL to SQL Server Transfer\n\n```\nUser: \"Copy the 'orders' table from PostgreSQL (localhost:5432, database: sales_db,\n       schema: public) to SQL Server (localhost:1433, database: warehouse, schema: dbo).\n       Use parallel transfer and truncate the target first.\"\n\nClaude Code will:\n1. Call suggest_parallelism_method to recommend Ctid for PostgreSQL\n2. Call preview_transfer_command with your parameters\n3. Show the command with masked passwords\n4. Explain what will happen\n5. Ask for confirmation\n6. Execute with execute_transfer when you approve\n```\n\n### File Import via DuckDB Stream\n\n```\nUser: \"Import /data/export.parquet into the SQL Server 'staging' table\n       using DuckDB stream.\"\n\nClaude Code will use duckdbstream source type with file_input parameter.\n```\n\n### Check Version and Capabilities\n\n```\nUser: \"What version of FastTransfer is installed?\"\n\nClaude Code will call get_version and display the detected version,\nsupported source/target types, and available features.\n```\n\n## Two-Step Safety Process\n\nThis server implements a mandatory two-step process:\n\n1. **Preview** - Always use `preview_transfer_command` first\n2. **Execute** - Use `execute_transfer` with `confirmation: true`\n\nYou cannot execute without previewing first and confirming.\n\n## Security\n\n- Passwords and connection strings are masked in all output and logs\n- Sensitive flags masked: `--sourcepassword`, `--targetpassword`, `--sourceconnectstring`, `--targetconnectstring`, `-x`, `-X`, `-g`, `-G`\n- Use environment variables for sensitive configuration\n- Review commands carefully before executing\n- Use minimum required database permissions\n\n## Testing\n\nRun the test suite:\n\n```bash\n# Run all tests\npython -m pytest tests/ -v\n\n# Run with coverage\npython -m pytest tests/ --cov=src --cov-report=html\n```\n\n## Project Structure\n\n```\nfasttransfer-mcp/\n  src/\n    __init__.py\n    server.py          # MCP server (tool definitions, handlers)\n    fasttransfer.py    # Command builder, executor, suggestions\n    validators.py      # Pydantic models, enums, validation\n    version.py         # Version detection and capabilities registry\n  tests/\n    __init__.py\n    test_command_builder.py\n    test_validators.py\n    test_version.py\n  .env.example\n  requirements.txt\n  CHANGELOG.md\n  README.md\n```\n\n## License\n\nThis MCP server wrapper is provided as-is. FastTransfer itself is a separate product from Arpe.io.\n\n## Related Links\n\n- [FastTransfer Documentation](https://fasttransfer-docs.arpe.io/latest/)\n- [Model Context Protocol](https://modelcontextprotocol.io/)\n",
  "bytes": 7624,
  "sha": "5f1c3afb6bb72cc6e855bb7064cc93fb491c95402465f86e20dbbfcef3b67aee",
  "repo_slug": "arpe-io/fasttransfer-mcp",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_io_github_arpe_io_fasttransfer_mcp_b0c0dd92/readme"
}