Arpeio Mcp

io.github.arpe-ioPublished by GitHub account arpe-iov0.1.1Updated Oct 24, 2026

Arpe.io MCP server for FastBCP, FastTransfer, LakeXpress, MigratorXpress

Overview

AI-generated overview

Wraps Arpe.io data tools (FastBCP, FastTransfer, LakeXpress, MigratorXpress) so an assistant can build, preview and run database export, transfer and…

What you can do
  • Build and preview commands for database export, transfer, lakehouse pipelines and cross-platform migration, with parallelism suggestions and version warnings
  • Execute those commands when the matching Arpe.io binaries are configured
  • Look up product capabilities, formats, supported combinations, workflows and versions
  • Validate a MigratorXpress JSON auth file
  • Search Arpe.io documentation and blog, and fetch release notes per product
  • Report CLI status, suggest a tool from a plain-English use case, and expose capability resources and prompts
When to use it
Useful when you move data between databases, export tables to files or cloud storage, build Parquet lakehouse pipelines, or plan a database migration and want an assistant to assemble and run the right Arpe.io command. Command building and documentation lookup work without any binaries.
Requirements
Runs locally as a Python package installed with pip (stdio transport); a hosted SSE endpoint is also documented. No authentication is declared. Execution requires the Arpe.io binaries downloaded from arpe.io and their paths set via FASTBCP_PATH, FASTTRANSFER_PATH, LAKEXPRESS_PATH or MIGRATORXPRESS_PATH; optional variables cover directories, timeouts, log directories and LOG_LEVEL. Without binaries it is preview-only.
Before you install
The execute tools run real data movement: exports, transfers and migrations can overwrite or restructure target databases and cloud storage, so review the previewed command before running it. MigratorXpress reads a JSON auth file that may hold database credentials. The hosted endpoint sends your requests to a third-party service; the local install keeps execution on your machine.

Installation

In SourceWeft

  1. Open Arpeio Mcp in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README


title: Arpeio MCP emoji: 🛠️ colorFrom: blue colorTo: indigo sdk: docker pinned: false

arpeio-mcp

[PyPI version] [License: MIT]

Unified MCP server for Arpe.io data tools — build, preview, and execute high-performance data commands through AI assistants.

ToolDescription
FastBCPHigh-performance parallel database export to files and cloud
FastTransferHigh-performance parallel data transfer between databases
LakeXpressAutomated database-to-cloud data pipeline as Parquet
MigratorXpressCross-platform database migration with parallel transfer
Arpe ADBC driversArpeMSSQL, ArpePGSQL, ArpeOracle, ArpeNetezza, ArpeTeradata, ArpeDb2: native ADBC drivers returning Apache Arrow (reference info, docs search, release notes)

No binaries required. All tools work in command builder mode out of the box — command building, preview, and informational tools work without any Arpe.io binary installed. To enable execution, download the binaries from arpe.io and set the corresponding *_PATH environment variables.

Connect your AI assistant

A hosted instance is available at https://arpe-io-arpeio-mcp.hf.space/sse — no installation required. For local installation with execution support, use the stdio transport via pip install arpeio-mcp.

ChatGPT | Claude Code | Claude Desktop | Cursor | Gemini CLI | HuggingChat | Kiro IDE | Le Chat (Mistral) | VS Code | Windsurf

ChatGPT

Available for paid plans only (Plus, Pro, Team, and Enterprise).

  1. Open ChatGPT in your browser, go to Settings > Apps and connectors.
  2. Open Advanced settings and enable Developer mode.
  3. Go to Connectors > Browse connectors > Add a new connector.
  4. Set the URL to https://arpe-io-arpeio-mcp.hf.space/sse and save.

Claude Code

shell
claude mcp add --transport sse arpeio https://arpe-io-arpeio-mcp.hf.space/sse

Or for local installation with execution support:

shell
pip install arpeio-mcpclaude mcp add arpeio arpeio-mcp

Claude Desktop

Add the following to your Claude Desktop configuration file:

  • Linux: ~/.config/Claude/claude_desktop_config.json
  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
  • Windows: %APPDATA%\Claude\claude_desktop_config.json
