Skip to content
Data MCP Directory

GUIDE, read 10 Nov 2026

Where a server runs, as a local stdio process or a hosted Streamable HTTP endpoint, decides who patches it, who holds the credential and which clients can reach it

The directoryAll guides

A stdio server is a process on the engineer's machine

A local server starts as a child process of the client and talks over standard input and output. The engineer installs it, holds its configuration and updates it. Three servers in the directory are recorded as stdio-only: the Amazon Redshift MCP Server, the Sifflet MCP Server and the community mcp-snowflake-server.

The install paths are specific. The README of the Sifflet MCP Server documents setup for Cursor and Claude Desktop through uvx sifflet-mcp@latest. The community Snowflake server runs via uvx or uv for Claude Desktop, and its README also documents installing through Smithery. The Redshift README shows a stdio client config. Fivetran's README says its server runs over stdio by default and needs Python 3.10 or later and uv.

Tableau's docs say the package can run through npx (Node 22.7.5 or later), Docker, Heroku, or as Node single-executable binaries. Collibra's server is a Go binary distributed as prebuilt releases for Linux, macOS and Windows.

A hosted server is an endpoint the vendor runs

A hosted server needs no local process, and the vendor owns its version. Google documents a global BigQuery endpoint that uses Streamable HTTP, enabled when the BigQuery API is enabled. Atlan hosts its server per tenant, and its older local server is deprecated in favor of the hosted endpoint, per the Atlan README. Airbyte, Hex, Cube and Select Star each document one vendor-run endpoint. SYNQ's docs describe regional hosts for the EU, US and AU.

Some hosted servers live inside the customer's account. Per Alation's README, the remote MCP server is served from the customer's own Alation instance under /ai/mcp. Snowflake's managed server is an object created with CREATE MCP SERVER and reached at an account-scoped HTTP URL. Databricks documents an endpoint pattern built from the workspace hostname and the MCP name. Hex single-tenant, EU and HIPAA workspaces use their own host instead of the default one.

Hosting changes the client requirement. Airbyte's install page says clients must support remote MCP servers with OAuth and the Streamable HTTP transport. Sigma's configuration table sets the transport to HTTP. OpenMetadata documents Streamable HTTP under MCP spec 26 Mar 2025, and Snowflake's docs state support for protocol revision 25 Nov 2025.

Monte Carlo's docs say OAuth lets any HTTP-transport MCP client connect with no API keys, and its connector is listed in the Claude Connectors Directory. Monte Carlo also lets admins restrict the server by IP with Network Access Control Lists, and Sigma's page says organizations with an IP allowlist must allowlist the AI assistant's outbound IPs with scope API.

Several servers ship both modes with different rules

Twelve servers are recorded as offering both transports, and the modes can differ in auth and scope. Collibra's HTTP mode binds to localhost only, and its credentials differ by mode. DataHub's HTTP entry point refuses a shared server token. Fivetran runs as a hosted HTTP server with --transport streamable-http, but its README says OAuth resource-server support in that mode is not yet functional.

Microsoft's Power BI page says the local server is generally available and the hosted endpoint is in preview. Per the same page, Desktop, PBIP files, transactions and traces are available only on the local server, and Microsoft suggests not registering both local and remote at once. The Snowflake Labs README lists stdio (default), sse (legacy) and streamable-http. The Databricks Labs README says local use is via stdio and Databricks Apps deployment uses Streamable HTTP. The Toolbox runs as a local stdio server through npx @toolbox-sdk/server with the --stdio flag, per the repository README, and its Looker and BigQuery tools use it.

The mcp-remote bridge connects stdio-only clients to hosted servers

Some clients speak stdio and cannot open a remote connection. The open-source mcp-remote proxy sits between them: the client starts mcp-remote as a local process, and mcp-remote talks to the hosted URL. Per the docs for the Euno MCP server, stdio use goes through the third-party open-source mcp-remote bridge and not a Euno-published package. Monte Carlo documents its MCP-server-type API key id:secret as a Bearer token via mcp-remote. Select Star's page notes that the mcp-remote proxy is used for Claude Desktop.

A bridge adds a local process that holds the token or runs the OAuth flow. For a security review it is one more program to read. Euno's docs also say the Euno MCP server keeps no session state, so connections survive restarts and scaling; that is a statement about the server and not about the bridge.

