How do I install Fivetran?

Fivetran is a local plugin. Install it using PyPI package: fivetran-mcp and add the generated configuration snippet to your AI app's MCP config file. Then restart your AI app.

What credentials does Fivetran need?

Fivetran requires the following credentials or environment variables: FIVETRAN_API_KEY, FIVETRAN_API_SECRET. You can find setup instructions on the server detail page.

What AI apps work with Fivetran?

Fivetran uses the Model Context Protocol (MCP) and works with any MCP-compatible AI app, including Claude, ChatGPT / Codex, Gemini, Copilot, Cursor, and more.

Back to Browse

Fivetran MCP Server

by YimingYAN

Developer ToolsUse Caution4.5MCP RegistryLocal

Free

Server data from the Official MCP Registry

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

About

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

Security Report

4.5

Use Caution4.5High Risk

Valid MCP server (0 strong, 3 medium validity signals). 5 known CVEs in dependencies (1 critical, 3 high severity) Package registry verified. Imported from the Official MCP Registry.

8 files analyzed · 6 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

env_vars

Check that this permission is expected for this type of plugin.

HTTP Network Access

Connects to external APIs or services over the internet.

What You'll Need

Set these up before or after installing:

Fivetran API keyRequired

Environment variable: FIVETRAN_API_KEY

Fivetran API secretRequired

Environment variable: FIVETRAN_API_SECRET

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-yimingyan-fivetran-mcp": {
      "env": {
        "FIVETRAN_API_KEY": "your-fivetran-api-key-here",
        "FIVETRAN_API_SECRET": "your-fivetran-api-secret-here"
      },
      "args": [
        "fivetran-mcp-cloudflare"
      ],
      "command": "uvx"
    }
  }
}

Documentation

View on GitHub

From the project's GitHub README.

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

Log in to Fivetran Dashboard
Click your username (top right corner)
Click API Key
Click Generate API key
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

Tool	Description
`list_connections`	List all connections, optionally filtered by group
`get_connection_status`	Get detailed status including tasks, warnings, and sync details
`trigger_sync`	Start a sync for a connection (optional `force` flag)
`trigger_resync`	Trigger full historical resync
`resync_tables`	Resync specific tables only (e.g., `["schema.table_name"]`)
`pause_connection`	Pause a connection
`resume_connection`	Resume a paused connection
`list_groups`	List all groups/destinations
`test_connection`	Run diagnostic tests to identify connectivity/configuration issues

Schema & Table Visibility

Tool	Description
`get_connection_schema`	Get schema info with optional table filter (includes columns when filtering)
`get_schema`	Get complete raw schema configuration for a connection
`list_tables`	List all tables with enabled status and sync mode
`get_table_columns`	Get column details for a specific table
`reload_schema`	Refresh schema configuration from the source

Limitations

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

Capability	Status	Notes
Column data types	Not available	Query your destination database directly for type info
Sync history/logs	Not available	Fivetran uses Log Service which streams to external destinations
Detailed error logs for past syncs	Not available	Only current tasks/warnings are accessible
Row-level sync status	Not available	Not exposed via API
Data quality metrics	Not available	Not 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:

Preferred	Alternative
`FIVETRAN_API_KEY`	`FIVETRAN_SYNC_API_KEY`
`FIVETRAN_API_SECRET`	`FIVETRAN_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

Reviews

No reviews yet

Be the first to review this server!

More Developer Tools MCP Servers

Git

Free

by Modelcontextprotocol · Developer Tools

Read, search, and manipulate Git repositories programmatically

Toleno

Free

by Toleno · Developer Tools

Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.

mcp-creator-python

Free

by mcp-marketplace · Developer Tools

Create, build, and publish Python MCP servers to PyPI — conversationally.

MarkItDown

Free

by Microsoft · Content & Media

Convert files (PDF, Word, Excel, images, audio) to Markdown for LLM consumption

mcp-creator-typescript

Free

by mcp-marketplace · Developer Tools

Scaffold, build, and publish TypeScript MCP servers to npm — conversationally

FinAgent

Free

by mcp-marketplace · Finance

Free stock data and market news for any MCP-compatible AI assistant.

Fivetran MCP Server

About

Security Report

Findings (6)Action required

Permissions Required

What You'll Need

How to Install

Documentation

Fivetran MCP Server

Features

Quick Start

Step 1: Get Fivetran API Credentials

Step 2: Store Credentials

Step 3: Verify Credentials

Step 4: Configure Claude Code

Step 5: Restart Claude Code

Available Tools

Connection Management

Schema & Table Visibility

Limitations

Environment Variables

Development

Cloud Deployment

Cloudflare Workers (Free)

License

Reviews

No reviews yet

More Developer Tools MCP Servers

Git

Toleno

mcp-creator-python

MarkItDown

mcp-creator-typescript

FinAgent

Fivetran MCP Server

About

Security Report

Findings (6)Action required

Permissions Required

What You'll Need

How to Install

Documentation

Fivetran MCP Server

Features

Quick Start

Step 1: Get Fivetran API Credentials

Step 2: Store Credentials

Step 3: Verify Credentials

Step 4: Configure Claude Code

Step 5: Restart Claude Code

Available Tools

Connection Management

Schema & Table Visibility

Limitations

Environment Variables

Development

Cloud Deployment

Cloudflare Workers (Free)

License

Reviews

No reviews yet

More Developer Tools MCP Servers

Git

Toleno

mcp-creator-python

MarkItDown

mcp-creator-typescript

FinAgent