OSS Snowflake MCP Server
local MCP serverInstallation
Terminal
claude mcp add snowflake-labs-github-io -e SNOWFLAKE_ACCOUNT=... -e SNOWFLAKE_HOST=... -e SNOWFLAKE_USER=... -e SNOWFLAKE_PASSWORD=... -e SNOWFLAKE_ROLE=... -e SNOWFLAKE_WAREHOUSE=... -e SNOWFLAKE_PASSCODE=... -e SNOWFLAKE_PRIVATE_KEY=... -e SNOWFLAKE_PRIVATE_KEY_FILE=... -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD=... -e SNOWFLAKE_MCP_HOST=... -e SNOWFLAKE_MCP_PORT=... -e SNOWFLAKE_MCP_ENDPOINT=... -- uvx snowflake-labs-mcp
Run in your project folder. Add --scope user to use it everywhere.
Claude Desktop, Cursor & other clients
Add to claude_desktop_config.json or .cursor/mcp.json.
{
"mcpServers": {
"snowflake-labs-github-io": {
"command": "uvx",
"args": [
"snowflake-labs-mcp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "...",
"SNOWFLAKE_HOST": "...",
"SNOWFLAKE_USER": "...",
"SNOWFLAKE_PASSWORD": "...",
"SNOWFLAKE_ROLE": "...",
"SNOWFLAKE_WAREHOUSE": "...",
"SNOWFLAKE_PASSCODE": "...",
"SNOWFLAKE_PRIVATE_KEY": "...",
"SNOWFLAKE_PRIVATE_KEY_FILE": "...",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "...",
"SNOWFLAKE_MCP_HOST": "...",
"SNOWFLAKE_MCP_PORT": "...",
"SNOWFLAKE_MCP_ENDPOINT": "..."
}
}
}
}Fill in the environment variables with your own credentials.
Summary
MCP Server for Snowflake from Snowflake Labs
Questions
OSS Snowflake MCP Server is a local MCP server distributed as the pypi package snowflake-labs-mcp.
Run: claude mcp add snowflake-labs-github-io -e SNOWFLAKE_ACCOUNT=... -e SNOWFLAKE_HOST=... -e SNOWFLAKE_USER=... -e SNOWFLAKE_PASSWORD=... -e SNOWFLAKE_ROLE=... -e SNOWFLAKE_WAREHOUSE=... -e SNOWFLAKE_PASSCODE=... -e SNOWFLAKE_PRIVATE_KEY=... -e SNOWFLAKE_PRIVATE_KEY_FILE=... -e SNOWFLAKE_PRIVATE_KEY_FILE_PWD=... -e SNOWFLAKE_MCP_HOST=... -e SNOWFLAKE_MCP_PORT=... -e SNOWFLAKE_MCP_ENDPOINT=... -- uvx snowflake-labs-mcp
Run: codex mcp add snowflake-labs-github-io --env SNOWFLAKE_ACCOUNT=... --env SNOWFLAKE_HOST=... --env SNOWFLAKE_USER=... --env SNOWFLAKE_PASSWORD=... --env SNOWFLAKE_ROLE=... --env SNOWFLAKE_WAREHOUSE=... --env SNOWFLAKE_PASSCODE=... --env SNOWFLAKE_PRIVATE_KEY=... --env SNOWFLAKE_PRIVATE_KEY_FILE=... --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=... --env SNOWFLAKE_MCP_HOST=... --env SNOWFLAKE_MCP_PORT=... --env SNOWFLAKE_MCP_ENDPOINT=... -- uvx snowflake-labs-mcp
Similar MCP servers
NameStars
- DBHubio.github.bytebase/dbhub3,574
- mcp-ssh-managerio.github.bvisible/mcp-ssh-manager493
- google-analytics-mcpio.github.surendranb/google-analytics-mcp242
- Dynatrace-mcpio.github.dynatrace-oss/Dynatrace-mcp138
- Unraid MCPai.dinglebear/unraid-mcp131
- Unraid MCPtv.tootie/unraid-mcp131
- sshcom.pulsemcp/ssh80
- raxolio.github.DROOdotFOO/raxol79