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 (17)

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

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", optional version)
• search_docs — BM25 full-text search over arpe.io docs sites 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 (4)

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.

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