/ Directory / Playground / Snowflake MCP
← All servers ↗ GitHub
● Official snowflake-labs ⚡ Instant

Snowflake MCP

by snowflake-labs · Snowflake-Labs/mcp

Official Snowflake MCP — query warehouses, prompt Cortex agents, manage objects, and consume semantic views from any MCP client.

Snowflake MCP is a Model Context Protocol server maintained by snowflake-labs. Official Snowflake MCP — query warehouses, prompt Cortex agents, manage objects, and consume semantic views from any MCP client. See README for installation and configuration: https://github.com/Snowflake-Labs/mcp

▶ Watch demo 📦 Install 💡 Use Cases

Why use it

Key features

Live Demo

What it looks like in practice

snowflake-mcp.replay ▶ ready
0/0

Install

Pick your client

~/Library/Application Support/Claude/claude_desktop_config.json  · Windows: %APPDATA%\Claude\claude_desktop_config.json
{
  "mcpServers": {
    "snowflake-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp"
      ],
      "_inferred": true
    }
  }
}

Open Claude Desktop → Settings → Developer → Edit Config. Restart after saving.

~/.cursor/mcp.json · .cursor/mcp.json
{
  "mcpServers": {
    "snowflake-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp"
      ],
      "_inferred": true
    }
  }
}

Cursor uses the same mcpServers schema as Claude Desktop. Project config wins over global.

VS Code → Cline → MCP Servers → Edit
{
  "mcpServers": {
    "snowflake-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp"
      ],
      "_inferred": true
    }
  }
}

Click the MCP Servers icon in the Cline sidebar, then "Edit Configuration".

~/.codeium/windsurf/mcp_config.json
{
  "mcpServers": {
    "snowflake-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp"
      ],
      "_inferred": true
    }
  }
}

Same shape as Claude Desktop. Restart Windsurf to pick up changes.

~/.continue/config.json
{
  "mcpServers": [
    {
      "name": "snowflake-mcp",
      "command": "npx",
      "args": [
        "-y",
        "mcp"
      ]
    }
  ]
}

Continue uses an array of server objects rather than a map.

~/.config/zed/settings.json
{
  "context_servers": {
    "snowflake-mcp": {
      "command": {
        "path": "npx",
        "args": [
          "-y",
          "mcp"
        ]
      }
    }
  }
}

Add to context_servers. Zed hot-reloads on save.

claude mcp add snowflake-mcp -- npx -y mcp

One-liner. Verify with claude mcp list. Remove with claude mcp remove.

Use Cases

Real-world ways to use Snowflake MCP

Use Snowflake MCP for its primary workflow

👤 Claude Code users ⏱ ~20 min intermediate

When to use: See repo README for canonical use cases.

Prerequisites
  • Repo cloned or installed — See https://github.com/Snowflake-Labs/mcp
Flow
  1. Install
    Install Snowflake MCP per README.✓ Copied
    → Tool registered with client
  2. Configure
    Provide credentials/config as instructed.✓ Copied
    → Successful auth/init
  3. Use
    Run a sample task with Snowflake MCP.✓ Copied
    → Expected output

Outcome: You can drive the documented workflow end-to-end.

Pitfalls
  • Skipping README — Read the repo README and CHANGELOG before shipping to prod.

Tools

What this MCP exposes

ToolInputsWhen to callCost
primary see README Primary action free

Cost & Limits

What this costs to run

API quota
None of its own; bounded by upstream provider quotas if any
Tokens per call
Depends on usage
Monetary
Open source — check repo LICENSE
Tip
Review upstream API costs (if any) before automating.

Security

Permissions, secrets, blast radius

Minimum scopes: Whatever the upstream provider requires
Credential storage: Env vars or local config — never commit secrets
Data egress: Forwards data per its README
Never grant: Full admin to untrusted prompts

Troubleshooting

Common errors and fixes

Auth fails

Verify credentials and required scopes match README.

Verify: Re-read repo README auth section.
Tool not found by client

Ensure MCP client config points to correct command/path.

Verify: Restart the client after editing config.

More

Resources

📖 Read the official README on GitHub

🐙 Browse open issues

🔍 Browse all 400+ MCP servers and Skills