Snowflake

Official Snowflake Data & databases

Lets an agent query Snowflake data, run SQL, manage objects, and use Cortex AI services. Summary written by AI Index.

The registry’s description: MCP Server for Snowflake from Snowflake Labs

Local package (pypi)

Add to your client

Add the Snowflake MCP server to Claude Code

  1. Run the command

    claude mcp add snowflake -- uvx snowflake-labs-mcp --service-config-file
  2. Fill in the values ↓

  3. Check it’s connected

If the file already has servers, add the entry inside the existing object. To check it’s connected, restart or reload the client and look for snowflake in its list of MCP servers. A server that needs sign-in opens it on first use.

What you fill in

Required values appear as <NAME> placeholders in the snippets; add optional ones the same way. Descriptions are the server’s registry entry’s.

  • <SNOWFLAKE_ACCOUNT> Environment variable Optional

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

  • <SNOWFLAKE_HOST> Environment variable Optional

    Snowflake host URL

  • <SNOWFLAKE_USER> Environment variable Optional

    Username for authentication

  • <SNOWFLAKE_PASSWORD> Environment variable Optional · Secret

    Password or programmatic access token

  • <SNOWFLAKE_ROLE> Environment variable Optional

    Role to use for connection

  • <SNOWFLAKE_WAREHOUSE> Environment variable Optional

    Warehouse to use for queries

  • <SNOWFLAKE_PASSCODE> Environment variable Optional

    MFA passcode for authentication

  • <SNOWFLAKE_PRIVATE_KEY> Environment variable Optional · Secret

    Private key for key pair authentication

  • <SNOWFLAKE_PRIVATE_KEY_FILE> Environment variable Optional

    Path to private key file

  • <SNOWFLAKE_PRIVATE_KEY_FILE_PWD> Environment variable Optional

    Password for encrypted private key

  • <SNOWFLAKE_MCP_HOST> Environment variable Optional

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

  • <SNOWFLAKE_MCP_PORT> Environment variable Optional

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

  • <SNOWFLAKE_MCP_ENDPOINT> Environment variable Optional

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

Client compatibility

By transport: whether the client’s docs list a transport this server offers. It doesn’t cover sign-in or other requirements.

Sources

This data comes from the Official MCP Registry.