OSS Snowflake MCP Server

MCP Server for Snowflake from Snowflake Labs

stdioofficialservice

Package Details

Transportstdio

Package Arguments

Named
--service-config-fileRequired
Path to service specification file
--account
Account identifier (e.g. xy12345.us-east-1)
--host
Snowflake host URL
--user
Username for authentication
--password
Password or programmatic access token
--role
Role to use for connection
--warehouse
Warehouse to use for queries
--passcode-in-password
Whether passcode is embedded in password
--passcode
MFA passcode for authentication
--private-key
Private key for key pair authentication
--private-key-file
Path to private key file
--private-key-file-pwd
Password for encrypted private key
--authenticator
Authentication type
--connection-name
Name of connection from connections.toml (or config.toml) file
--transport
Transport for the MCP server
--server-host
Host address to bind the server to (default: 0.0.0.0)
--port
Port number for the server to listen on (default: 9000)
--endpoint
Custom endpoint path for HTTP transports

Environment Variables

SNOWFLAKE_ACCOUNT(str)

Account identifier (e.g. xy12345.us-east-1)

SNOWFLAKE_HOST(str)

Snowflake host URL

SNOWFLAKE_USER(str)

Username for authentication

SNOWFLAKE_PASSWORD(str)
Secret

Password or programmatic access token

SNOWFLAKE_ROLE(str)

Role to use for connection

SNOWFLAKE_WAREHOUSE(str)

Warehouse to use for queries

SNOWFLAKE_PASSCODE(str)

MFA passcode for authentication

SNOWFLAKE_PRIVATE_KEY(str)
Secret

Private key for key pair authentication

SNOWFLAKE_PRIVATE_KEY_FILE(str)

Path to private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD(str)

Password for encrypted private key

SNOWFLAKE_MCP_HOST(str)

Host address to bind the server to (default: 0.0.0.0)

SNOWFLAKE_MCP_PORT(num)

Port number for the server to listen on (default: 9000)

SNOWFLAKE_MCP_ENDPOINT(str)

Endpoint path for the MCP server (default: /mcp)