Consultants in a BoxSnowflakePower BILookerSnowflake guides
Snowflake MCP

Snowflake MCP server: what it does, its tools and the security cautions

Short answer

Snowflake offers a managed MCP server that lets AI agents retrieve data from your Snowflake account without separate infrastructure. You create it as an object in a database and schema, list the tools it serves, and MCP clients that authenticate can discover and call them. Snowflake OAuth is the default, access is controlled by roles, and permission must be granted for each tool.

Last reviewed against the vendors' own pages. See sources.

MCP tool types Snowflake lists, in three groups

Count of tool types, from Snowflake's managed MCP server documentation, reviewed November 20, 2026.

Show as table
ItemMCP tool types Snowflake lists, in three groups
Agent and coding tools (CORTEX_AGENT_RUN, CODING_AGENT)2
Search and analyst tools (CORTEX_SEARCH_SERVICE_QUERY, CORTEX_ANALYST_MESSAGE)2
SQL and custom tools (SYSTEM_EXECUTE_SQL, GENERIC)2

What can the Snowflake MCP server serve?

Per Snowflake's MCP documentation, it serves Cortex Analyst, Cortex Search and Cortex Agents as tools, plus custom tools and SQL.

Tool typeWhat Snowflake says it is
CORTEX_AGENT_RUNA Cortex Agent tool; Snowflake recommends this for governed business data questions
CORTEX_ANALYST_MESSAGEA Cortex Analyst tool; exposed directly, it generates SQL and returns the statement to the client
CORTEX_SEARCH_SERVICE_QUERYA Cortex Search Service tool
SYSTEM_EXECUTE_SQLSQL execution, without Cortex Agent orchestration
GENERICA tool for user-defined functions and stored procedures
CODING_AGENTA coding agent tool with no stored agent object

Reviewed November 20, 2026. We have not connected a client to a live Snowflake account for this page.

How do you set it up?

The documentation describes creating the server as an object, then letting clients authenticate.

For business data, Snowflake recommends exposing one Cortex Agent as the client-facing tool, so the agent chooses between its Analyst, Search and custom tools. Compare with our Claude guides and AI implementation work.

  1. Go to the database and schema where the server should live.
  2. Run CREATE MCP SERVER with a specification (YAML) that lists each tool, its name, type, identifier and a precise description.
  3. Grant roles access to the server and, separately, to each tool.
  4. Connect an MCP client using Snowflake OAuth (the default), or External OAuth with your identity provider.

What are the security cautions?

Snowflake's page lists several, and they matter more than the setup.

  • Data leaves Snowflake: tool results go to the MCP client and, through it, to its model provider under that party's terms. Decide what each tool may return.
  • Per-tool permission: access to the server does not give access to its tools.
  • OAuth over tokens: hard-coded tokens can leak; if you use a programmatic access token, give it the least-privileged role.
  • Third-party servers: verify tools and descriptions before using servers from other accounts, to avoid tool poisoning or shadowing.
  • Loops: an agent calling an MCP server that calls back into an agent can run up cost; Snowflake enforces a maximum recursion depth of 10.
  • Hostnames: use hyphens, not underscores, in MCP server hostnames.

Frequently asked questions

What is the Snowflake MCP server?

A Snowflake-managed MCP server that lets AI agents retrieve data from your account, serving Cortex Analyst, Cortex Search, Cortex Agents, custom tools and SQL execution.

How does it authenticate?

Snowflake OAuth by default, with optional External OAuth against your identity provider. Snowflake recommends OAuth over hard-coded tokens.

Does an MCP client send my data to an AI provider?

Snowflake's page says tool results go to the MCP client and, through the client, to its model provider, under that party's terms. Decide what each tool may return.

Does connecting Claude or ChatGPT cost credits?

Queries run on warehouses and Cortex features use credits, as in the other guides. We have not measured a specific cost, and Snowflake documents a recursion limit to stop runaway loops.

Can you set this up for us?

Yes. We choose the tools, set roles and permissions and test with your AI client. Book a call to start.

Need help with Snowflake?

We help small and mid-size teams choose, size and run data tools. See our Snowflake guides and services, and the Power BI guides, and the Looker Studio guides, and the Claude guides, and the AI implementation.

Sources

Last reviewed . Vendor plans and prices change often; every product claim and price on this page was checked against the vendor pages below on that date. Anything we could not verify was left out.

  1. Snowflake-managed MCP server (Snowflake documentation)

Consultants in a Box is an independent consultancy. This page is not published or endorsed by Snowflake. Snowflake is a trademark of Snowflake Inc. We quote no Snowflake dollar prices and show no prices of ours.

Choosing or sizing Snowflake?

Start with the free business analysis, or book a call and we will look at your data and recommend a practical next step.

Book a free consultation

Tell us about your team and the software you need help with. We'll follow up to schedule a time to talk.

Open the form on its own page

Talk to a person

The fastest way is to pick a time. Prefer to write? Leave a message and we will email you back, usually the same business day.

Book a free call

By sending this you agree to our Terms and Privacy Policy.