arpeio-mcp

<!-- mcp-name: io.github.arpe-io/arpeio-mcp -->

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

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

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

Or for local installation with execution support:

pip install arpeio-mcp
claude 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)

{
  "mcpServers": {
    "arpeio": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://arpe-io-arpeio-mcp.hf.space/sse"
      ]
    }
  }
}

#### Local (with execution support)

{
  "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:

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

Gemini CLI

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

{
  "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):

{
  "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

{
  "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

{
  "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:

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

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.7.6, ArpePGSQL 0.4.7, ArpeOracle 0.4.2, ArpeNetezza 0.3.7, ArpeTeradata 0.3.5), 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:

python -m pytest tests/test_evaluations.py -q

License

MIT