# With thousands of reports and no map, check what each BI and catalog server exposes about what feeds them

SITUATION, read 10 Nov 2026

**The short answer.** A BI team with thousands of reports and no map of their sources needs servers that expose data source metadata, semantic models and lineage into reports. Sixteen BI and catalog servers are in scope; the checks below point to the fields that answer each, read 10 Nov 2026, and name no choice.

BI servers describe their own content: workbooks, data sources, semantic models, calculated fields. Catalog servers describe how those connect to the warehouse. A map of what feeds each report usually needs both.

Several BI servers can also create or edit content; the Access field shows which document a read-only switch.

## What to check

| Check | The field or fact that answers it |
| --- | --- |
| Does the BI server expose data source and calculation metadata? | What it reaches and Definitions facts; tool names |
| Can the agent see which tables feed a report? | Lineage and impact facts, on BI and catalog entries |
| Can the agent edit reports? | Access field and write tool names |
| Is it hosted or local? | Transport field |

## The published facts, for the 16 servers in scope

| Server | Kind | Transport | Access | Tools listed |
| --- | --- | --- | --- | --- |
| [Alation AI Agent SDK MCP server](/servers/alation-mcp/) | Official | Remote and local | Not stated in the source read | 12 named in the evidence |
| [Atlan MCP Server](/servers/atlan-mcp/) | Official | Remote (hosted) | Configurable | 41 named in the evidence |
| [Collibra MCP Server (chip)](/servers/collibra-mcp/) | Official | Remote and local | Configurable | 49 named in the evidence |
| [Cube MCP server](/servers/cube-mcp/) | Official | Remote (hosted) | Read and write | 30 named in the evidence |
| [DataHub MCP Server](/servers/datahub-mcp/) | Official | Remote and local | Configurable | 22 named in the evidence |
| [Euno MCP](/servers/euno-mcp/) | Official | Remote (hosted) | Configurable | 56 named in the evidence |
| [Hex MCP server](/servers/hex-mcp/) | Official | Remote (hosted) | Read and write | 18 named in the evidence |
| [Looker tools in MCP Toolbox for Databases](/servers/looker-mcp-toolbox/) | Official | Remote and local | Configurable | 55 named in the evidence |
| [Omni MCP Server](/servers/omni-mcp/) | Official | Remote (hosted) | Configurable | 26 named in the evidence |
| [OpenMetadata MCP Server](/servers/openmetadata-mcp/) | Official | Remote (hosted) | Read and write | 15 named in the evidence |
| [Power BI Modeling MCP Server](/servers/powerbi-modeling-mcp/) | Official | Remote and local | Configurable | 21 named in the evidence |
| [Secoda MCP](/servers/secoda-mcp/) | Official | Remote and local | Not stated in the source read | 8 named in the evidence |
| [Select Star MCP Server](/servers/select-star-mcp/) | Official | Remote (hosted) | Read only | 7 named in the evidence |
| [Sigma MCP server](/servers/sigma-mcp/) | Official | Remote (hosted) | Read and write | 0 named in the evidence |
| [Tableau MCP](/servers/tableau-mcp/) | Official | Remote and local | Configurable | 40 named in the evidence |
| [ThoughtSpot MCP Server](/servers/thoughtspot-mcp-server/) | Official | Remote (hosted) | Read and write | 20 named in the evidence |

Filed by data tool, read 10 Nov 2026. Scope: bi and analytics, catalogs and metadata.

## What each server documents on what it reaches

