Snowflake MCP Server

by nsphungio.github.nsphung/mcp-snowflake-serverv0.14.4

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

2Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active7d ago

Install Snowflake MCP server

claude mcp add snowflake-server-nsp -e SNOWFLAKE_PASSWORD='<snowflake-password>' -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD='<snowflake-private-key-file-pwd>' -e SNOWFLAKE_OAUTH_CLIENT_SECRET='<snowflake-oauth-client-secret>' -e SNOWFLAKE_TOKEN='<snowflake-token>' -- uvx mcp-snowflake-server-nsp --log_level INFO

{
  "mcpServers": {
    "snowflake-server-nsp": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--log_level",
        "INFO"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake-private-key-file-pwd>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<snowflake-oauth-client-secret>",
        "SNOWFLAKE_TOKEN": "<snowflake-token>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "snowflake-server-nsp": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--log_level",
        "INFO"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake-private-key-file-pwd>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<snowflake-oauth-client-secret>",
        "SNOWFLAKE_TOKEN": "<snowflake-token>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "snowflake-server-nsp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--log_level",
        "INFO"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake-private-key-file-pwd>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<snowflake-oauth-client-secret>",
        "SNOWFLAKE_TOKEN": "<snowflake-token>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "snowflake-server-nsp": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--log_level",
        "INFO"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake-private-key-file-pwd>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<snowflake-oauth-client-secret>",
        "SNOWFLAKE_TOKEN": "<snowflake-token>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
SNOWFLAKE_ACCOUNT	—	—	Snowflake account identifier
SNOWFLAKE_USER	—	—	Snowflake username
SNOWFLAKE_PASSWORD	—	yes	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	—	yes	Passphrase for encrypted private key
SNOWFLAKE_OAUTH_CLIENT_ID	—	—	OAuth 2.0 client ID (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_CLIENT_SECRET	—	yes	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	—	yes	Pre-fetched OAuth bearer token (required for oauth authenticator)

Freshness

Active — last maintenance signal 7d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-02 · 7d ago · GitHub
Latest release
2026-09-24 · 16d ago · GitHub · v0.14.4
Package published
no data · npm/PyPI
Registry entry updated
2026-09-24 · 16d ago · official registry · v0.14.4

FAQ

›How do I install the Snowflake MCP server in Claude Code?

Run: claude mcp add snowflake-server-nsp -e SNOWFLAKE_PASSWORD='<snowflake-password>' -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD='<snowflake-private-key-file-pwd>' -e SNOWFLAKE_OAUTH_CLIENT_SECRET='<snowflake-oauth-client-secret>' -e SNOWFLAKE_TOKEN='<snowflake-token>' -- uvx mcp-snowflake-server-nsp --log_level INFO. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Snowflake require an API key?

Yes. It expects SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_FILE_PWD, SNOWFLAKE_OAUTH_CLIENT_SECRET, SNOWFLAKE_TOKEN, of which 4 are secrets.

›Can I use Snowflake as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Snowflake in the official MCP registry?

Yes, as io.github.nsphung/mcp-snowflake-server.