Remote (no installation)
json
{  "mcpServers": {    "arpeio": {      "command": "npx",      "args": [        "mcp-remote",        "https://arpe-io-arpeio-mcp.hf.space/sse"      ]    }  }}
Local (with execution support)
json
{  "mcpServers": {    "arpeio": {      "command": "arpeio-mcp",      "env": {        "FASTBCP_PATH": "/path/to/FastBCP",        "FASTTRANSFER_PATH": "/path/to/FastTransfer",        "LAKEXPRESS_PATH": "/path/to/LakeXpress",        "MIGRATORXPRESS_PATH": "/path/to/MigratorXpress"      }    }  }}

Cursor

  1. Open Cursor Settings and search for "MCP".
  2. Add a new MCP server with the following configuration:
json
{  "mcpServers": {    "arpeio": {      "url": "https://arpe-io-arpeio-mcp.hf.space/sse"    }  }}

Gemini CLI

Add the following to your ~/.gemini/settings.json file:

json
{  "mcpServers": {    "arpeio": {      "uri": "https://arpe-io-arpeio-mcp.hf.space/sse"    }  }}

HuggingChat

  1. In the chat interface, click the + icon, select MCP Servers, then Manage MCP Servers.
  2. Click Add Server.
  3. Set the Server Name to Arpe.io and the Server URL to https://arpe-io-arpeio-mcp.hf.space/sse.
  4. Click Add Server and verify the health check shows Connected.

Kiro IDE

Add the following to your Kiro MCP configuration file (.kiro/settings/mcp.json in your workspace):

json
{  "mcpServers": {    "arpeio": {      "url": "https://arpe-io-arpeio-mcp.hf.space/sse"    }  }}

Le Chat (Mistral)

Available on all plans, including free.

  1. Go to Intelligence > Connectors.
  2. Click Add connector > Custom MCP Connector.
  3. Set the name to Arpe.io and the URL to https://arpe-io-arpeio-mcp.hf.space/sse.
  4. Leave authentication disabled and click Create.

VS Code (GitHub Copilot)

Add the following to your VS Code MCP configuration. Run MCP: Open User Configuration from the Command Palette to open it.

  • Linux: ~/.config/Code/User/mcp.json
  • macOS: ~/Library/Application Support/Code/User/mcp.json
  • Windows: %APPDATA%\Code\User\mcp.json
json
{  "servers": {    "arpeio": {      "url": "https://arpe-io-arpeio-mcp.hf.space/sse",      "type": "sse"    }  }}

Windsurf

Add the following to your Windsurf configuration file:

  • Linux: ~/.codeium/windsurf/mcp_config.json
  • macOS: ~/.codeium/windsurf/mcp_config.json
  • Windows: %USERPROFILE%\.codeium\windsurf\mcp_config.json
json
{  "mcpServers": {    "arpeio": {      "command": "npx",      "args": [        "-y",        "mcp-remote",        "https://arpe-io-arpeio-mcp.hf.space/sse"      ]    }  }}

Local Installation

For full execution support (not just command building), install locally:

bash
pip install arpeio-mcp

Then configure your AI assistant to use the arpeio-mcp command (stdio transport) with optional binary paths — see the Claude Desktop local configuration for an example.

Environment Variables

VariableDescriptionRequired
FASTBCP_PATHPath to FastBCP binaryNo
FASTTRANSFER_PATHPath to FastTransfer binaryNo
LAKEXPRESS_PATHPath to LakeXpress binaryNo
MIGRATORXPRESS_PATHPath to MigratorXpress binaryNo
FASTBCP_DIR_PATHFastBCP directory for LakeXpressNo
FASTTRANSFER_DIR_PATHFastTransfer directory for MigratorXpressNo
*_TIMEOUTPer-tool execution timeout (seconds)No
*_LOG_DIRPer-tool log directoryNo
LOG_LEVELLogging level (DEBUG/INFO/WARNING/ERROR)No

Available Tools (18)

Read-only advisory tools were consolidated into one *_info tool per product (with an action enum) and per-product release-notes tools were merged into a single arpe_release_notes. Auto-parallelism is now suggested inside preview so the typical workflow is 2 calls (preview → execute) instead of 4.

