Skip to main content

Install and Setup Snowflake MCP

This tutorial was written for local testing and experimentation of Snowflake MCP with Claude. Before you install your Snowflake MCP server, you will want to configure Python for MCP. These templates were built on a Windows 11 machine for testing and experimentation purposes. Production / server-hosted MCPs should

Install Snowflake MCP Server

Test UVX with official Snowflake MCP server

uvx --from "git+https://github.com/Snowflake-Labs/mcp" mcp-server-snowflake --help

Claude Desktop Configuration Template

Create/update your Claude Desktop config at: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "mcp-server-snowflake": {
      "command": "uvx",
      "args": [
        "--from",
        "git+https://github.com/Snowflake-Labs/mcp",
        "mcp-server-snowflake",
        "--service-config-file",
        "C:/path/to/your/snowflake-config.yaml"
      ],
      "env": {
        "SNOWFLAKE_PAT": "your_token_here",
        "SNOWFLAKE_ACCOUNT": "your_account_here",
        "SNOWFLAKE_USER": "your_username_here"
      }
    }
  }
}

Securing your credentials: If you intend to run this on your computer beyond testing and experimentation, we recommend installing environment variables. If your Snowflake user has elevated permissions, including but not limited to AccountAdmin or SystemAdmin roles, do not store your credentials locally in your config.json

Setting Environment Variables:

# Set permanent environment variables
[Environment]::SetEnvironmentVariable("SNOWFLAKE_PAT", "your_token", "User")
[Environment]::SetEnvironmentVariable("SNOWFLAKE_ACCOUNT", "your_account", "User")
[Environment]::SetEnvironmentVariable("SNOWFLAKE_USER", "your_username", "User")

Troubleshooting Commands

Check Python Environment

# Check all Python installations
where python
Get-Command python -All

# Check installed packages
pip list

# Check UV installation
uv pip list

Test MCP Server Connection

# Test server manually (without Claude)
uvx --from "git+https://github.com/Snowflake-Labs/m