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.7.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 type (e.g. snowflake, externalbrowser)

--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 type (e.g. snowflake, externalbrowser)

SNOWFLAKE_PRIVATE_KEY_FILE(str)

Absolute path to .p8 private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD(str)

Secret

Passphrase for encrypted private key