mcp-snowflake-server

Snowflake MCP Server

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

stdiocommunityservice

Package Details

mcp-snowflake-server-nsp

0.13.0•https://pypi.org/project/mcp-snowflake-server-nsp

Transportstdio

Runtimeuvx

Package Arguments

Named

--account

Snowflake account identifier

--user

Snowflake username

--password

Password (not required for key-pair / SSO)

--warehouse

Virtual warehouse to use

--database

Default database

--schema

Default schema

--role

Role to assume

--authenticator

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

--private_key_file

Absolute path to .p8 private key file

--private_key_file_pwd

Passphrase for encrypted private key

--connections-file

Path to TOML connections file

--connection-name

Connection profile name in TOML file (required with --connections-file)

--allow_write

Enable write_query and create_table tools

--prefetch

Pre-load table schema as context://table/* resources (disables list_tables / describe_table)

--exclude_tools

Space-separated list of tool names to disable

--exclude-json-results

Omit embedded JSON resources from responses (reduces context window usage)

--log_dir

Directory for log file output

--log_level

Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL

Environment Variables

SNOWFLAKE_ACCOUNT(str)

Snowflake account identifier

SNOWFLAKE_USER(str)

Snowflake username

SNOWFLAKE_PASSWORD(str)

Secret

Password (not required for key-pair / SSO)

SNOWFLAKE_WAREHOUSE(str)

Virtual warehouse to use

SNOWFLAKE_DATABASE(str)

Default database

SNOWFLAKE_SCHEMA(str)

Default schema

SNOWFLAKE_ROLE(str)

Role to assume

SNOWFLAKE_AUTHENTICATOR(str)

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

SNOWFLAKE_PRIVATE_KEY_FILE(str)

Absolute path to .p8 private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD(str)

Secret

Passphrase for encrypted private key

SNOWFLAKE_OAUTH_CLIENT_ID(str)

OAuth 2.0 client ID (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_CLIENT_SECRET(str)

Secret

OAuth 2.0 client secret (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL(str)

OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_SCOPE(str)

OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)

SNOWFLAKE_TOKEN(str)

Secret

Pre-fetched OAuth bearer token (required for oauth authenticator)

docker.io/nsphung/mcp-snowflake-server-nsp:0.13.0

https://hub.docker.com/r/nsphung/mcp-snowflake-server-nsp

Transportstdio

Runtimedocker

Runtime Arguments

Positional

Position 0

--rm

Position 1

-i

Package Arguments

Named

--account

Snowflake account identifier

--user

Snowflake username

--password

Password (not required for key-pair / SSO)

--warehouse

Virtual warehouse to use

--database

Default database

--schema

Default schema

--role

Role to assume

--authenticator

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

--private_key_file

Absolute path to .p8 private key file

--private_key_file_pwd

Passphrase for encrypted private key

--connections-file

Path to TOML connections file

--connection-name

Connection profile name in TOML file (required with --connections-file)

--allow_write

Enable write_query and create_table tools

--prefetch

Pre-load table schema as context://table/* resources (disables list_tables / describe_table)

--exclude_tools

Space-separated list of tool names to disable

--exclude-json-results

Omit embedded JSON resources from responses (reduces context window usage)

--log_dir

Directory for log file output

--log_level

Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL

Environment Variables

SNOWFLAKE_ACCOUNT(str)

Snowflake account identifier

SNOWFLAKE_USER(str)

Snowflake username

SNOWFLAKE_PASSWORD(str)

Secret

Password (not required for key-pair / SSO)

SNOWFLAKE_WAREHOUSE(str)

Virtual warehouse to use

SNOWFLAKE_DATABASE(str)

Default database

SNOWFLAKE_SCHEMA(str)

Default schema

SNOWFLAKE_ROLE(str)

Role to assume

SNOWFLAKE_AUTHENTICATOR(str)

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials

SNOWFLAKE_PRIVATE_KEY_FILE(str)

Absolute path to .p8 private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD(str)

Secret

Passphrase for encrypted private key

SNOWFLAKE_OAUTH_CLIENT_ID(str)

OAuth 2.0 client ID (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_CLIENT_SECRET(str)

Secret

OAuth 2.0 client secret (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL(str)

OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)

SNOWFLAKE_OAUTH_SCOPE(str)

OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)

SNOWFLAKE_TOKEN(str)

Secret

Pre-fetched OAuth bearer token (required for oauth authenticator)