OSS Snowflake MCP Server

Package (pypi 1.3.5)

uvx snowflake-labs-mcp

Or add to your MCP client config:

{
  "mcpServers": {
    "mcp": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_VALUE>",
        "SNOWFLAKE_HOST": "<YOUR_VALUE>",
        "SNOWFLAKE_USER": "<YOUR_VALUE>",
        "SNOWFLAKE_PASSWORD": "<YOUR_VALUE>",
        "SNOWFLAKE_ROLE": "<YOUR_VALUE>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_VALUE>",
        "SNOWFLAKE_PASSCODE": "<YOUR_VALUE>",
        "SNOWFLAKE_PRIVATE_KEY": "<YOUR_VALUE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "<YOUR_VALUE>",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<YOUR_VALUE>",
        "SNOWFLAKE_MCP_HOST": "<YOUR_VALUE>",
        "SNOWFLAKE_MCP_PORT": "<YOUR_VALUE>",
        "SNOWFLAKE_MCP_ENDPOINT": "<YOUR_VALUE>"
      }
    }
  }
}

• 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)

This server takes extra arguments — see its repository.