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)
- Round 2 reread of acquired publisher setup and permission evidence; see immutable wave review.
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.
- Permissions on an MCP server do not grant permissions on every underlying tool; each Cortex or custom tool needs its own grants.
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.
Documented configuration example
Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.
{
"mcpServers": {
"snowflake": {
"url": "https://<account_url>/api/v2/databases/<database>/schemas/<schema>/mcp-servers/<name>",
"auth": {
"CLIENT_ID": "${env:MCP_CLIENT_ID}",
"CLIENT_SECRET": "${env:MCP_CLIENT_SECRET}"
}
}
}
} 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