OSS Snowflake MCP Server

io.github.Snowflake-Labs/mcp · v1.3.5

MCP Server for Snowflake from Snowflake Labs

Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add mcp -e SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> -e SNOWFLAKE_HOST=<SNOWFLAKE_HOST> -e SNOWFLAKE_USER=<SNOWFLAKE_USER> -e SNOWFLAKE_PASSWORD=<SNOWFLAKE_PASSWORD> -e SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> -e SNOWFLAKE_WAREHOUSE=<SNOWFLAKE_WAREHOUSE> -e SNOWFLAKE_PASSCODE=<SNOWFLAKE_PASSCODE> -e SNOWFLAKE_PRIVATE_KEY=<SNOWFLAKE_PRIVATE_KEY> -e SNOWFLAKE_PRIVATE_KEY_FILE=<SNOWFLAKE_PRIVATE_KEY_FILE> -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD=<SNOWFLAKE_PRIVATE_KEY_FILE_PWD> -e SNOWFLAKE_MCP_HOST=<SNOWFLAKE_MCP_HOST> -e SNOWFLAKE_MCP_PORT=<SNOWFLAKE_MCP_PORT> -e SNOWFLAKE_MCP_ENDPOINT=<SNOWFLAKE_MCP_ENDPOINT> -- uvx snowflake-labs-mcp==1.3.5

claude_desktop_config.json

{
  "mcpServers": {
    "mcp": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_HOST": "<SNOWFLAKE_HOST>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_PASSCODE": "<SNOWFLAKE_PASSCODE>",
        "SNOWFLAKE_PRIVATE_KEY": "<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>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_HOST": "<SNOWFLAKE_HOST>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_PASSCODE": "<SNOWFLAKE_PASSCODE>",
        "SNOWFLAKE_PRIVATE_KEY": "<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>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp==1.3.5"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_HOST": "<SNOWFLAKE_HOST>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_PASSCODE": "<SNOWFLAKE_PASSCODE>",
        "SNOWFLAKE_PRIVATE_KEY": "<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>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

Name	Description
`SNOWFLAKE_ACCOUNT` Optional	Account identifier (e.g. xy12345.us-east-1)
`SNOWFLAKE_HOST` Optional	Snowflake host URL
`SNOWFLAKE_USER` Optional	Username for authentication
`SNOWFLAKE_PASSWORD` Optional, secret	Password or programmatic access token
`SNOWFLAKE_ROLE` Optional	Role to use for connection
`SNOWFLAKE_WAREHOUSE` Optional	Warehouse to use for queries
`SNOWFLAKE_PASSCODE` Optional	MFA passcode for authentication
`SNOWFLAKE_PRIVATE_KEY` Optional, secret	Private key for key pair authentication
`SNOWFLAKE_PRIVATE_KEY_FILE` Optional	Path to private key file
`SNOWFLAKE_PRIVATE_KEY_FILE_PWD` Optional	Password for encrypted private key
`SNOWFLAKE_MCP_HOST` Optional	Host address to bind the server to (default: 0.0.0.0)
`SNOWFLAKE_MCP_PORT` Optional	Port number for the server to listen on (default: 9000)
`SNOWFLAKE_MCP_ENDPOINT` Optional	Endpoint path for the MCP server (default: /mcp)

Details

Package	`[email protected]` (PYPI, stdio)
First published	28 Oct 2025
Last updated	28 Oct 2025
Registry name	`io.github.Snowflake-Labs/mcp`

More databases servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use OSS Snowflake MCP Server often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-snowflake-labs-mcp/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-snowflake-labs-mcp)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.