GUIDES, read 10 Nov 2026
10 guides for the engineer who writes down what each server really does
What an MCP server for data should exposeGlossary
- What an MCP server for data should exposeAgents meet five kinds of tools on data servers: query, metadata, lineage, semantic layer and write actions.
- Read versus write on data MCP serversRedshift prompts for confirmation on each write, DataHub keeps mutation tools off by default, Fivetran defaults its scope to read, and Select Star lists 7 tools that only search, get or traverse.
- Scoping context to the person askingAtlan, Cube, Hex, Omni and Tableau document calls that run as the signed-in user, while Fivetran uses one API key and secret, the Secoda wrapper one API_TOKEN, and Select Star one API token.
- Why tool definition size mattersA client that connects to an MCP server loads each tool's name, description and input schema into the model's context.
- Auth and audit on data MCP serversAuth across the directory spans OAuth, personal access tokens, API keys, Basic Auth and cloud credentials.
- Remote versus local MCP servers for dataThree servers run over stdio only (AWS Labs Redshift, Sifflet, the community mcp-snowflake-server), 15 are hosted-only in the directory's records, and 12 offer both.
- What official means for a data MCP serverThe directory marks 29 of 30 servers official, meaning the data tool's vendor publishes them; one community server is marked unofficial.
- Three ways to connect an agent to SnowflakeSnowflake documents a managed MCP server created with CREATE MCP SERVER; Snowflake Labs' repository, last released as 1.4.2 on 15 May 2026, is marked deprecated; and the community mcp-snowflake-server, 0.4.0 from 10 Apr 2025, runs over stdio.
- Metadata servers versus query serversMetadata servers such as Atlan, Collibra, DataHub, Monte Carlo and Sifflet describe assets, owners, lineage and incidents.
- Reading a server before you install itEight checks cover publisher, version, last release, transport, auth, write tools, tool count and where the tool list is published.
Last reviewed 10 Nov 2026.