Agent access · Context and connections

Which analytics and BI tools have an MCP server?

8 of 15 tools do, according to their public docs, and 4 partly.

Yes: Databricks, Snowflake, Omni, Sigma, BigQuery, Metabase, Alteryx, MotherDuck. Partly: Hex, Looker, Tableau, Power BI.

The question we asked: Does the vendor support an MCP server with documented authentication for outside agents?

Prompt your agent about thisClaudeChatGPT
Grading standard

A vendor-supported MCP server gives outside agents access to the customer’s analytical objects or data, with documented authentication and no customer-built middleware. A vendor-supported server the customer operates, or one in preview, earns partly. A server built by the community or by customers, or one that only searches documentation, does not count.

Databricks

Yes
Quoted from Databricks’s docsThe Genie One MCP is generally available.
Source: docs.databricks.com/aws/en/agents/mcp-tools/built-in-mcp-services · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly (preview)

Snowflake

Yes
Quoted from Snowflake’s docsThe Snowflake-managed MCP server lets AI agents securely retrieve data from Snowflake accounts without needing to deploy separate infrastructure.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docs OAuth 2.1 - Recommended. Streamlined setup through your browser. Omni creates API keys on your behalf automatically. Requires Personal Access Tokens (PATs) to be enabled for your organization.
Source: docs.omni.co/ai/mcp · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Hex

Partlypreview
Quoted from Hex’s docsThe Hex MCP server enables AI assistants to interact directly with your Hex workspace.
Source: learn.hex.tech/docs/api-integrations/mcp-server · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini yes (preview)

Sigma

Yes
Quoted from Sigma’s docsThe Sigma MCP server allows you to use natural language to interact programmatically with your Sigma organization using Model Context Protocol (MCP) tools.
Source: help.sigmacomputing.com/docs/use-sigma-mcp-server · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

BigQuery

Yes
Quoted from BigQuery’s docsBigQuery MCP servers use the OAuth 2.0 protocol with IAM for authentication and authorization.
Source: docs.cloud.google.com/bigquery/docs/use-bigquery-mcp · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Looker

Partlypreview
Quoted from Looker’s docsThe Looker-managed MCP server is a built-in integration that embeds a Model Context Protocol (MCP) server directly into the Looker platform.
Source: cloud.google.com/looker/docs/mcp · checked Oct 26, 2026 · quoted by Claude
Claude partly (preview) · GPT partly (preview) · Gemini partly (preview)

Tableau

Partly
Quoted from Tableau’s docsConnecting your knowledge graph to the Tableau MCP server enables Tableau Agent and other agents to query your knowledge graph.
Source: help.tableau.com/current/online/en-us/tableau_knowledge_start.htm · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes · Gemini partly

Power BI

Partly
Quoted from Power BI’s docsThe Power BI Authoring MCP server gives an AI agent the tools to create and change Power BI semantic models.
Source: learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp · checked Oct 26, 2026 · quoted by Gemini
Claude partly (preview) · GPT partly (preview) · Gemini partly

Metabase

Yes
Quoted from Metabase’s docsMetabase includes an MCP (Model Context Protocol) server that lets AI clients connect directly to your Metabase, all scoped to the connecting person's permissions.
Source: www.metabase.com/docs/latest/ai/mcp · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Alteryx

Yes
Quoted from Alteryx’s docsThe Alteryx MCP Server connects your datasets, workflows, and analytic apps capabilities to supported AI apps and MCP clients.
Source: help.alteryx.com/aac/en/agent-studio/alteryx-mcp-server.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

MotherDuck

Yes
Quoted from MotherDuck’s docsThe MotherDuck MCP Server lets AI assistants query and explore your databases using the Model Context Protocol (MCP).
Source: motherduck.com/docs/key-tasks/ai-and-motherduck/mcp-setup · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Mode

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Redshift

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found

Streamlit

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found