mcpbeat Sign in

Snowflake MCP Server

local only

Snowflake MCP Server runs on your own machine — the client starts it, so there is no endpoint to ping. 591 installs a week from pypi. Last commit 16 Sep 2026.

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

Installs per day peak 315 · avg 51 · +75% w/w
a month agotoday
591
Installs / week
pypi · mcp-snowflake-server-nsp
2
Stars
0 open issues
16 Sep 2026
Last commit
0 releases in 90 days
MIT
License
Python

Nothing serious here today

Today is the operative word: we check Snowflake MCP Server every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add mcp-snowflake-server -- uvx mcp-snowflake-server-nsp
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "command": "uvx"
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-snowflake-server]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "command": "uvx"
    }
  }
}
.vscode/mcp.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: SNOWFLAKE_ACCOUNT (Snowflake account identifier), SNOWFLAKE_USER (Snowflake username), SNOWFLAKE_PASSWORD (Password (not required for key-pair / SSO)), SNOWFLAKE_WAREHOUSE (Virtual warehouse to use), SNOWFLAKE_DATABASE (Default database), SNOWFLAKE_SCHEMA (Default schema), SNOWFLAKE_ROLE (Role to assume), SNOWFLAKE_AUTHENTICATOR (Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials), SNOWFLAKE_PRIVATE_KEY_FILE (Absolute path to .p8 private key file), SNOWFLAKE_PRIVATE_KEY_FILE_PWD (Passphrase for encrypted private key), SNOWFLAKE_OAUTH_CLIENT_ID (OAuth 2.0 client ID (required for oauth_client_credentials authenticator)), SNOWFLAKE_OAUTH_CLIENT_SECRET (OAuth 2.0 client secret (required for oauth_client_credentials authenticator)), SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL (OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)), SNOWFLAKE_OAUTH_SCOPE (OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)), SNOWFLAKE_TOKEN (Pre-fetched OAuth bearer token (required for oauth authenticator)). The author declared them in the registry entry; get the values from the project itself.

Alternatives to Snowflake MCP Server

same job, measured the same way
PostgreSQL MCP Server
by yawlabs

PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

4 335 installs/wk local only
AdoMcp
by john0king

Database MCP server for schema discovery, comments, and SQL queries.

local only
Manticore Search
by manticoresoftware

MCP server for Manticore Search — lets AI assistants query and manage search databases.

75 installs/wk local only
SqlServerMcp
by nithish1206

MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis

local only
MySQL MCP
by gistrec

MCP server for one MySQL database: schema, read-only queries and guarded writes.

27 installs/wk local only
Keboola
by keboola

Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...

3 079 installs/wk answering
MySQL MCP Server
by musaddiq-dev

Python MCP server for MySQL database inspection and querying

79 installs/wk local only
MCP Server Motherduck
by motherduckdb

SQL analytics and data engineering for AI Assistants and IDEs

4 435 installs/wk local only

Snowflake MCP Server — questions

Answers built from our own checks of this server.

Why is there no uptime for Snowflake MCP Server?
Snowflake MCP Server runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package mcp-snowflake-server-nsp was installed 591 times last week.
How do I connect Snowflake MCP Server?
Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls mcp-snowflake-server-nsp straight from pypi; nothing to host, nothing to sign up for.
How many people use Snowflake MCP Server?
The pypi package mcp-snowflake-server-nsp was installed 591 times in the last week. Week over week that is +75%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.
Is Snowflake MCP Server open source?
Yes — it is published under the MIT licence, written in Python and 2 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.