NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

Snowflake MCP Server

io.github.nsphung/mcp-snowflake-server · v0.14.4

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

Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add mcp-snowflake-server -e SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> -e SNOWFLAKE_USER=<SNOWFLAKE_USER> -e SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> -e SNOWFLAKE_WAREHOUSE=<SNOWFLAKE_WAREHOUSE> -e SNOWFLAKE_DATABASE=<SNOWFLAKE_DATABASE> -e SNOWFLAKE_SCHEMA=<SNOWFLAKE_SCHEMA> -e SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> -e SNOWFLAKE_AUTHENTICATOR=<SNOWFLAKE_AUTHENTICATOR> -e SNOWFLAKE_PRIVATE_KEY_FILE=<SNOWFLAKE_PRIVATE_KEY_FILE> -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD=<SNOWFLAKE_PRIVATE_KEY_FILE_PWD> -e SNOWFLAKE_OAUTH_CLIENT_ID=<SNOWFLAKE_OAUTH_CLIENT_ID> -e SNOWFLAKE_OAUTH_CLIENT_SECRET=<SNOWFLAKE_OAUTH_CLIENT_SECRET> -e SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL=<SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL> -e SNOWFLAKE_OAUTH_SCOPE=<SNOWFLAKE_OAUTH_SCOPE> -e SNOWFLAKE_TOKEN=<SNOWFLAKE_TOKEN> -- uvx mcp-snowflake-server-nsp==0.14.4
claude_desktop_config.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<SNOWFLAKE_TOKEN>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<SNOWFLAKE_TOKEN>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-snowflake-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp==0.14.4"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
SNOWFLAKE_ACCOUNT
Optional		Snowflake account identifier
SNOWFLAKE_USER
Optional		Snowflake username
SNOWFLAKE_PASSWORD
Optional, secret		Password (not required for key-pair / SSO)
SNOWFLAKE_WAREHOUSE
Optional		Virtual warehouse to use
SNOWFLAKE_DATABASE
Optional		Default database
SNOWFLAKE_SCHEMA
Optional		Default schema
SNOWFLAKE_ROLE
Optional		Role to assume
SNOWFLAKE_AUTHENTICATOR
Optional		Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
SNOWFLAKE_PRIVATE_KEY_FILE
Optional		Absolute path to .p8 private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWD
Optional, secret		Passphrase for encrypted private key
SNOWFLAKE_OAUTH_CLIENT_ID
Optional		OAuth 2.0 client ID (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_CLIENT_SECRET
Optional, secret		OAuth 2.0 client secret (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL
Optional		OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_SCOPE
Optional		OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
SNOWFLAKE_TOKEN
Optional, secret		Pre-fetched OAuth bearer token (required for oauth authenticator)

Details

Package[email protected] (PYPI, stdio)
Packagedocker.io/nsphung/mcp-snowflake-server-nsp:0.14.4 (OCI, stdio)
First published24 Sep 2026
Last updated24 Sep 2026
Registry nameio.github.nsphung/mcp-snowflake-server

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.