- [Alation AI Agent SDK MCP server](/servers/alation-mcp/): None found: A list of warehouses, transformation or BI tools in the Alation agent SDK README (coverage follows the Alation catalog).
- [Atlan MCP Server](/servers/atlan-mcp/): The docs list supported AI clients: Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, ChatGPT, Snowflake, Google ADK, n8n, Microsoft 365 Copilot, Glean and Databricks. Data-source coverage depends on Atlan connectors, not stated on this page.
- [Collibra MCP Server (chip)](/servers/collibra-mcp/): None found: A list of warehouses, BI tools or transformation tools supported by the Collibra MCP README (coverage depends on what is catalogued in the Collibra instance).
- [Cube MCP server](/servers/cube-mcp/): Documented clients are Claude, ChatGPT, Microsoft 365 Copilot, Cursor and Codex, plus other MCP clients over HTTPS. Admins choose the default deployment and can limit which deployments MCP clients can reach, always intersected with role-based permissions.
- [DataHub MCP Server](/servers/datahub-mcp/): The README says the server shows data in databases, lakes, warehouses and BI tools registered in DataHub; no connector list is on this page.
- [Euno MCP](/servers/euno-mcp/): The published tool table covers metadata, lineage, EQL, audit, documentation, catalog and benchmark tools; no listed tool executes SQL against a warehouse, and query_to_eql converts a filter without executing it. Euno's FAQ says Euno does not query customer data.
- [Hex MCP server](/servers/hex-mcp/): The server works with Claude Desktop, Claude Code, Cursor, ChatGPT, Codex and Glean as well as standard MCP clients. Single-tenant, EU multi-tenant and HIPAA multi-tenant workspaces use their own host instead of app.hex.tech.
- [Looker tools in MCP Toolbox for Databases](/servers/looker-mcp-toolbox/): Looker can be deployed in the cloud, on GCP, or on premises, and the same Toolbox covers Google Cloud databases such as AlloyDB, BigQuery, Cloud SQL, Spanner and Firestore. Looker connection tools list databases, schemas, tables and columns of the warehouse connections configured in Looker. Toolbox runs as a local stdio MCP server through npx @toolbox-sdk/server with the --stdio flag.
- [Omni MCP Server](/servers/omni-mcp/): The same MCP server can serve embed users, scoped to each user's permissions. Setup pages exist for ChatGPT, Claude Code, Claude Desktop, Codex, Cursor, Microsoft Copilot and VS Code.
- [OpenMetadata MCP Server](/servers/openmetadata-mcp/): The reference lists asset types: database, dashboard, pipeline, topic, mlmodel, container, searchIndex, storedProcedure and API services; no named vendor list is on this page.
- [Power BI Modeling MCP Server](/servers/powerbi-modeling-mcp/): The local server connects to semantic models in Power BI Desktop, Fabric workspaces and Power BI Project (PBIP) files; --compatibility Full also targets Analysis Services databases. Hosted uses Streamable HTTP and Entra ID; local uses stdio, with Desktop, PBIP files, transactions and traces only on local.
- [Secoda MCP](/servers/secoda-mcp/): None found: A list of supported warehouses or BI tools on the Secoda MCP page.
- [Select Star MCP Server](/servers/select-star-mcp/): Select Star says its universal metadata model connects more than 25 integrations (founder post on the Snowflake deal); the MCP page names no systems.
- [Sigma MCP server](/servers/sigma-mcp/): Documented clients include Claude, ChatGPT, Codex, Cortex Code and Cursor over HTTP transport. The configuration table sets transport to HTTP.
- [Tableau MCP](/servers/tableau-mcp/): The server works with Tableau Cloud and Tableau Server of any edition, with some tools gated by SKU. Tools span published data sources, workbooks, views, custom views, projects, Prep flows, Pulse metrics, extract refresh tasks, users and Admin Insights. The server speaks stdio by default and HTTP as an alternative transport.
- [ThoughtSpot MCP Server](/servers/thoughtspot-mcp-server/): The tool set includes connectivity and auth checks (ping, check_connectivity) and org handling tools list_orgs and switch_org, so one server can reach multiple ThoughtSpot Orgs. The README lists /mcp, /sse, /token/* and /bearer/* endpoints on the Worker.

**What Euno's server does not do.** 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.

## Other situations

- [A data platform lead whose analysts no longer trust the dashboards](/situations/untrusted-dashboards/)
- [An analytics engineering team on dbt and Snowflake or Databricks](/situations/dbt-warehouse/)
- [A company putting AI agents on its data this year](/situations/agents-this-year/)
- [A governance lead who must show where a regulated field flows](/situations/regulated-field/)

## Sources

- github.com/Alation/alation-ai-agent-sdk/blob/main/README.md: https://github.com/Alation/alation-ai-agent-sdk/blob/main/README.md (read 10 Nov 2026)
- docs.atlan.com/product/capabilities/atlan-ai/how-tos/remote-mcp-overview: https://docs.atlan.com/product/capabilities/atlan-ai/how-tos/remote-mcp-overview (read 10 Nov 2026)
- github.com/collibra/chip/blob/main/README.md: https://github.com/collibra/chip/blob/main/README.md (read 10 Nov 2026)
- docs.cube.dev/docs/integrations/mcp-server.md: https://docs.cube.dev/docs/integrations/mcp-server.md (read 10 Nov 2026)
- raw.githubusercontent.com/acryldata/mcp-server-datahub/main/README.md: https://raw.githubusercontent.com/acryldata/mcp-server-datahub/main/README.md (read 10 Nov 2026)
- docs.euno.ai/ai/mcp-setup.md: https://docs.euno.ai/ai/mcp-setup.md (read 10 Nov 2026)
- euno.ai: https://euno.ai/ (read 10 Nov 2026)
- learn.hex.tech/docs/api-integrations/mcp-server: https://learn.hex.tech/docs/api-integrations/mcp-server (read 10 Nov 2026)
- mcp-toolbox.dev/integrations/looker/source: https://mcp-toolbox.dev/integrations/looker/source/ (read 10 Nov 2026)
- mcp-toolbox.dev/llms.txt: https://mcp-toolbox.dev/llms.txt (read 10 Nov 2026)
- github.com/googleapis/mcp-toolbox: https://github.com/googleapis/mcp-toolbox (read 10 Nov 2026)
- docs.omni.co/llms.txt: https://docs.omni.co/llms.txt (read 10 Nov 2026)
- docs.omni.co/sitemap.xml: https://docs.omni.co/sitemap.xml (read 10 Nov 2026)
- docs.open-metadata.org/v2.0.x/how-to-guides/mcp/reference.md: https://docs.open-metadata.org/v2.0.x/how-to-guides/mcp/reference.md (read 10 Nov 2026)
- raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md: https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md (read 10 Nov 2026)
- learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp: https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp (read 10 Nov 2026)
- docs.secoda.co/features/ai-assistant/secoda-mcp-server.md: https://docs.secoda.co/features/ai-assistant/secoda-mcp-server.md (read 10 Nov 2026)
- selectstar.com/resources/snowflake-acquire-select-star: https://selectstar.com/resources/snowflake-acquire-select-star (read 10 Nov 2026)
- help.sigmacomputing.com/docs/use-sigma-mcp-server: https://help.sigmacomputing.com/docs/use-sigma-mcp-server (read 10 Nov 2026)
- tableau.github.io/tableau-mcp/docs/intro: https://tableau.github.io/tableau-mcp/docs/intro (read 10 Nov 2026)
- tableau.github.io/tableau-mcp/docs/configuration/mcp-config/env-vars: https://tableau.github.io/tableau-mcp/docs/configuration/mcp-config/env-vars (read 10 Nov 2026)
- raw.githubusercontent.com/thoughtspot/mcp-server/main/src/servers/tool-definitions.ts: https://raw.githubusercontent.com/thoughtspot/mcp-server/main/src/servers/tool-definitions.ts (read 10 Nov 2026)
- raw.githubusercontent.com/thoughtspot/mcp-server/main/README.md: https://raw.githubusercontent.com/thoughtspot/mcp-server/main/README.md (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/situations/bi-sprawl/
