English Français العربية

io.github.YimingYAN/fivetran-mcp

Official registry Other

MCP server for Fivetran API - manage syncs, check status, and control data pipelines

Source code Documentation

What can you do with io.github.YimingYAN/fivetran-mcp?

  • 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

Install

Add this to your client's MCP configuration (Claude Desktop: claude_desktop_config.json; Cursor: .cursor/mcp.json; VS Code and others use the same "mcpServers" shape).

PYPI package fivetran-mcp
Claude Code 
claude mcp add fivetran-mcp -e 'FIVETRAN_API_KEY=<your fivetran_api_key>' -e 'FIVETRAN_API_SECRET=<your fivetran_api_secret>' -- uvx fivetran-mcp==0.3.1
JSON configuration (Claude Desktop, Cursor, VS Code) 
{
    "mcpServers": {
        "fivetran-mcp": {
            "command": "uvx",
            "args": [
                "fivetran-mcp==0.3.1"
            ],
            "env": {
                "FIVETRAN_API_KEY": "<your fivetran_api_key>",
                "FIVETRAN_API_SECRET": "<your fivetran_api_secret>"
            }
        }
    }
}

Environment variables

  • FIVETRAN_API_KEY required secret Fivetran API key
  • FIVETRAN_API_SECRET required secret Fivetran API secret

Documentation

From the project's README on GitHub, refreshed weekly. Links open on GitHub.

Contents
  1. Fivetran MCP Server
  2. Features
  3. Quick Start
  4. Available Tools
  5. Limitations
  6. Environment Variables
  7. Development
  8. Cloud Deployment
  9. License

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
ToolDescription
list_connectionsList all connections, optionally filtered by group
get_connection_statusGet detailed status including tasks, warnings, and sync details
trigger_syncStart a sync for a connection (optional force flag)
trigger_resyncTrigger full historical resync
resync_tablesResync specific tables only (e.g., ["schema.table_name"])
pause_connectionPause a connection
resume_connectionResume a paused connection
list_groupsList all groups/destinations
test_connectionRun diagnostic tests to identify connectivity/configuration issues
Schema & Table Visibility
ToolDescription
get_connection_schemaGet schema info with optional table filter (includes columns when filtering)
get_schemaGet complete raw schema configuration for a connection
list_tablesList all tables with enabled status and sync mode
get_table_columnsGet column details for a specific table
reload_schemaRefresh schema configuration from the source

Limitations

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

CapabilityStatusNotes
Column data typesNot availableQuery your destination database directly for type info
Sync history/logsNot availableFivetran uses Log Service which streams to external destinations
Detailed error logs for past syncsNot availableOnly current tasks/warnings are accessible
Row-level sync statusNot availableNot exposed via API
Data quality metricsNot availableNot exposed via 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:

PreferredAlternative
FIVETRAN_API_KEYFIVETRAN_SYNC_API_KEY
FIVETRAN_API_SECRETFIVETRAN_SYNC_API_SECRET

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

Frequently asked questions

What is io.github.YimingYAN/fivetran-mcp?

MCP server for Fivetran API - manage syncs, check status, and control data pipelines

How do I install io.github.YimingYAN/fivetran-mcp?

It runs on your machine. In Claude Code: claude mcp add fivetran-mcp -e 'FIVETRAN_API_KEY=<your fivetran_api_key>' -e 'FIVETRAN_API_SECRET=<your fivetran_api_secret>' -- uvx fivetran-mcp==0.3.1. For other clients, paste the JSON configuration from this page into their MCP settings.

Does io.github.YimingYAN/fivetran-mcp need an API key?

Yes. It expects FIVETRAN_API_KEY, FIVETRAN_API_SECRET, which you set in its configuration.

Is io.github.YimingYAN/fivetran-mcp open source?

Yes. Its code is on GitHub under the MIT license.

Who maintains io.github.YimingYAN/fivetran-mcp?

It is published by YimingYAN. AI.tn lists it but does not maintain or endorse it.

From the official MCP Registry. Listing is not an endorsement: review a server's code and permissions before giving it access to your data.