Data and BI - official Fivetran server
Fivetran Agent Context MCP server
Hosted MCP server that exposes a context layer built with Fivetran Context Layer to AI agents, so clients can run read-only SQL over business definitions, metrics and operational data in the connected warehouse. Fivetran hosts it at https://api.fivetran.ai/mcp with OAuth or API key auth.
Last verified 2 tools2 sources
Install
Claude Code
About Claude Codeclaude mcp add --transport http --client-id claude fivetran_ai "https://api.fivetran.ai/mcp"Codex
About Codexcodex mcp add AgentContext \
--url "https://api.fivetran.ai/mcp"Tools
execute_sql- Execute a read-only SQL query against the connected destination warehouse, using the AGENTS schema to discover context.
provide_feedback- Submit feedback about a response, such as when an answer is incorrect.
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Public Preview.
- Requires a context layer built with Fivetran Context Layer and access granted by a Fivetran account admin.
- Users sign in with their Fivetran account; organizations can instead create system keys and pass them as a Bearer authorization header.
- Cursor setup is documented as UI steps only (HTTP server pointing at the URL).
- Fivetran notes the tool interface is subject to change.
More MCP servers for data and BI
- Fivetran
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.
Transport: stdio, Streamable HTTPAuth: API key - AdobeStatus: Beta
Adobe Real-Time CDP MCP server
Adobe-hosted MCP server for querying Real-Time CDP audiences, audience evaluation and export jobs, destinations, sources and flow run history in natural language.
Transport: Streamable HTTPAuth: OAuth - Airbyte
Airbyte Agent MCP server
Hosted MCP server for Airbyte Agents that gives AI agents authenticated read and write access to business apps such as CRMs, support desks and billing tools through Airbyte agent connectors.
Transport: Streamable HTTPAuth: OAuth - AirbyteStatus: Beta
Airbyte MCP server
Hosted MCP server that connects AI agents to an Airbyte Cloud organization to build, monitor and troubleshoot data pipelines, and (with the context layer enabled) read live data directly from supported sources and destinations. A local version runs against self-managed Airbyte Core via the PyAirbyte package.
Transport: Streamable HTTP, stdioAuth: OAuth or API key - AtlanStatus: GA
Atlan MCP server
Hosted MCP server that lets AI clients search the Atlan catalog, traverse lineage, read and update governed metadata, glossaries and data quality rules, and run read-only SQL against connected warehouses. Calls run with the signed-in user's Atlan permissions.
Transport: Streamable HTTPAuth: OAuth or API key - DatabricksStatus: GA
Genie One MCP server
A Databricks-provided MCP (system.ai.genie_one_mcp) governed through Unity Gateway that sends natural-language data questions to Genie One, which writes SQL and returns answers grounded in Genie Ontology with links back to Databricks sources. Unity Catalog permissions are enforced on every request.
Transport: Streamable HTTPAuth: OAuth or API key
Related reading
- What's New in Mastra (Late 2026): Harness, AgentController GA, Eval Gates and MCP 2.xMastra in late 2026: goals, schedules, signals, AgentController GA, eval gates and MCP 2.x, with type-checked TypeScript examples and honest tradeoffs.
- MCP vs A2A vs Function Calling: Which Layer Does What in 2026MCP vs A2A vs function calling compared on the 2026-07-28 MCP spec and A2A 1.0: what each protocol does, where they overlap, and how to stack them.
- Pydantic AI V2 in Late 2026: Capabilities, Graphs, Evals and MCPPydantic AI V2 explained through v2.57.0: capabilities, typed output, Conversation storage, caching, graphs, evals, MCP Apps and Logfire, with checked code.
- Reverse Engineer Anything (REA): What the MCP Server Does and Where the Line IsREA (Reverse Engineer Anything) is an MIT-licensed MCP server that lets Claude Code, Codex or Cursor inspect binaries, Electron apps and APKs. How to try it.
- Claude Opus 5.5 Built a Browser 3D World: The Higgsfield MCP WorkflowClaude Opus 5.5 and Higgsfield MCP built an interactive 3D Library of Alexandria in the browser. The verified connector setup and where the workflow holds up.
- Pi 1.0 Release Guide: MCP, Codemode and Pi DurablePi 1.0 adds built-in MCP through Codemode, a fullscreen TUI by default and Pi Durable. What changed, how to install it, and what breaks on upgrade.
FAQ
What does the Fivetran Agent Context MCP server do?
Hosted MCP server that exposes a context layer built with Fivetran Context Layer to AI agents, so clients can run read-only SQL over business definitions, metrics and operational data in the connected warehouse. The vendor documents 2 tools, including execute_sql and provide_feedback.
How do I add the Fivetran Agent Context MCP server to Claude Code?
Run claude mcp add --transport http --client-id claude fivetran_ai "https://api.fivetran.ai/mcp", copied from Fivetran's docs. This page also has snippets for Codex.
Does the Fivetran Agent Context MCP server need authentication?
Yes, OAuth or API key. Transport: Streamable HTTP. Status: Preview, last checked October 17, 2026.
Sources
Last verified against 2 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.