Fivetran Mcp

io.github.YimingYAN由 GitHub 账号 YimingYAN 发布v0.3.1更新于 Oct 24, 2026

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

已验证STDIO仅桌面云端与基础设施数据与分析

概览

AI 生成的概览

面向 Fivetran API 的本地 MCP 服务器，让助手列出连接、查看同步状态，并触发、暂停或重同步数据管道。

可以做什么
  • 列出连接和目标组，可按组筛选
  • 查看连接状态、任务与警告，并运行连接诊断测试
  • 触发同步、完整历史重同步，或仅重同步指定表
  • 暂停和恢复连接的调度
  • 查看 schema、表和列信息，并从源端重新加载 schema 配置
适用场景
适用于使用 Fivetran 管理数据管道的场景：想用对话方式检查连接器是否正常、启动同步，或查看哪些表和列已启用，而不必打开 Fivetran 控制台。
运行要求
以本地 Python 包（fivetran-mcp，通过 uvx 启动）经 stdio 运行。需要 Fivetran API key 与 secret，通过环境变量 FIVETRAN_API_KEY 和 FIVETRAN_API_SECRET 提供（也支持 FIVETRAN_SYNC_API_KEY 与 FIVETRAN_SYNC_API_SECRET）。需要访问 Fivetran API 的网络连接。
安装前请注意
服务器持有可控制数据管道的 Fivetran API 凭据，需妥善保管，且 secret 只显示一次。多个工具会改变状态：trigger_sync、trigger_resync、resync_tables、pause_connection、resume_connection 和 reload_schema 可能启动耗时或有影响的任务。API 不提供同步历史、日志和数据类型，助手无法报告过去的运行情况。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Fivetran Mcp，将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Desktop only，通过 STDIO。 STDIO 服务会启动本地进程，因此需要 SourceWeft 桌面宿主。

其他 MCP 客户端

参照 仓库 中的启动说明。

README

Fivetran MCP Server

[PyPI version] [License: MIT] [Python 3.10+] [Built by Claude Code]

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):

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

Then reload:

bash
source ~/.env.local

Step 3: Verify Credentials

Test that your credentials work:

bash
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:

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

Step 4: Configure Claude Code

Add to your ~/.claude.json:

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

bash
# Clone the repositorygit clone https://github.com/YimingYAN/fivetran-mcp.gitcd fivetran-mcp
# Install dependenciesuv sync
# Run the server locallyuv run fivetran-mcp

Cloud Deployment

Cloudflare Workers (Free)

Deploy to Cloudflare Workers for a hosted MCP endpoint:

bash
cd cloudflareuv tool install workers-pynpx wrangler loginnpx wrangler secret put FIVETRAN_API_KEYnpx wrangler secret put FIVETRAN_API_SECRETuv run pywrangler deploy

See cloudflare/README.md for detailed instructions.

License

MIT

来源：README.md，提交 e0a1b26

工具

0
SourceWeft 尚未在沙箱中启动过该软件包，因此其工具未知。

版本历史

1
  1. v0.3.1最新Sep 16, 2026

评分

已满足适用检查项的 50%

该评分衡量此收录条目的完整程度，依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价，也不表示服务器安全或当前可用：可连通性是带日期的检查结果，评分也不包含安装量或用户评价。

  • 近 30 天内可连通25 分

    请保持端点能够响应 MCP 握手；SourceWeft 每 30 天探测一次。

  • 已声明认证方式10 分

    请在注册中心条目中声明凭据请求头，或保持端点能够响应探测，以便判定其认证方式。

  • 已列出工具15 分

    请让服务器在无凭据时响应 tools/list，或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分