Skip to main content
Watch: I Built an AI App Without Leaving Databricks

Data and BI - official Fivetran server

Fivetran MCP server

Self-hosted Python MCP server from Fivetran's GitHub org that wraps the Fivetran REST API, letting an agent discover endpoints and inspect or manage connections, destinations and other resources. Read-only by default; write and delete scopes are opt-in. It runs locally from git+https://github.com/fivetran/fivetran-mcp (git) with API key auth.

Last verified 5 tools4 sources

Install

Claude Code

About Claude Code
Terminal
claude mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_SCOPE=read \
  --env DISALLOWED_ACTIONS=system-keys:read,users:read:get_user_api_key,users:read:list_api_keys,users:write:create_user_api_key,users:write:rotate_user_api_key,users:delete:delete_user_api_keys \
  -- uvx --from git+https://github.com/fivetran/fivetran-mcp fivetran-mcp

Codex

About Codex
Terminal
codex mcp add fivetran \
  --env FIVETRAN_API_KEY=your-api-key \
  --env FIVETRAN_API_SECRET=your-api-secret \
  --env FIVETRAN_SCOPE=read \
  --env DISALLOWED_ACTIONS=system-keys:read,users:read:get_user_api_key,users:read:list_api_keys,users:write:create_user_api_key,users:write:rotate_user_api_key,users:delete:delete_user_api_keys \
  -- uvx --from git+https://github.com/fivetran/fivetran-mcp fivetran-mcp

Cursor

About Cursor
JSON
{
  "mcpServers": {
    "fivetran": {
      "command": "uvx",
      "args": ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_SCOPE": "read",
        "DISALLOWED_ACTIONS": "system-keys:read,users:read:get_user_api_key,users:read:list_api_keys,users:write:create_user_api_key,users:write:rotate_user_api_key,users:delete:delete_user_api_keys"
      }
    }
  }
}

Generic

JSON
{
  "mcpServers": {
    "fivetran": {
      "command": "uvx",
      "args": ["--from", "git+https://github.com/fivetran/fivetran-mcp", "fivetran-mcp"],
      "env": {
        "FIVETRAN_API_KEY": "your-api-key",
        "FIVETRAN_API_SECRET": "your-api-secret",
        "FIVETRAN_SCOPE": "read",
        "DISALLOWED_ACTIONS": "system-keys:read,users:read:get_user_api_key,users:read:list_api_keys,users:write:create_user_api_key,users:write:rotate_user_api_key,users:delete:delete_user_api_keys"
      }
    }
  }
}

Tools

list_endpoints
Discover Fivetran API endpoints by category or search term.
get_schema
Return parameters, request body and response schema for an endpoint, optionally with service-specific config fields.
connections_read
Execute read endpoints in the connections group (one generated <resource>_<action> tool per allowed pair).
connections_write
Execute write endpoints in the connections group, such as sync_connection.
destinations_delete
Execute delete endpoints in the destinations group.

As documented on October 17, 2026. A running server reports its current list through tools/list.

Notes and caveats

  • Published in Fivetran's official GitHub org (MIT, copyright Fivetran); the latest GitHub release is v0.5.1, published 2026-10-06, and pyproject.toml is already at 0.5.2.
  • No support level is stated, and a November 2025 Fivetran blog post said Fivetran did not then have an officially supported MCP server.
  • Not on PyPI under this name: the fivetran-mcp and mcp-fivetran PyPI names belong to unrelated projects, so install from the git URL.
  • Uses a Fivetran API key and secret; FIVETRAN_SCOPE defaults to read, and the README recommends a DISALLOWED_ACTIONS denylist for credential endpoints.
  • Execution tools are generated per resource/action pair, so the tool list varies with scope.
  • Streamable HTTP mode takes Basic auth per request; OAuth resource-server mode is not yet functional.

More MCP servers for data and BI

Related reading

FAQ

What does the Fivetran MCP server do?

Self-hosted Python MCP server from Fivetran's GitHub org that wraps the Fivetran REST API, letting an agent discover endpoints and inspect or manage connections, destinations and other resources. Read-only by default; write and delete scopes are opt-in. The vendor documents 5 tools, including list_endpoints, get_schema, connections_read and connections_write.

How do I add the Fivetran MCP server to Claude Code?

Fivetran documents a Claude Code config; copy it from the Claude Code section of this page. Snippets for Codex, Cursor and Generic are there too.

Does the Fivetran MCP server need authentication?

Yes, API key. Transport: stdio, Streamable HTTP. Status: Unlabelled, last checked October 17, 2026.

Sources

Last verified against 4 Fivetran pages, then re-checked independently.

Newsletter

New MCP servers, the week they ship

One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.