A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
uvx mcp-snowflake-server-nsp{
"SNOWFLAKE_ACCOUNT": "YOUR_VALUE_HERE",
"SNOWFLAKE_USER": "YOUR_VALUE_HERE",
"SNOWFLAKE_PASSWORD": "YOUR_SECRET_VALUE",
"SNOWFLAKE_WAREHOUSE": "YOUR_VALUE_HERE",
"SNOWFLAKE_DATABASE": "YOUR_VALUE_HERE",
"SNOWFLAKE_SCHEMA": "YOUR_VALUE_HERE",
"SNOWFLAKE_ROLE": "YOUR_VALUE_HERE",
"SNOWFLAKE_AUTHENTICATOR": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_FILE": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "YOUR_SECRET_VALUE",
"SNOWFLAKE_OAUTH_CLIENT_ID": "YOUR_VALUE_HERE",
"SNOWFLAKE_OAUTH_CLIENT_SECRET": "YOUR_SECRET_VALUE",
"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "YOUR_VALUE_HERE",
"SNOWFLAKE_OAUTH_SCOPE": "YOUR_VALUE_HERE",
"SNOWFLAKE_TOKEN": "YOUR_SECRET_VALUE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-nsphung-mcp-snowflake-server": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "YOUR_VALUE_HERE",
"SNOWFLAKE_USER": "YOUR_VALUE_HERE",
"SNOWFLAKE_PASSWORD": "YOUR_SECRET_VALUE",
"SNOWFLAKE_WAREHOUSE": "YOUR_VALUE_HERE",
"SNOWFLAKE_DATABASE": "YOUR_VALUE_HERE",
"SNOWFLAKE_SCHEMA": "YOUR_VALUE_HERE",
"SNOWFLAKE_ROLE": "YOUR_VALUE_HERE",
"SNOWFLAKE_AUTHENTICATOR": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_FILE": "YOUR_VALUE_HERE",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "YOUR_SECRET_VALUE",
"SNOWFLAKE_OAUTH_CLIENT_ID": "YOUR_VALUE_HERE",
"SNOWFLAKE_OAUTH_CLIENT_SECRET": "YOUR_SECRET_VALUE",
"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "YOUR_VALUE_HERE",
"SNOWFLAKE_OAUTH_SCOPE": "YOUR_VALUE_HERE",
"SNOWFLAKE_TOKEN": "YOUR_SECRET_VALUE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
Snowflake MCP Server is an MCP server for A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants. It supports STDIO transport.
Use the generated config in Install. This server runs with uvx mcp-snowflake-server-nsp; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for uvx mcp-snowflake-server-nsp. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for uvx mcp-snowflake-server-nsp. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for uvx mcp-snowflake-server-nsp. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for uvx mcp-snowflake-server-nsp. Add required environment variables before starting Cursor or VS Code.
Snowflake MCP Server uses STDIO transport. Use the package or command config in Install.
Snowflake MCP Server inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
Snowflake MCP Server does not advertise a verified auth requirement. If discovery fails, it may still need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
mcp-snowflake-server-nspstdio | pypi | 0.8.0 | Argument: --account Argument: --user Argument: --password Argument: --warehouse Argument: --database Argument: --schema Argument: --role Argument: --authenticator Argument: --private_key_file Argument: --private_key_file_pwd Argument: --connections-file Argument: --connection-name Argument: --allow_write Argument: --prefetch Argument: --exclude_tools Argument: --exclude-json-results Argument: --log_dir Argument: --log_level Env: SNOWFLAKE_ACCOUNT Env: SNOWFLAKE_USER Env: SNOWFLAKE_PASSWORD secret Env: SNOWFLAKE_WAREHOUSE Env: SNOWFLAKE_DATABASE Env: SNOWFLAKE_SCHEMA Env: SNOWFLAKE_ROLE Env: SNOWFLAKE_AUTHENTICATOR Env: SNOWFLAKE_PRIVATE_KEY_FILE Env: SNOWFLAKE_PRIVATE_KEY_FILE_PWD secret Env: SNOWFLAKE_OAUTH_CLIENT_ID Env: SNOWFLAKE_OAUTH_CLIENT_SECRET secret Env: SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL Env: SNOWFLAKE_OAUTH_SCOPE Env: SNOWFLAKE_TOKEN secret |