Snowflake MCP Server

1.4.1 verified Fri May 01 auth: no python

MCP (Model Context Protocol) server for Snowflake, enabling LLMs to interact with Snowflake databases. Current version 1.4.1, requires Python >=3.11. Active development.

pip install snowflake-labs-mcp

Common errors

error ModuleNotFoundError: No module named 'snowflake_labs_mcp' ↓

cause Package not installed or wrong Python environment.

fix

Ensure you run 'pip install snowflake-labs-mcp' in the correct environment.

error snowflake.connector.errors.DatabaseError: 250001 (08001): Failed to connect to DB: my_account.snowflakecomputing.com:443 ↓

cause Missing or incorrect environment variables for Snowflake account.

fix

Set SNOWFLAKE_ACCOUNT to your full account identifier (e.g., 'myorg-myaccount').

Warnings

breaking Version 1.0.0 changed the server class name from SnowflakeMCPServer to SnowflakeMCPServer (no change) but the package's top-level import path changed. Ensure you use 'from snowflake_labs_mcp import SnowflakeMCPServer'. ↓

fix Update import to 'from snowflake_labs_mcp import SnowflakeMCPServer'.

gotcha Authentication via environment variables is required; snowflake-labs-mcp does not support Snowflake's config file or browser-based SSO directly. ↓

fix Set SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE (or use SNOWFLAKE_PRIVATE_KEY for key pair auth).

gotcha The server runs indefinitely. Expect it to block the main thread; no built-in graceful shutdown handler. ↓

fix Wrap in asyncio or run in a separate thread if needed.

Imports

SnowflakeMCPServer
wrong
```
from snowflake_mcp import SnowflakeMCPServer
```
correct
```
from snowflake_labs_mcp import SnowflakeMCPServer
```
Wrong package name - correct import uses underscores matching the library slug.

Quickstart

Basic server setup. Set environment variables for authentication.

import os
from snowflake_labs_mcp import SnowflakeMCPServer

os.environ['SNOWFLAKE_ACCOUNT'] = 'my_account'
os.environ['SNOWFLAKE_USER'] = 'my_user'
os.environ['SNOWFLAKE_PASSWORD'] = 'my_password'
os.environ['SNOWFLAKE_WAREHOUSE'] = 'my_wh'

server = SnowflakeMCPServer()
server.run()