Data · MCP Server
Securing the Snowflake MCP server
The Snowflake MCP server gives an agent warehouse queries across your analytics estate. That is useful, and it is also a set of real capabilities pointed at a real system. Here is what it exposes, why it is worth governing, and the policy to put in front of it.
What the server hands your agent
Warehouse, database, and schema browsing plus SQL execution against analytics tables.
Why it is worth governing
- The warehouse is where every source system ends up joined together, so it is usually the single richest read target in the company.
- Query cost is real. An agent iterating on an unbounded scan burns credits with no natural stopping point.
- Analytics tables frequently hold data that was masked in the source system but landed raw in the warehouse.
Tag what the tools actually do
Prismor tags every tool by behavior rather than by name, so rules survive a server adding tools you have never seen. A sensible starting map for Snowflake:
| Tool pattern | Tags | Why |
|---|---|---|
| mcp__snowflake__*query* | private_data | warehouse rows are consolidated production data |
| mcp__snowflake__*execute* | critical_action | execution can mutate tables |
Patterns are illustrative globs. Run prismor tags list to see how your installed tools actually resolve.
The policy
Rules read as a sentence: a tag, then or with another tag, and what to do about it. Note the mode - start by watching, not blocking.
settings:
tool_tags:
enabled: true
mode: observe # switch to enforce once the log looks right
tags:
"mcp__snowflake__*query*": [private_data]
"mcp__snowflake__*execute*": [critical_action]
rules:
- "private_data then external_comms -> block"Putting Snowflake behind the gateway
You do not change the Snowflake server or how it is configured. Move your existing mcpServers block behind the Prismor gateway and point your agent at Prismor instead:
prismor mcp-gateway install # moves your .mcp.json servers behind the gateway
prismor mcp-gateway uninstall # restores the original, backup keptYour agent sees the same Snowflake tools, namespaced as mcp__snowflake__<tool>. Every call is evaluated against policy before it is forwarded, and every result is scanned as untrusted content before the model sees it.
Frequently asked questions
Is the Snowflake MCP server safe to give an AI agent?
It is as safe as the credential behind it and the policy in front of it. The server itself is not the problem: the risk is that an agent can combine Snowflake access with everything else in the session, with no record of what it did. Front it with a gateway that evaluates each call and logs the verdict.
Does Prismor replace the Snowflake MCP server?
No. You keep running the same server, unchanged. Prismor aggregates it behind a single connector so your agent sees the same tools, namespaced as mcp__<server>__<tool>, with every call and every result passing through policy first.
Will this block work my team actually needs to do?
Not if you start in observe mode. Every call is recorded with the decision that would have applied, and nothing is blocked. You promote rules to enforce once the log shows the policy matches how your agents really work.
What about tool results, not just tool calls?
Results are scanned as untrusted content before the model sees them. A response carrying injected instructions or poisoned output is withheld and replaced with the reason, which matters most for servers that return text other people wrote.
One gateway for every MCP server
Snowflake is one connector. The same policy covers the rest of them, plus the shell commands and file access your agents already have.
Other data servers
PostgreSQL
MongoDBSnowflake is a trademark of its respective owner. Prismor is not affiliated with or endorsed by it. The Snowflake MCP server is third-party software; Prismor governs it the same way it governs any MCP server, without modifying it.