GOVERNED ANALYTICS / Snowflake
Snowflake-managed MCP
Publishes selected Snowflake Cortex, SQL or custom tools through a managed MCP object with separate server and tool privileges.
“Snowflake-managed MCP server”
01 / THE REASONING
Why this made the selection.
- Replaces the deprecated standalone adapter with the publisher’s managed service.
- Tool-specific grants and configurable SQL read-only mode provide concrete governance controls.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp (setup, access and capability sections)
Our findings
- SYSTEM_EXECUTE_SQL defaults read_only to true; custom UDF/procedure tools have their own effects and grants.
- The official guide provides an account/database/schema-specific endpoint, not a universal public server URL.
- The reviewed documentation establishes an authenticated HTTP MCP endpoint; no more specific transport subtype is claimed here.
Not established by this review
- Authentication, service availability and tool execution were not tested.
- The hosted implementation source and licence were not established.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Connect a server deliberately.
- Create an MCP SERVER object containing only the intended tool specification and grant the required server/tool privileges.
- Configure Snowflake or External OAuth and use https://<account_url>/api/v2/databases/{database}/schemas/{schema}/mcp-servers/{name} with actual account/object identifiers.
Before you start
- A supported Snowflake account, appropriate server/tool privileges and a configured OAuth integration.
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp
Supports: summary, whySelected, bestFor, limitations, review, compatibility, install, access, transports, configExample