MCP100 Assessment

Editorial verdict

Recommended for governed Snowflake analytics when account configuration, role and warehouse scope, data egress, and any SQL mutations are explicitly controlled.

Reviewed September 5, 2026

Task Fit

Mapped

Working with structured data

Trust

Reviewed

A dated editorial review is published on the MCP detail page.

Maintenance

Date unavailable

No dated repository or package update is currently stored.

Popularity

Signals unavailable

No independently comparable adoption metric is currently stored.

Best for

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.
Teams already using Snowflake that can test with non-sensitive data and least privilege.

Not ideal for

Users who need an MCP100-recommended recommendation today
Unattended production workflows before permissions and failure behavior are reviewed

Avoid if

The connected data or account cannot be safely exposed to the selected AI client
You cannot verify least-privilege access and review write-capable tool calls

Trade-offs

First-party provenance and a clear task improve confidence, but do not replace an independent permissions and usability review.
Client transport compatibility does not prove that authentication, scopes, failure handling, and every tool behave safely.
Snowflake Managed MCP tool-call responses are SSE streams; spec-compliant clients are unaffected, while custom single-JSON parsers need changes.

Evidence scope

Evidence

Current source snapshot

Popularity

No MCP-specific repository metric is stored

No MCP-specific package metric is stored

Stars observation date unavailable · Downloads observation date unavailable

Hosted MCP/service has no reviewed public MCP-specific repository metric; do not substitute parent-product or sibling implementation stars.

Hosted MCP/service has no reviewed comparable public MCP-specific package-download metric.

Maintenance

Publisher activity observed September 24, 2026

Current source snapshot

Trust review

Source relationship: First-party MCP

Reviewed September 5, 2026

Sources

Official documentation ↗

Evidence-backed setup

Install & Agents

Choose your MCP client. A client connects to the MCP server; the language model is selected inside that client. Only stored, source-backed configurations are shown.

Claude Code

Streamable HTTP

MCP100 logic checked

claude mcp add --transport http snowflake-managed "https://YOUR_SNOWFLAKE_ACCOUNT_URL/api/v2/databases/YOUR_DATABASE/schemas/YOUR_SCHEMA/mcp-servers/YOUR_SERVER_NAME"

The publisher connection details were combined with this client's official MCP transport configuration; installation was not executed by MCP100.

Verify safely: Reconnect Claude Code, complete the publisher OAuth or authentication flow if prompted, confirm snowflake-managed tools are listed, and perform one read-only test.

Uninstall and revoke

Remove snowflake-managed from Claude Code, clear its stored MCP OAuth credentials, and revoke the publisher authorization if it is no longer needed.

Evidence & methodology

Publisher-documented setup is not the same as MCP100 execution testing. “MCP100 logic checked” means the stored configuration shape was reviewed, not that third-party MCP software was run.

Evidence checked 2026-08-12

Evidence 1 ↗Evidence 2 ↗

Capability

What it does

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.

Data & DatabasesFinancial Services & InvestingHealthcare & Life Sciences

Representative uses

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.
Teams already using Snowflake that can test with non-sensitive data and least privilege.

Important limits

Users who need an MCP100-recommended recommendation today
Unattended production workflows before permissions and failure behavior are reviewed

ToolsDocumented capabilitiesView tools

Cortex Agents
Expose a Cortex Agent as a governed MCP tool so the agent can orchestrate its configured analytical and search resources behind one client-facing interface.
Cortex Search
Expose Cortex Search services for unstructured search over governed Snowflake data.
Cortex Analyst
Use Cortex Analyst tools to turn natural-language business questions into SQL against supported semantic views.
SQL Execution
Expose controlled SQL execution, with read-only mode enabled by default and optional warehouse or timeout configuration.
Custom UDF & Stored Procedure Tools
Publish Snowflake UDFs and stored procedures as `GENERIC` MCP tools with explicit input schemas for organization-specific operations.

Profile: User-defined Snowflake MCP SERVER object Snowflake supports five MCP tool types, but every MCP SERVER object defines its own tools in YAML.

Source: Official documentation

Context Footprint

Varies by configuration

Estimated token footprint of the MCP tool schemas exposed to the agent.

User-defined Snowflake MCP SERVER object

Reviewed access

Access & risk

Review the exact access boundary before connecting this MCP to accounts, credentials, or sensitive data.

Authentication: Authentication follows the publisher's documented endpoint or local-server configuration. OAuth scopes, API-key handling, and revocation behavior remain review items.
Permissions: Exact permissions and the read/write boundary have not yet completed MCP100 independent review; consult the linked publisher sources and use the narrowest available scope.
Data handling: Publisher-accessible account or application data may be returned to the MCP client and its selected model. Retention and subprocess behavior require candidate-specific review.
Cost: No MCP100 cost conclusion is published yet. The publisher's account plan, API usage, infrastructure, or per-action charges may apply.
Risk and cautions: Use a test workspace or non-production account, least privilege, read-only controls where available, explicit approval for mutations, and credential revocation after evaluation.

Related reviewed MCPs

Other options

Google MCP Toolbox for Databases

MCP100 Recommended

Connect MCP clients to enterprise databases with prebuilt or explicitly defined tools.

Choose this instead if

Choose Google MCP Toolbox for Databases instead if schema exploration and database-aware coding in development environments.

Connect MCP clients to enterprise databases with prebuilt or explicitly defined tools.

Compare with Snowflake Managed MCP View Google MCP Toolbox for Databases details

Redis MCP

MCP100 Recommended

Manage and search Redis data through Redis's MCP server.

Choose this instead if

Choose Redis MCP instead if inspecting and manipulating Redis strings, hashes, lists, sets, sorted sets, streams, JSON, and search indexes.

Manage and search Redis data through Redis's MCP server.

Compare with Snowflake Managed MCP View Redis MCP details

Supabase MCP

MCP100 Recommended

Connect AI tools to Supabase projects and development workflows.

Choose this instead if

Choose Supabase MCP instead if inspecting one Supabase project's schema, logs, advisors, and docs.

Connect AI tools to Supabase projects and development workflows.

Compare with Snowflake Managed MCP View Supabase MCP details

Read publisher documentation

Publisher documentation

MCP100 source-backed summary

A concise MCP100 summary built from the reviewed publisher sources. It is not a publisher README; use the original link for the latest full documentation.

View original documentation ↗

Snowflake Managed MCP

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.

What it can help with

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.
Teams already using Snowflake that can test with non-sensitive data and least privilege.

Important limits

Users who need an MCP100-recommended recommendation today
Unattended production workflows before permissions and failure behavior are reviewed

Loading optional publisher documentation…

FAQ

What can Snowflake Managed MCP do?

Expose governed Snowflake search, analyst, agent, custom tool, and SQL capabilities.

Can Snowflake MCP execute SQL?

Yes, when the configured Snowflake MCP toolset and role allow it. The reviewed surface includes SQL/query workflows, while the connected Snowflake role, warehouse, database, schema, and server configuration determine what can actually run.

Does Snowflake MCP work with Claude Code?

Yes. MCP100 reviewed an evidence-backed setup for Claude Code, but has not independently verified it with a live runtime test.

Is this an official MCP?

Snowflake is listed as First-party MCP in MCP100’s current evidence.

Current official resources:

Publisher documentation ↗