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
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.
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.
claude mcp add mcp-snowflake-server -- uvx mcp-snowflake-server-nsp
{
"mcpServers": {
"mcp-snowflake-server": {
"args": [
"mcp-snowflake-server-nsp"
],
"command": "uvx"
}
}
}
[mcp_servers.mcp-snowflake-server]
command = "uvx"
args = ["mcp-snowflake-server-nsp"]
{
"mcpServers": {
"mcp-snowflake-server": {
"args": [
"mcp-snowflake-server-nsp"
],
"command": "uvx"
}
}
}
{
"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.
PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants
Database MCP server for schema discovery, comments, and SQL queries.
MCP server for Manticore Search — lets AI assistants query and manage search databases.
MCP server for SQL Server: schema inspection, safe read-only queries, query plan analysis
MCP server for one MySQL database: schema, read-only queries and guarded writes.
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
Python MCP server for MySQL database inspection and querying
SQL analytics and data engineering for AI Assistants and IDEs
Answers built from our own checks of this server.