Skip to main content

Install and Setup Snowflake MCP with Claude

This tutorial was written for local testing and experimentation of Snowflake MCP with Claude using the latest Snowflake-hosted MCP service.

Snowflake Native MCP Service – Nov 2025 Update

Snowflake now natively supports MCP without needing to install the server locally. To connect to Snowflake MCP from Claude, simply open Claude, open Connectors, and locate the web Snowflake connector.

To acquire your Oauth secret and token requries administrative permissions into your Snowflake org. You need to set up a Snowflake Oauth for MCP to work with Claude first.

  1. Acquire and enter your Snowflake server URL.
  2. Paste the OAuth Client ID
  3. Paste the OAuth Cllient Secrete

Known Issues- Nov 2025

As of Nov 2025, this native Claude integration is not fully working. There is a scope=claude that is not a supported scope in Snowflake. Presumably, this will get added at some point or fixed.

Install Snowflake MCP Server Locally

The following instructions are not

Test UVX with official Snowflake MCP server for self-hosted. To install and run your Snowflake MCP server locally, you will want to configure Python for MCP. These templates were built on a Windows 11 machine for testing and experimentation purposes. 

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

Claude Desktop Configuration Template for Self Hosted MCP

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