# 10 guides for the engineer who writes down what each server really does

GUIDES, read 10 Nov 2026

**The short answer.** Ten guides for an engineer wiring an agent to data tools over MCP: what a server for data should expose, read versus write, scoping context to the person asking, why tool-definition size matters, auth and audit, remote versus local, what official means, and reading a server before installing it, each from the servers' own sources.

- [What an MCP server for data should expose](/guides/what-an-mcp-server-for-data-should-expose/): Agents meet five kinds of tools on data servers: query, metadata, lineage, semantic layer and write actions.
- [Read versus write on data MCP servers](/guides/read-versus-write/): Redshift 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 asking](/guides/scoping-context-to-the-person-asking/): Atlan, 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 matters](/guides/why-tool-definition-size-matters/): A 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 servers](/guides/auth-and-audit/): Auth across the directory spans OAuth, personal access tokens, API keys, Basic Auth and cloud credentials.
- [Remote versus local MCP servers for data](/guides/remote-versus-local-servers/): Three 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 server](/guides/what-official-means/): The 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 Snowflake](/guides/three-ways-to-connect-an-agent-to-snowflake/): Snowflake 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 servers](/guides/metadata-servers-versus-query-servers/): Metadata servers such as Atlan, Collibra, DataHub, Monte Carlo and Sifflet describe assets, owners, lineage and incidents.
- [Reading a server before you install it](/guides/reading-a-server-before-you-install-it/): Eight checks cover publisher, version, last release, transport, auth, write tools, tool count and where the tool list is published.

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/guides/