FastBCP (3 tools)

  • fastbcp_info — Read-only advisory: action="formats" | "parallelism" | "workflow" | "version"
  • fastbcp_preview_export — Validate parameters and render the command (auto-suggests parallelism when method is omitted)
  • fastbcp_execute_export — Run the export

FastTransfer (3 tools)

  • fasttransfer_info — Read-only advisory: action="combinations" | "parallelism" | "workflow" | "version"
  • fasttransfer_preview_transfer — Validate parameters and render the command (auto-suggests parallelism)
  • fasttransfer_execute_transfer — Run the transfer

LakeXpress (3 tools)

  • lakexpress_info — Read-only advisory: action="capabilities" | "workflow" | "version"
  • lakexpress_preview_command — Build any LakeXpress command (lxdb_*, config_*, sync, sync[export], sync[publish], run, status, cleanup). On v0.4.0+ binaries, warns when -a / --lxdb_auth_id / --sync_id are missing on sync-family calls
  • lakexpress_execute_command — Run the command

MigratorXpress (4 tools)

  • migratorxpress_info — Read-only advisory: action="capabilities" | "workflow" | "version"
  • migratorxpress_validate_auth_file — Validate the JSON auth file (only file-I/O advisory tool kept separate)
  • migratorxpress_preview_command — Build the migrate command. Accepts the new project tag (v0.6.30+); warns on migration_db_type="postgres" against pre-0.6.32 binaries
  • migratorxpress_execute_command — Run the migration

Arpe ADBC drivers (1 tool)

  • adbc_info — The driver family with current versions (ArpeMSSQL 0.8.0, ArpePGSQL 0.5.2, ArpeOracle 0.4.5, ArpeNetezza 0.3.9, ArpeTeradata 0.3.6, ArpeDb2 0.4.0), or one driver's load name, connection URI, authentication, install command, licence setup and FastBCP adbc_* connection type. The drivers are libraries, so there is no preview/execute step

Meta (4 tools)

  • arpe_get_status — Status of all four CLIs (installed / command-builder-only)
  • arpe_quick_start — Detect the right tool from a plain-English use case and return a workflow guide
  • arpe_release_notes — Return release-notes chunks for any product (product="fastbcp" | "fasttransfer" | "lakexpress" | "migratorxpress", or an ADBC driver load name "arpemssql" | "arpepgsql" | "arpeoracle" | "arpenz" | "arpeteradata"; optional version). MigratorXpress publishes no release-notes pages: its "What's new in 0.7" summary from migratorxpress-docs.arpe.io is returned instead
  • search_docs — BM25 full-text search over arpe.io docs sites (including migratorxpress-docs.arpe.io and adbc-drivers-docs.arpe.io) and blog

Structured output

The command-building, execution, and discovery tools return structured content (outputSchema + structuredContent) alongside the human-readable markdown, so MCP clients can chain calls programmatically instead of parsing prose:

  • *_preview_* → the built command (argv), command_string, masked command_display, explanation, and version warnings. The exact command can be handed straight to the matching *_execute_* tool.
  • *_execute_* → success, return_code, stdout, stderr, and parsed diagnostics.
  • search_docs → ranked results records; arpe_get_status → per-product status; arpe_release_notes → release-notes chunks.

Each payload carries a status field (ok / error) so success and error responses are both machine-checkable.

Prompts (5)

Conversation starters surfaced by clients that support MCP prompts (Claude Desktop, Cursor, etc.): export-table, transfer-data, lakehouse-pipeline, migrate-database, troubleshoot.

Resources (5)

Static capability matrices served as MCP resources so clients can prefetch them without a tool call: arpeio://capabilities/fastbcp-formats, fasttransfer-combinations, lakexpress-capabilities, migratorxpress-capabilities, adbc-drivers.

Evaluations

evaluations/arpeio_eval.xml holds 10 read-only, verifiable questions used to check that an LLM can drive the server to correct answers (tool selection, parallelism recommendations, capability lookups, version gating). A guard test re-derives every answer from the capability registries so the answer key stays honest:

bash
python -m pytest tests/test_evaluations.py -q

License

MIT

Source: README.md at commit d4186c6

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v0.1.1LatestSep 16, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts