Fastbcp MCP server

FastBCP MCP Server

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

A Model Context Protocol (MCP) server that exposes FastBCP functionality for exporting data from databases to files (CSV, TSV, JSON, BSON, Parquet, XLSX, Binary) with optional cloud storage targets.

Overview

FastBCP is a high-performance CLI tool for exporting data from databases to files. This MCP server wraps FastBCP functionality and provides:

• Safety-first approach: Preview commands before execution with user confirmation required
• Password masking: Credentials and connection strings are never displayed in logs or output
• Intelligent validation: Parameter validation with database-specific compatibility checks
• Smart suggestions: Automatic parallelism method recommendations
• Version detection: Automatic binary version detection with capability registry
• Comprehensive logging: Full execution logs with timestamps and results

MCP Tools

1. previewexportcommand

Build and preview a FastBCP export command WITHOUT executing it. Shows the exact command with passwords masked. Always use this first.

2. execute_export

Execute a previously previewed command. Requires confirmation: true as a safety mechanism.

3. validate_connection

Validate source database connection parameters (parameter check only, does not test actual connectivity).

4. listsupportedformats

List all supported source databases, output formats, and storage targets.

5. suggestparallelismmethod

Recommend the optimal parallelism method based on source database type and table characteristics.

6. get_version

Report the detected FastBCP binary version, supported types, and feature flags.

Installation

Prerequisites

• Python 3.10 or higher
• FastBCP binary v0.29+ (obtain from Arpe.io)
• Claude Code or another MCP client

Setup

1. Clone or download this repository:

cd /path/to/fastbcp-mcp

1. Install Python dependencies:

pip install -r requirements.txt

1. Configure environment:

cp .env.example .env
   # Edit .env with your FastBCP path

1. Add to Claude Code configuration (~/.claude.json):

{
     "mcpServers": {
       "fastbcp": {
         "type": "stdio",
         "command": "python",
         "args": ["/absolute/path/to/fastbcp-mcp/src/server.py"],
         "env": {
           "FASTBCP_PATH": "/absolute/path/to/FastBCP"
         }
       }
     }
   }

1. Restart Claude Code to load the MCP server.

1. Verify installation:

# In Claude Code, run:
   /mcp
   # You should see "fastbcp: connected"

Configuration

Environment Variables

Edit .env to configure:

# Path to FastBCP binary (required)
FASTBCP_PATH=./fastbcp/FastBCP

# Execution timeout in seconds (default: 1800 = 30 minutes)
FASTBCP_TIMEOUT=1800

# Log directory (default: ./logs)
FASTBCP_LOG_DIR=./logs

# Log level (default: INFO)
LOG_LEVEL=INFO

Connection Options

The server supports multiple ways to authenticate and connect:

Shortened. The full README is on GitHub.