MCP Server

Snowflake MCP Server MCP Server

Name: Snowflake MCP Server MCP Server
Author: io.github.nsphung

io.github.nsphung/mcp-snowflake-server

Repository Registry

What is the Snowflake MCP Server MCP server?

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

How to install Snowflake MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

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

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<YOUR_SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<YOUR_SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<YOUR_SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<YOUR_SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<YOUR_SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<YOUR_SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<YOUR_SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<YOUR_SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<YOUR_SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<YOUR_SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<YOUR_SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<YOUR_SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<YOUR_SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<YOUR_SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<YOUR_SNOWFLAKE_TOKEN>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mcp-snowflake-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp",
        "--account",
        "--user",
        "--password",
        "--warehouse",
        "--database",
        "--schema",
        "--role",
        "--authenticator",
        "--private_key_file",
        "--private_key_file_pwd",
        "--connections-file",
        "--connection-name",
        "--allow_write",
        "--prefetch",
        "--exclude_tools",
        "--exclude-json-results",
        "--log_dir",
        "--log_level"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_DATABASE": "<YOUR_SNOWFLAKE_DATABASE>",
        "SNOWFLAKE_SCHEMA": "<YOUR_SNOWFLAKE_SCHEMA>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>",
        "SNOWFLAKE_AUTHENTICATOR": "<YOUR_SNOWFLAKE_AUTHENTICATOR>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<YOUR_SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<YOUR_SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Claude Code

claude mcp add mcp-snowflake-server --env SNOWFLAKE_ACCOUNT=<YOUR_SNOWFLAKE_ACCOUNT> --env SNOWFLAKE_USER=<YOUR_SNOWFLAKE_USER> --env SNOWFLAKE_PASSWORD=<YOUR_SNOWFLAKE_PASSWORD> --env SNOWFLAKE_WAREHOUSE=<YOUR_SNOWFLAKE_WAREHOUSE> --env SNOWFLAKE_DATABASE=<YOUR_SNOWFLAKE_DATABASE> --env SNOWFLAKE_SCHEMA=<YOUR_SNOWFLAKE_SCHEMA> --env SNOWFLAKE_ROLE=<YOUR_SNOWFLAKE_ROLE> --env SNOWFLAKE_AUTHENTICATOR=<YOUR_SNOWFLAKE_AUTHENTICATOR> --env SNOWFLAKE_PRIVATE_KEY_FILE=<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE> --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=<YOUR_SNOWFLAKE_PRIVATE_KEY_FILE_PWD> --env SNOWFLAKE_OAUTH_CLIENT_ID=<YOUR_SNOWFLAKE_OAUTH_CLIENT_ID> --env SNOWFLAKE_OAUTH_CLIENT_SECRET=<YOUR_SNOWFLAKE_OAUTH_CLIENT_SECRET> --env SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL=<YOUR_SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL> --env SNOWFLAKE_OAUTH_SCOPE=<YOUR_SNOWFLAKE_OAUTH_SCOPE> --env SNOWFLAKE_TOKEN=<YOUR_SNOWFLAKE_TOKEN> -- uvx mcp-snowflake-server-nsp --account --user --password --warehouse --database --schema --role --authenticator --private_key_file --private_key_file_pwd --connections-file --connection-name --allow_write --prefetch --exclude_tools --exclude-json-results --log_dir --log_level