← Index

Snowflake MCP Server

io.github.nsphung/mcp-snowflake-server·v0.8.0·Databases
Quality Score
85
/100

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

§01  Install
Claude Desktop (uvx)
{
  "mcpServers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<snowflake_account>",
        "SNOWFLAKE_USER": "<snowflake_user>",
        "SNOWFLAKE_PASSWORD": "<your-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": "<your-snowflake_private_key_file_pwd>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<snowflake_oauth_client_id>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<your-snowflake_oauth_client_secret>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<snowflake_oauth_token_request_url>",
        "SNOWFLAKE_OAUTH_SCOPE": "<snowflake_oauth_scope>",
        "SNOWFLAKE_TOKEN": "<your-snowflake_token>"
      }
    }
  }
}
§02  Environment variables
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)

§03  MCP Quality Score  ·  methodology
freshness
25
completeness
15
installability
25
documentation
15
stability
5
§04  Alternatives in Databases