dynamike/snowflake-mcp-serverMCPMCP Server

snowflake-mcp-server

MCP Server for connecting to Snowflake with read-only questions

13stars

12forks

Python

modelcontextprotocolsnowflake

Quality signals

StaleNo testsNo CIThin docsNo licenseNew

Open Repository Download ZIP

AI summary

Auto-generated overview of what this skill does and when to reach for it.

A read-only MCP server that lets AI assistants query Snowflake databases securely without modifying data.

Use this when

Need to fetch Snowflake data for an AI assistant
Debugging a view’s structure or SQL definition
Running ad-hoc read-only SQL queries via AI
Listing databases or views in a Snowflake account
Comparing data across views in different databases

Don't use when

Need to write or modify Snowflake data
Running non-read-only operations like INSERT or UPDATE
Querying non-Snowflake databases

Capabilities

List all accessible Snowflake databases
List views in a specified database and schema
Describe view structure and SQL definition
Query view data with optional row limits
Execute custom read-only SQL (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
Secure authentication via private key or browser

InstallMCPRun via uvx (Python)

Universal installANY TOOL

$ npx skillcity@latest dynamike/snowflake-mcp-server

Auto-detects the skill or MCP server in this repo and installs it for Claude Code, Codex, Cursor, Cline, OpenCode, Gemini CLI, Anti-Gravity, OpenClaw and Hermes.

Requires Node.js 18+ (ships with npx).

Or install manually

uvx snowflake-mcp-server

MCP Configuration

Add this to your claude_desktop_config.json

{
  "mcpServers": {
    "snowflake-mcp-server": {
      "command": "uvx",
      "args": [
        "snowflake-mcp-server"
      ]
    }
  }
}

Loading README…

Discover the toolingbehind modern intelligence

Discover the toolingbehind modern intelligence

snowflake-mcp-server