← Index

OSS Snowflake MCP Server

io.github.Snowflake-Labs/mcp·v1.3.5·Databases
Quality Score
73
/100

MCP Server for Snowflake from Snowflake Labs

§01  Install
Claude Desktop (uvx)
{
  "mcpServers": {
    "mcp": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<snowflake_account>",
        "SNOWFLAKE_HOST": "<snowflake_host>",
        "SNOWFLAKE_USER": "<snowflake_user>",
        "SNOWFLAKE_PASSWORD": "<your-snowflake_password>",
        "SNOWFLAKE_ROLE": "<snowflake_role>",
        "SNOWFLAKE_WAREHOUSE": "<snowflake_warehouse>",
        "SNOWFLAKE_PASSCODE": "<snowflake_passcode>",
        "SNOWFLAKE_PRIVATE_KEY": "<your-snowflake_private_key>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<snowflake_private_key_file>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<snowflake_private_key_file_pwd>",
        "SNOWFLAKE_MCP_HOST": "<snowflake_mcp_host>",
        "SNOWFLAKE_MCP_PORT": "<snowflake_mcp_port>",
        "SNOWFLAKE_MCP_ENDPOINT": "<snowflake_mcp_endpoint>"
      }
    }
  }
}
§02  Environment variables
SNOWFLAKE_ACCOUNT

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

SNOWFLAKE_HOST

Snowflake host URL

SNOWFLAKE_USER

Username for authentication

SNOWFLAKE_PASSWORD
secret

Password or programmatic access token

SNOWFLAKE_ROLE

Role to use for connection

SNOWFLAKE_WAREHOUSE

Warehouse to use for queries

SNOWFLAKE_PASSCODE

MFA passcode for authentication

SNOWFLAKE_PRIVATE_KEY
secret

Private key for key pair authentication

SNOWFLAKE_PRIVATE_KEY_FILE

Path to private key file

SNOWFLAKE_PRIVATE_KEY_FILE_PWD

Password for encrypted private key

SNOWFLAKE_MCP_HOST

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

SNOWFLAKE_MCP_PORT

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

SNOWFLAKE_MCP_ENDPOINT

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

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