Fivetran MCP Server

Note: This repository is built and maintained entirely by Claude Code, Anthropic's AI coding assistant.

An MCP (Model Context Protocol) server for controlling Fivetran data pipelines. Enables AI assistants like Claude to manage syncs, monitor connection status, and control data pipelines through natural language.

Features

• List connections - View all Fivetran connections with status

• Check sync status - Get detailed status for any connection including tasks and warnings

• Trigger syncs - Start syncs on demand

• Historical resync - Trigger full data resync or resync specific tables

• Pause/Resume - Control connection scheduling

• List groups - View all destination groups

• Test connection - Diagnose connectivity and configuration issues

• Schema visibility - View schemas, tables, and columns for any connection

• Reload schema - Refresh schema configuration from the source

Quick Start

Step 1: Get Fivetran API Credentials

1. Log in to Fivetran Dashboard

2. Click your username (top right corner)

3. Click API Key

4. Click Generate API key

5. Copy both the API Key and API Secret (secret shown only once!)

See Fivetran API Getting Started for more details.

Step 2: Store Credentials

Add to your ~/.env.local (or equivalent):

# Fivetran API
export FIVETRAN_API_KEY="your-api-key"
export FIVETRAN_API_SECRET="your-api-secret"

Then reload:

source ~/.env.local

Step 3: Verify Credentials

Test that your credentials work:

curl -s -X GET "https://api.fivetran.com/v1/account/info" \
  -H "Accept: application/json" \
  -H "Authorization: Basic $(echo -n "$FIVETRAN_API_KEY:$FIVETRAN_API_SECRET" | base64)"

Expected response:

{"code":"Success","data":{"account_id":"...","account_name":"..."}}

Step 4: Configure Claude Code

Add to your ~/.claude.json:

{
  "mcpServers": {
    "fivetran": {
      "type": "stdio",
      "command": "uvx",
      "args": ["fivetran-mcp@latest"],
      "env": {
        "FIVETRAN_API_KEY": "${FIVETRAN_API_KEY}",
        "FIVETRAN_API_SECRET": "${FIVETRAN_API_SECRET}"
      }
    }
  }
}

Step 5: Restart Claude Code

Restart Claude Code to load the new MCP server. You should now have access to Fivetran tools.

Available Tools

Connection Management

Schema & Table Visibility

Limitations

The following capabilities are not available via Fivetran's REST API:

For sync logs and historical data, consider setting up Fivetran's Log Service to stream logs to your data warehouse.

Environment Variables

The server supports two naming conventions:

Development

# Clone the repository
git clone https://github.com/YimingYAN/fivetran-mcp.git
cd fivetran-mcp

# Install dependencies
uv sync

# Run the server locally
uv run fivetran-mcp

Cloud Deployment

Cloudflare Workers (Free)

Deploy to Cloudflare Workers for a hosted MCP endpoint:

cd cloudflare
uv tool install workers-py
npx wrangler login
npx wrangler secret put FIVETRAN_API_KEY
npx wrangler secret put FIVETRAN_API_SECRET
uv run pywrangler deploy

See cloudflare/README.md for detailed instructions.

License

MIT