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 分