FAQ, read 10 Nov 2026
30 questions about MCP servers for data, answered with names and dates
How entries are readThe directory
- What is an MCP server for a data tool?
- It is a program that exposes a data tool's functions to an AI agent over the Model Context Protocol. The agent lists the tools, then calls them to search metadata, read lineage or run queries. This directory lists 30 such servers for warehouses, dbt, ingestion connectors, BI tools, catalogs and observability tools, each read on 10 Nov 2026.
- What is the difference between a remote and a local MCP server?
- A remote server is hosted by the vendor and reached by URL, usually with OAuth. A local server runs on your machine, usually over stdio, with credentials in environment variables. Of the 30 servers here, 15 are remote only, 12 offer both, and three run over stdio only: Redshift (AWS Labs), Sifflet and a community Snowflake server.
- Which transports do data MCP servers use?
- Two: stdio for a process the client starts locally, and Streamable HTTP for a server reached over a network. Fivetran's server runs over stdio by default and as a hosted HTTP server with --transport streamable-http. BigQuery's remote server at Google Cloud uses Streamable HTTP. A client that only speaks stdio can reach a remote server through the mcp-remote bridge.
- How does authentication work for data MCP servers?
- It varies by server and the directory records each one. Hosted servers such as Monte Carlo use OAuth 2.1 with Dynamic Client Registration, so calls run as the signed-in user. Others take an API token: Select Star's server uses a Bearer header, and Fivetran's uses one shared API key and secret. Redshift uses AWS credentials.
- Which data MCP servers can write, not only read?
- Read-only entries are few. Select Star's server is read-only with 7 tools. Cube, Hex, OpenMetadata, Sifflet, Sigma and ThoughtSpot are read-write. Sifflet's two state-changing tools open and close incidents. Redshift is read-only by default until ACCESS_MODE is changed, and Airbyte's read-only mode hides run and cancel sync tools.
- What does official mean in this directory?
- Official means the data tool's own vendor publishes the server, such as dbt Labs for dbt-mcp or Google Cloud for the BigQuery remote server. The directory also marks Labs entries, like Snowflake Labs and Databricks Labs, and community entries. One of the 30 is community: isaacwasserman's Snowflake server, version 0.4.0, last released 10 Apr 2025.
- How are entries in this directory read and dated?
- Each entry comes from the server's own repository or documentation, with the version or commit and the date it was read. This edition was read on 10 Nov 2026. A vendor's claim is written as the vendor's, and where nothing was found the entry says none found on 10 Nov 2026.
- What does the Context Weight Index measure?
- It measures the size of each server's published tool definitions in tokens, counted one way for every server. Tool definitions are loaded into the model's context window when a client connects, before any call. The index states a size and nothing else, and it is read from each server's published tool text.
- Why does the directory list servers and not order them by merit?
- Servers differ in what they cover, how they authenticate and what they can change, and those differences do not reduce to one order. The directory lists the 30 servers alphabetically and puts the read facts side by side. The reader decides which facts matter for the situation at hand.
- Does Snowflake publish an official MCP server?
- Yes. Snowflake documents a Snowflake-managed MCP server, remote, with no package version; the docs page follows MCP revision 25 Nov 2025. It offers Cortex Agent, Cortex Search, Cortex Analyst and SQL execution tools. Snowflake Labs' older server, version 1.4.2 from 15 May 2026, is marked deprecated in its README. A community stdio server also exists.
- Does Databricks publish an official MCP server?
- Yes. Databricks documents Databricks-provided MCPs in the system.ai schema, remote, with no version published; the docs page was last updated Nov 9, 2026. It lists four: Genie One, dbsql, web_search and sandbox. Databricks Labs' Unity Catalog server has no tagged release, and its README marks it deprecated in favor of the managed servers.
- Does BigQuery have an official MCP server?
- Yes. Google Cloud documents a BigQuery remote MCP server at bigquery.googleapis.com/mcp over Streamable HTTP, with nine tools and no version number; the reference page shows Last updated 3 Nov 2026. Google's MCP Toolbox for Databases (version v1.16.0, released 5 Nov 2026) also has BigQuery tools, over stdio or HTTP.
- Does Amazon Redshift have an official MCP server?
- Yes. AWS Labs publishes the Amazon Redshift MCP Server in its awslabs/mcp repository, version 0.1.3, uploaded 9 Nov 2026. It runs over stdio, lists 8 tools and uses AWS credentials. It is read-only by default; read-write mode needs ACCESS_MODE, and each write then asks for confirmation unless that prompt is switched off.
- Does dbt publish an official MCP server?
- Yes. dbt Labs publishes dbt-mcp, version 2.10.1, released 3 Nov 2026, with 52 tools. It can be self-hosted or used remotely. Its README lists Semantic Layer, Discovery, lineage, text_to_sql and dbt CLI tools, and warns that CLI tools can modify models and warehouse objects, so run it only with a client you trust.
- Does Fivetran publish an official MCP server?
- Yes. Fivetran publishes fivetran-mcp, version v0.5.1, released 6 Oct 2026. It runs over stdio by default and can run as a hosted HTTP server. Auth is one shared Fivetran API key and secret, not per-user OAuth. Its README says write and delete confirmation is advisory only, and the server does not enforce it.
- Does Airbyte publish an official MCP server?
- Yes. Airbyte documents a hosted Airbyte MCP at mcp.airbyte.com/mcp, remote, with no versioned release, listing 50 tools. It uses OAuth as the signed-in Airbyte user. PyAirbyte 0.71.3, uploaded 26 Oct 2026, also ships an experimental local airbyte.mcp server. The X-MCP-Readonly-Mode header hides run and cancel sync tools.
- Does Tableau publish an official MCP server?
- Yes. Tableau (Salesforce) publishes tableau-mcp, version 6.0.4, released 9 Nov 2026, with 40 tools. It speaks stdio by default and HTTP as an alternative. Hosted use signs in with OAuth 2.1 as each user's Tableau Cloud identity. Self-hosted use takes a personal access token by default, or direct trust, OAuth, passthrough or unified access tokens.
- Does Looker have an official MCP server?
- Looker tools ship inside Google's MCP Toolbox for Databases, version v1.16.0, released 5 Nov 2026. The Toolbox runs as a local stdio server through npx @toolbox-sdk/server, or over HTTP. The directory counts 55 Looker tools. Auth is a Looker API client_id and client_secret, or use_client_oauth to pass the caller's token; the default is false.
- Does Power BI have an official MCP server?
- Yes. Microsoft publishes the Power BI Authoring MCP Server, version 1.0.1, released 6 Nov 2026, with 21 tools. The local server uses stdio and Entra sign-in or a service principal; a hosted preview endpoint uses Streamable HTTP with Entra ID. The --readonly option blocks writes to the semantic model, and read-write is the default.
- Does ThoughtSpot publish an official MCP server?
- Yes. ThoughtSpot publishes the Spotter MCP Server in thoughtspot/mcp-server, version 0.5.0, with its last release dated 6 Jun 2025. It is remote and lists 20 tools. Auth is OAuth to a ThoughtSpot instance, with dynamic client registration or a manually registered client ID and secret. Bearer-token and /sse paths also exist.
- Does Sigma publish an official MCP server?
- Yes. Sigma documents a Sigma-hosted MCP server, remote over HTTP, with no versioned release; the URL is copied from Profile > Integrations. It searches, describes and queries data and builds workbooks. OAuth inherits the user's Sigma permissions, and an API-key path with scope mcp:access is labeled Beta. Its page lists no individual tool names.
- Does Omni publish an official MCP server?
- Yes. Omni documents a hosted Omni MCP Server, remote, with no versioned release, listing 26 tools. It is enabled by an organization setting under AI Hub > MCP, on by default. Auth is OAuth 2.1 with PKCE, or an API key. An Organization API key can act as another user through the X-MCP-User-ID header.
- Does Cube publish an official MCP server?
- Yes. Cube documents a hosted Cube MCP server, remote, with no versioned release, listing 30 tools and read-write access. Auth is OAuth Authorization Code with PKCE, or a Cube API key exchanged for a token. Cube says every tool runs as the authenticated user, with row-level security applied, and that nine tools are annotated destructive.
- Does Hex publish an official MCP server?
- Yes. Hex documents a hosted Hex MCP server at app.hex.tech/mcp, remote, with no versioned release, listing 18 tools and read-write access. Auth is OAuth to the user's workspace. Knowledge tools need the Explorer role or above, and project editing tools need Editor or above. Single-tenant, EU and HIPAA workspaces use their own host.
- Which data catalogs publish official MCP servers?
- Alation (alation-ai-agent-mcp 1.0.0, released 26 Oct 2026, stdio and remote), Atlan (hosted, unversioned, 41 tools, remote), Collibra (chip v0.0.67, released 27 Oct 2026, both) and DataHub (0.8.0, released 21 Oct 2026, both). OpenMetadata ships 2.0.7, released 27 Oct 2026, remote. Alation's remote server does not support dynamic client registration.
- What do Secoda and Select Star publish for MCP?
- Secoda publishes secoda-mcp on GitHub: no releases, main branch last commit 26 Jan 2026, stdio and hosted options, authenticated with one Secoda API token. Select Star documents a hosted, remote, read-only MCP server with 7 tools and no version published, authenticated with an API token as a Bearer header; Snowflake announced on 24 Nov 2025 that it agreed to acquire Select Star.
- Which observability tools publish official MCP servers?
- Monte Carlo runs a hosted server at mcp.getmontecarlo.com/mcp, remote, with no version published and 15 tools. Sifflet publishes sifflet-mcp 0.1.7, released 3 Aug 2026, over stdio. SYNQ (docs titled Coalesce Quality) runs a hosted remote server with no version published and 134 listed tools, using OAuth 2 with PKCE and permission tiers.
- What does Euno's MCP server publish?
- Euno documents a hosted server at api.app.euno.ai/mcp, remote, with no version published, listing 56 tools. Auth is OAuth sign-in or an API key, and the active persona scopes data and actions. Euno's server gives an agent governed context about the data; it does not run the query, which is the job of the warehouse's own server.
- Is there a community MCP server for Snowflake?
- Yes. isaacwasserman's mcp-snowflake-server, version 0.4.0, last released 10 Apr 2025, is the one community entry among the 30. It runs over stdio, lists 8 tools including read_query, write_query and create_table, and uses Snowflake user credentials. Snowflake's own managed server and the deprecated Snowflake Labs server are listed separately.
- How do I report a correction to an entry?
- Use the corrections page on this site. Name the server, the field and the source that shows the change. Each entry carries a version or commit and a read date, so say which one you checked and the date you read the source. That lets the entry be compared with what you saw.
Last reviewed 10 Nov 2026.