Snowflake MCP server
officialSnowflake's managed MCP server runs inside the customer's own Snowflake account and exposes Cortex Agents, Cortex Analyst, Cortex Search and SQL. Whoever creates the server defines which tools it carries, and the SQL tool is read-only by default.
What an agent can do
- → Ask plain-language questions over data
- → Search unstructured data with Cortex Search
- → Run SQL queries, read-only by default
- → Call Cortex Agents
- → Use custom functions and procedures
The server has to be created in Snowflake by a role with the CREATE MCP SERVER privilege, and each user needs grants on both the server and every tool behind it. One server holds at most 50 tools.
About the Snowflake MCP server
The Snowflake-managed MCP server is a feature of Snowflake itself, not a separate product to install. An administrator creates it as an object inside a database and schema in your own Snowflake account, and Snowflake hosts it there, so no extra infrastructure is needed. AI assistants reach it at an address under your account URL and can then use the tools that have been placed on that particular server.
Teams use it to ask questions about company data from the assistant they already work in. A server can carry Cortex Analyst for questions over structured data through semantic views, Cortex Search for documents and other unstructured text, Cortex Agents that combine several steps, a SQL tool, and your own functions and stored procedures. A finance lead can ask for revenue by region, and a support lead can search past tickets.
Access follows Snowflake's role system. A person needs usage rights on the server to connect and see its tools, and separate rights on every tool behind it, so reaching the server does not open the data on its own. The SQL tool is read-only by default and then accepts only SELECT queries. One server holds at most 50 tools, and answers from the SQL tool and custom tools are cut off at 250 KB.
Things to ask
- What was net revenue per region last quarter compared with the same quarter a year earlier?
- Search our support tickets for complaints about late deliveries in October and summarise the three most common causes.
- Which ten customers grew most in order value this year, and which product lines were behind the growth?
- Show the columns of the orders table in the sales schema and explain what each column holds.
- Ask our churn agent to explain why cancellations rose in September, and show the figures behind the answer.
Part of these packages
Snowflake is part of these Walma packages.
Questions about Snowflake MCP
Does the Snowflake MCP server cost anything?+
Snowflake's MCP documentation states no price for the server itself, and it does not state which Snowflake edition is required. The tools behind it are billed as usual: Cortex Agents in AI Credits per million tokens, Cortex Search for serving and embedding compute, and any SQL that runs uses normal warehouse compute.
What is the Snowflake MCP server URL?+
There is no shared address. Each server gets its own under your account: https://<account_url>/api/v2/databases/{database}/schemas/{schema}/mcp-servers/{name}. Snowflake notes that the hostname should be written with hyphens instead of underscores when you configure the connection.
How does sign-in work?+
Snowflake OAuth is the default. External OAuth can be used with identity providers such as Okta or Microsoft Entra ID. The server does not support dynamic client registration. A programmatic access token also works, but Snowflake recommends OAuth because hardcoded tokens can leak, and such a token should carry the least-privileged role that is enough.
Is it read-only, or can it change data?+
It depends on how the server is built. The SQL tool has a read_only setting that is on by default and then allows only SELECT queries. Whoever owns the server can turn it off. Cortex Analyst and Cortex Search retrieve data, while your own functions and stored procedures do whatever they were written to do.
Which AI assistants does it work with?+
Snowflake documents Claude, both claude.ai and Claude Desktop, ChatGPT in Developer Mode, and Cursor through its mcp.json file. Any other client that supports remote MCP servers over HTTP can connect as well. The client has to accept responses both as application/json and as text/event-stream.
Who can create the server, and who can use it?+
Whoever creates the server needs the CREATE MCP SERVER privilege in the schema. Connecting and seeing the tools requires USAGE on the server. That alone is not enough: every tool needs its own grant, for example USAGE on a Cortex Search service or a Cortex Agent, and SELECT on a semantic view.
What are the limits of the Snowflake MCP server?+
At most 50 tools per server, and Snowflake notes that a high tool count can make the assistant worse at picking the right one. Responses from the SQL tool and custom tools are cut off at 250 KB. Only tools are supported, not the MCP features resources, prompts or sampling. Server objects are not replicated in failover groups.
Missing a connection?
We build and review MCP servers for teams that need them, and run them behind the same policy and log as the rest of the gateway.