Fivetran MCP

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

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

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

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Capabilities & Tool Schemas (14)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by Fivetran MCP.

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

Documentation Overview

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

server.ts

# Fivetran API
export 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:

Terminal

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:

config.json

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

Step 4: Configure Claude Code

Add to your ~/.claude.json:

config.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

bash

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

bash

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

Read the full README →View source on GitHub →

Related MCP Servers

View all in Developer Tools View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

Last commit

7mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about Fivetran MCP

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "fivetran-mcp": { "command": "uvx", "args": ["fivetran-mcp@latest"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/fivetran-mcp?style=directory)](https://allmcps.com/mcp/fivetran-mcp)

HTML Embed

<a href="https://allmcps.com/mcp/fivetran-mcp"><img src="https://allmcps.com/api/badge/fivetran-mcp?style=directory" alt="Fivetran MCP on AllMCPs" /></a>

Technical Specs & Signals

CategoryDeveloper Tools

5/9 checks healthy over the last 45d

48Quality signal: Fair · 48/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools25/30

Adoption & activity1/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 2d ago via OSV.dev · fivetran-mcp@latest (PyPI)

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 💻 Developer Tools →Best MCP servers for Developers →Alternatives to Fivetran MCP →Install in Claude Desktop Install in Cursor Install in VS Code Setup guides for all 13 MCP clients

Fivetran MCP

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

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

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

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Capabilities & Tool Schemas (14)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by Fivetran MCP.

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

Documentation Overview

Fivetran MCP Server

Note: This repository is built and maintained entirely by Claude Code, Anthropic's AI coding assistant.

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

server.ts

# Fivetran API
export 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:

Terminal

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:

config.json

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

Step 4: Configure Claude Code

Add to your ~/.claude.json:

config.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

bash

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

bash

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

Read the full README →View source on GitHub →

Related MCP Servers

View all in Developer Tools View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

Last commit

7mo ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

2 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about Fivetran MCP

Add the following block to your claude_desktop_config.json under mcpServers: "mcpServers": { "fivetran-mcp": { "command": "uvx", "args": ["fivetran-mcp@latest"] } }

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/fivetran-mcp?style=directory)](https://allmcps.com/mcp/fivetran-mcp)

HTML Embed

<a href="https://allmcps.com/mcp/fivetran-mcp"><img src="https://allmcps.com/api/badge/fivetran-mcp?style=directory" alt="Fivetran MCP on AllMCPs" /></a>

Technical Specs & Signals

CategoryDeveloper Tools

5/9 checks healthy over the last 45d

48Quality signal: Fair · 48/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools25/30

Adoption & activity1/15

Community engagement0/10

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 2d ago via OSV.dev · fivetran-mcp@latest (PyPI)

★ Featured

Moxie Docs MCP

MCP & Agent Skills for Automated Documentation, and codebase conventions + context

Explore Server →

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 💻 Developer Tools →Best MCP servers for Developers →Alternatives to Fivetran MCP →Install in Claude Desktop Install in Cursor Install in VS Code Setup guides for all 13 MCP clients