OSS Snowflake MCP Server

MCP

by Snowflake-Labs · v1.3.5

MCP Server for Snowflake from Snowflake Labs

mcplocal

MCP configuration

stdio

Command

uvx snowflake-labs-mcp==1.3.5 --service-config-file --account --host --user --password --role --warehouse --passcode-in-password --passcode --private-key --private-key-file --private-key-file-pwd --authenticator snowflake --connection-name --transport stdio --server-host 0.0.0.0 --port 9000 --endpoint /mcp

Environment

  • SNOWFLAKE_ACCOUNT

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

  • SNOWFLAKE_HOST

    Snowflake host URL

  • SNOWFLAKE_USER

    Username for authentication

  • SNOWFLAKE_PASSWORDsecret

    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_KEYsecret

    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)

Install in one click with Zurek

Browse here, install from the native macOS app — pick targets, fill env vars, and write configs safely.