Snowflake MCP Server

Snowflake is a cloud data warehouse platform that enables data storage, processing, and analytics with scalable compute and storage resources.

Tools

Last Updated

Apr 7, 2026

What is the Snowflake MCP Server?

The Snowflake MCP server gives AI agents structured, permission-aware access to Snowflake through the Model Context Protocol. With 43 pre-built actions, agents can read, create, and update Snowflake data on behalf of authorized users.

Willow ships the Snowflake MCP server as part of an enterprise control plane. Every call runs behind SSO (Okta, Azure AD), enforces RBAC and least-privilege at runtime, writes to a full audit trail, and integrates with Splunk and Loki for SIEM visibility. Connect from Claude Desktop, Claude Code, Cursor, ChatGPT, VS Code, n8n, or any custom agent. Install once, distribute org-wide, and see exactly how Snowflake is being used by every AI agent in your stack.

Tools

Execute Query

Execute a SQL query synchronously in Snowflake. Returns results immediately for queries that complete within 45 seconds. Use this for quick queries, data exploration, and interactive analysis.

Execute Query Async

Submit a SQL query for asynchronous execution in Snowflake. Returns a statement handle immediately. Use this for long-running queries, large data operations, or when you need to execute multiple queries in parallel.

Check Query Status

Check the execution status of an asynchronous query. Returns the current state (running, success, failed) and progress information. Use after submitting an async query to monitor its progress.

Get Query Results

Retrieve the results of a completed asynchronous query. Returns the data rows and metadata. Use this after an async query has completed successfully.

Cancel Query

Cancel a running query in Snowflake. Use this to stop long-running queries that are no longer needed or were submitted by mistake.

List Databases

List all databases accessible to the current user in Snowflake. Returns database names, owners, and metadata. Useful for discovering available data sources.

List Schemas

List all schemas in a specific database. Returns schema names, owners, and metadata. Essential for navigating database structure and finding relevant data.

List Tables

List all tables and views in a schema. Returns table names, types (TABLE/VIEW), row counts, and metadata. Critical for data discovery and understanding available datasets.

Describe Table

Get detailed information about a table's structure including column names, data types, nullability, defaults, and keys. Essential for understanding table schema before querying.

Get Table Sample

Retrieve sample rows from a table for quick data exploration. Returns a limited number of rows to understand data format and content without reading the entire table.

1 2 3...5

1–10 of 43 tools

Customize Tools

Edit descriptions, modify arguments, select tools, or add new ones

Set Up Your Snowflake MCP Server in Minutes

Add the following configuration to your MCP client. Authentication is handled via OAuth. Compatible with Claude Desktop, Claude Code, Cursor, ChatGPT, VS Code, n8n, and any MCP-compatible agent.

Claude Desktop

claude_desktop_config.json

{
  "mcpServers": {
    "willow-snowflake": {
      "type": "http",
      "url": "https://<org>.mcp-s.com/mcp/mcp/snowflake"
    }
  }
}

Cursor

.cursor/mcp.json

{
  "mcpServers": {
    "willow-snowflake": {
      "type": "http",
      "url": "https://<org>.mcp-s.com/mcp/mcp/snowflake"
    }
  }
}

Claude Code

CLI

claude mcp add willow-snowflake --transport http https://<org>.mcp-s.com/mcp/mcp/snowflake

n8n

HTTP Request Node

{
  "url": "https://<org>.mcp-s.com/mcp/mcp/snowflake",
  "method": "POST"
}

Or click "Install with Willow" above to set up automatically with SSO and RBAC preconfigured.

Enterprise Governance for Snowflake

Willow adds the layer Snowflake and every other SaaS doesn't ship out of the box: every call runs behind SSO (Okta, Azure AD), enforces RBAC and least-privilege at runtime, writes to full audit logs, and detects shadow AI usage across your stack. One MCP gateway. Any agent. Every tool.

Snowflake MCP Server FAQ

What is the Snowflake MCP server?

The Snowflake MCP server is a Model Context Protocol implementation that lets AI agents like Claude, Cursor, and ChatGPT read and write Snowflake data through a standardized interface. Willow hosts and governs this server so enterprises can roll it out without a security review backlog.

How is Willow's Snowflake MCP server different from the official one?

The official Snowflake MCP server is scoped to a single user's account and does not include enterprise governance. Willow's version adds SSO, RBAC, audit logging, shadow AI detection, and centralized control over which actions agents can take across the entire org.

Which AI clients work with the Snowflake MCP server?

Claude Desktop, Claude Code, Cursor, ChatGPT, VS Code with MCP support, n8n, and any custom agent built with OpenAI Agents SDK, LangChain, Vercel AI SDK, or Anthropic SDK.

Is the Snowflake MCP server secure? How does Willow handle authentication?

Every call runs behind your existing SSO (Okta, Azure AD). Per-user OAuth scopes the agent to exactly what that user can do in Snowflake, nothing more. No credentials reach the LLM. Every action writes to an audit trail.

Can I limit which Snowflake actions agents can take?

Yes. Willow lets you scope agents to specific actions, specific projects, or specific environments. Toggle actions on or off in the dashboard, or enforce policy via infrastructure-as-code through GitHub.

How do I detect shadow Snowflake MCP servers in my org?

Willow's browser extension and discovery service surface unmanaged MCP servers, skills, and AI agents across the org. If a developer installed an unapproved Snowflake MCP locally, you'll see it.

What does the Snowflake MCP server cost?

Pricing depends on org size and deployment model (SaaS, dedicated cloud, self-host). See withwillow.ai/pricing or contact sales for a quote.

How do I install the Snowflake MCP server with Willow?

Install via the Willow Connect Panel in one click, or paste the JSON snippet above into your Claude Desktop, Cursor, or Claude Code config. SSO and RBAC inherit from your existing Willow setup.