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. 194 installs a week from pypi. Last commit 31 Oct 2026.

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

Installs per day peak 101 · avg 46 · -17% w/w
a month agotoday
194
Installs / week
pypi · mcp-snowflake-server-nsp
2
Stars
4 open issues
31 Oct 2026
Last commit
from GitHub
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": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ]
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-snowflake-server]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ]
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-snowflake-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ]
    }
  }
}

Optional settings from the registry entry, left out of the block above: 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)).

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

2 146 installs/wk local only
AdoMcp
by john0king

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

local only
Sqlanywhere MCP
by dwarf1er

MCP server for SAP SQL Anywhere 17: explore schemas and run read-only queries.

local only
Manticore Search
by manticoresoftware

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

114 installs/wk local only
SqlServerMcp
by nithish1206

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

local only
Elekto MCP for SQL Server
by elekto-com-br

Read-only SQL Server introspection and querying: schema, definitions, dependencies and data.

local only
MySQL MCP
by gistrec

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

89 installs/wk local only
Keboola
by keboola

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

2 294 installs/wk answering

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 194 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 in the form 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 194 times in the last week. Week over week that is -17%. 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, 2 stars on GitHub and 4 open issues. The source link is on this page, so you can read exactly what it does with your data before you connect it.