AUTOMATIONSWITCH

Fivetran MCP

by Fivetran

Fivetran's official MCP server. Manage Fivetran connectors, sync runs, and destinations from inside agents. 12 GitHub stars and 4 commits on main in the last 30 days.

12·6 tools·Released MAR 2026·NOASSERTION
npx -y fivetran-mcp
Share:

Fivetran's official MCP server. Manage connectors, sync runs, and destinations from inside agents. 12 stars and 4 commits on main in the last 30 days.

Reviewed by M. Nouriel · MAY 2026

INSTALL THIS SERVER

Requires authenticationFIVETRAN_API_KEY plus FIVETRAN_API_SECRET environment variables. Generate at https://fivetran.com/account/settings/api-config.
{ "mcpServers": { "fivetran": { "command": "npx", "args": [ "-y", "fivetran-mcp" ], "env": { "FIVETRAN_API_KEY": "YOUR_API_KEY", "FIVETRAN_API_SECRET": "YOUR_API_SECRET" } } } }
PrereqNPM: `fivetran-mcp`. Generate API credentials at https://fivetran.com/account/settings/api-config. Path: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS).
{ "mcpServers": { "fivetran": { "command": "npx", "args": [ "-y", "fivetran-mcp" ], "env": { "FIVETRAN_API_KEY": "YOUR_API_KEY", "FIVETRAN_API_SECRET": "YOUR_API_SECRET" } } } }
{ "mcpServers": { "fivetran": { "command": "npx", "args": [ "-y", "fivetran-mcp" ], "env": { "FIVETRAN_API_KEY": "YOUR_API_KEY", "FIVETRAN_API_SECRET": "YOUR_API_SECRET" } } } }
{ "mcpServers": { "fivetran": { "command": "npx", "args": [ "-y", "fivetran-mcp" ], "env": { "FIVETRAN_API_KEY": "YOUR_API_KEY", "FIVETRAN_API_SECRET": "YOUR_API_SECRET" } } } }
{ "mcpServers": { "fivetran": { "command": "npx", "args": [ "-y", "fivetran-mcp" ], "env": { "FIVETRAN_API_KEY": "YOUR_API_KEY", "FIVETRAN_API_SECRET": "YOUR_API_SECRET" } } } }

6 TOOLS AVAILABLE

list_connectors
List Fivetran connectors in the account
Read
get_connector
Retrieve a connector configuration and last sync
Read
trigger_sync
Trigger a sync on a Fivetran connector
Admin
list_destinations
List Fivetran destinations
Read
list_groups
List Fivetran connector groups (workspaces)
Read
get_sync_history
Retrieve sync run history with success/failure status
Read

OUR ASSESSMENT

Strengths
  • Fivetran official maintenance.
  • 12 GitHub stars.
  • 4 commits on main in the last 30 days.
  • First data-ingestion vendor MCP in the directory.
  • Pairs with dbt-mcp for full ELT-flavoured data category coverage.
Weaknesses
  • Fivetran account required; per-MAR pricing applies.
  • License NOASSERTION at inspection; treat as proprietary unless vendor clarifies.
  • trigger_sync can incur compute cost; agent prompt path needs review.
Security Notes

API key plus secret carry the connecting user permission scope. Use a service-account API key scoped to the agent flow. trigger_sync runs sync tasks that may incur Fivetran MAR (monthly active rows) cost.

Best For

Data teams running Fivetran who want agents to triage failed syncs and trigger reruns; analytics engineering workflows where the agent monitors data pipelines; teams adopting agent-driven data platform operations.

TECHNICAL DETAILS

Language
typescript
Transport
stdio
Clients
Claude DesktopClaude CodeCursorVS CodeWindsurf
License
NOASSERTION
GitHub
npm
fivetran-mcp
Last Release
fivetran-mcp (npm latest)MAY 6, 2026
First Released
MAR 1, 2026

ADOPTION METRICS

// GitHub Stars
12

// Reading this12 stars on fivetran/fivetran-mcp. 4 commits on main in the last 30 days. License NOASSERTION at inspection.

// Popularity Rank
#9
Globally · #9 in Data / Analytics

// Reading thisPairs with dbt-mcp, Tableau, Power BI, Snowflake, Google Analytics, Apify, BrightData, Firecrawl in data. Fivetran covers ELT data ingestion uniquely.

SOURCES & VERIFICATION

We don't take any single directory's word for it. Before scoring, we cross-reference 5 public MCP sources, install the server ourselves against the clients we cover, and record when we last re-verified.

01
Discovered
Manual submission
First indexed MAY 6, 2026
02
Cross-referenced
5 directories
PulseMCP, MCP.so, Glama, Smithery, Official MCP Registry
03
Verified against
Claude Desktop
Installed and tested across clients
04
Last re-checked
MAY 6, 2026
Weekly re-verification
// How other directories see it

The same server, 5 different lenses. We reconcile these signals into our editorial score, which is why our number sometimes diverges from a directory-aggregate star count.

SourceTheir ratingTheir star countTheir downloadsLast synced
AutomationSwitch This page4editorial12MAY 6, 2026
PulseMCP— unratedunavailableunavailableMAY 6, 2026
MCP.so— unratedunavailableunavailableMAY 6, 2026
Glama— unratedunavailableunavailableMAY 6, 2026
Smithery— unratedunavailableunavailableMAY 6, 2026
Official MCP Registry— unratedunavailableunavailableMAY 6, 2026

// Counts are directory-reported; we don't adjust them. Discrepancies usually come from different snapshot times or star-caching.

OTHER DATA / ANALYTICS MCP SERVERS

Vendor5

Firecrawl

Mendable

Web intelligence layer that turns any URL into LLM-optimised markdown. Handles JavaScript rendering, pagination, and structured extraction so your agent reads the live web instead of stale training data.

6 tools6,202
Official4.6

Google Analytics MCP

Google

Official Google MCP server for Google Analytics 4. Query reports, dimensions, metrics, custom audiences, and admin entities through MCP. 1,981 GitHub stars and 5 commits on main in the last 30 days. Apache-2.0.

7 tools1,981
Vendor4.5

Apify Actors MCP

Apify

Apify Actors as MCP tools: 6,000+ web scrapers, automation actors, and AI agents callable from Claude, Cursor, or any MCP client. Hosted streamable transport at https://mcp.apify.com plus stdio via npx. Dynamic actor discovery at runtime.

7 tools1,179
Official4.5

dbt MCP

dbt Labs

Official dbt Labs MCP server covering SQL execution, Semantic Layer queries, Discovery API, dbt CLI, Admin API, dbt Codegen, dbt LSP, and Product Docs. 41 commits on main in the last 30 days, joint top cadence in this batch.

9 tools551
Official4.5

Tableau MCP

Tableau (Salesforce)

Tableau's official MCP server. Lets agents see and understand Tableau workbooks, datasources, and views over MCP. 259 GitHub stars and 12 commits on main in the last 30 days.

6 tools259
Vendor4.4

Bright Data MCP

Bright Data

Web data extraction over the Bright Data network with two operating modes: Rapid Mode (free, basic search and scrape) and Pro Mode (60+ structured-dataset tools targeting Amazon, LinkedIn, Walmart, Instagram, and more).

7 tools2,336
// Get in touch

DISCUSS YOUR
MCP REQUIREMENTS.

Evaluating a server, scoping an internal deployment, or working out whether MCP is the right fit at all. Start the conversation and we will point you at the right piece of the ecosystem.

Discuss Your MCP Requirements →