Fivetran MCP

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. Its 14 documented tools cover connection, schema, resync, tables. It runs locally over stdio via the published package.

People connecting data & analytics tools to Claude, Cursor, VS Code, or another MCP client. The project is written in Python.

VERIFIED ACTIVE

LAST COMMIT 2026-02-01 · ★ 2 · #43 OF 75 MAINTAINED DATA & ANALYTICS · VERIFIED 2026-08-25

MIT · Python servers · how we verify → /methodology

01 · Install Fivetran MCP

before you install - you'll need

Set FIVETRAN_API_KEY, FIVETRAN_API_SECRET before connecting.

Claude Code

claude mcp add yimingyan-fivetran-mcp -- uvx fivetran-mcp

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "yimingyan-fivetran-mcp": {
      "command": "uvx",
      "args": [
        "fivetran-mcp"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

pypi package fivetran-mcp - check the name against the project README before installing (PyPI has no namespace ownership)

registry namespace io.github.YimingYAN is GitHub-verified and matches the repo owner

03 · What Fivetran MCP can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can list all connections, optionally filtered by group, get detailed status including tasks, warnings, and sync details, start a sync for a connection (optional force flag), and trigger full historical resync.

Capability map

Tools grouped from the project's README - what Fivetran MCP lets an agent do.

read & search

5 tools - e.g. List all connections, optionally filtered by group; List all groups/destinations; Get complete raw schema configuration for a connection

list_connections · list_groups · get_schema · list_tables · get_table_columns

Connection

5 tools - e.g. Get detailed status including tasks, warnings, and sync details; Pause a connection; Resume a paused connection

get_connection_status · pause_connection · resume_connection · test_connection · get_connection_schema

Resync

2 tools - e.g. Trigger full historical resync; Resync specific tables only (e.g., ["schema.table_name"])

trigger_resync · resync_tables

run & execute

1 tool - e.g. Start a sync for a connection (optional force flag)

trigger_sync

Reload

1 tool - e.g. Refresh schema configuration from the source

reload_schema

Limitations (from the README)

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.

Latest releases

v0.3.0 · 2026-01-13

What's New · New Tool: get_connection_schema · A unified schema inspection tool that provides two modes: · Overview mode: Returns all schemas and tables with counts · Table filter mode: Pass table="schema.table_name"…

v0.2.0 · 2026-01-12

What's New · Improved Error Handling · API errors now show actual Fivetran error messages instead of generic HTTP status codes · Added FivetranAPIError exception class for better error diagnostics · New Schema/Table…

04 · Who maintains Fivetran MCP

fivetran-mcp is maintained by yimingyan. It's the only MCP server we track from this author; the repo dates to Jan 2026.

05 · Facts

repository: github.com/yimingyan/fivetran-mcp
category: data & analytics - ranked #43 of 75 actively-maintained data & analytics servers as of 2026-08-25.
registry: io.github.YimingYAN/fivetran-mcp (active, first published 2026-02-01)
packages: pypi:fivetran-mcp

06 · Fivetran MCP FAQ

Is Fivetran MCP still maintained?

Yes - as of 2026-08-25, its last commit was 2026-02-01. We re-verify nightly.

What can Fivetran MCP do?

How do I install Fivetran MCP?

Run `uvx fivetran-mcp`. The README documents 2 environment variables (FIVETRAN_API_KEY, FIVETRAN_API_SECRET) to set first. Set FIVETRAN_API_KEY, FIVETRAN_API_SECRET before connecting. You can also paste the ready-made client config above.

Does Fivetran MCP run locally?

Yes - it's a stdio server: it runs on your machine (via uvx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to Fivetran MCP

Alternatives to Fivetran MCP

Maintained data & analytics servers if Fivetran MCP isn't the fit.

Pairs well with

Servers that cover what Fivetran MCP doesn't - only shown when the pairing reason fits the companion.

More data & analytics MCP servers · Opn MCP · Zernio · SSH Session MCP · Salesforce Cloud · Picoli MCP

More Python MCP servers · Plaxis · Word MCP Live · Mergetrain · Creator SEO MCP · AI-First Scraper · see all