Client support limits what a hosted server can reach

Each vendor lists the clients it has tested. Cube documents Claude, ChatGPT, Microsoft 365 Copilot, Cursor and Codex. Hex documents Claude Desktop, Claude Code, Cursor, ChatGPT, Codex and Glean. Sigma documents Claude, ChatGPT, Codex, Cortex Code and Cursor. Omni has setup pages for ChatGPT, Claude Code, Claude Desktop, Codex, Cursor, Microsoft Copilot and VS Code.

Client quirks appear in the docs. Hex says Claude connector widgets created by its connector expire after 24 hours and file uploads to a conversation are not supported. ThoughtSpot's README lists /mcp, /sse, /token/* and /bearer/* endpoints on its Worker, so one deployment exposes more than one path. Secoda's wrapper is local FastMCP with an API_TOKEN, while its docs also describe a Secoda-hosted endpoint.

Euno's docs describe a dedicated Gemini Enterprise setup path alongside the direct, bridge and API-key setups. Atlan's docs list supported clients including Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, ChatGPT, Snowflake, Google ADK, n8n, Microsoft 365 Copilot, Glean and Databricks.

Transport, location and bridge per server

The table records the transport and where the server runs for a sample, in alphabetical order. 'Both' means the publisher documents stdio and an HTTP mode.

The Snowflake-managed row describes where the server lives. Neither the managed server nor the hosted rows require the engineer to patch anything locally, while the stdio rows do.

ServerTransport recordedWhere it runs
Airbyte MCP (hosted)Remote, Streamable HTTPAirbyte-hosted endpoint
Amazon Redshift MCP Server (AWS Labs)stdioLocal process
Atlan MCP (hosted)RemoteAtlan-hosted per tenant
BigQuery remote MCP serverRemote, Streamable HTTPGoogle-managed global endpoint
Collibra MCP ServerBothLocal Go binary; HTTP binds to localhost
Euno MCPRemote; stdio via mcp-remoteEuno-hosted
Monte Carlo MCP ServerRemote; API key via mcp-remoteMonte Carlo-hosted
Sifflet MCP ServerstdioLocal process via uvx
Snowflake-managed MCP serverRemoteObject in the Snowflake account

Sources

  1. AWS Labs Redshift MCP README, read 10 Nov 2026
  2. Sifflet MCP README, read 10 Nov 2026
  3. Community mcp-snowflake-server README, read 10 Nov 2026
  4. Fivetran MCP README, read 10 Nov 2026
  5. Tableau MCP repository, read 10 Nov 2026
  6. Collibra MCP README, read 10 Nov 2026
  7. BigQuery remote MCP guide, read 10 Nov 2026
  8. Atlan agent-toolkit MCP README, read 10 Nov 2026
  9. Atlan MCP security page, read 10 Nov 2026
  10. SYNQ MCP docs, read 10 Nov 2026
  11. Alation agent SDK README, read 10 Nov 2026
  12. Snowflake-managed MCP docs, read 10 Nov 2026
  13. Databricks managed MCP page, read 10 Nov 2026
  14. Hex MCP server docs, read 10 Nov 2026
  15. Airbyte MCP install, read 10 Nov 2026
  16. Sigma MCP server help page, read 10 Nov 2026
  17. OpenMetadata MCP connect guide, read 10 Nov 2026
  18. DataHub MCP README, read 10 Nov 2026
  19. Microsoft Learn Power BI authoring MCP, read 10 Nov 2026
  20. Snowflake Labs MCP README, read 10 Nov 2026
  21. Databricks Labs MCP README, read 10 Nov 2026
  22. MCP Toolbox repository, read 10 Nov 2026
  23. Euno MCP bridge setup, read 10 Nov 2026
  24. Euno MCP setup docs, read 10 Nov 2026
  25. Monte Carlo MCP server docs, read 10 Nov 2026
  26. Select Star MCP docs, read 10 Nov 2026
  27. Cube MCP server docs, read 10 Nov 2026
  28. Omni docs sitemap, read 10 Nov 2026
  29. ThoughtSpot MCP README, read 10 Nov 2026
  30. Secoda MCP docs, read 10 Nov 2026

Last reviewed 10 Nov 2026.