OSS Snowflake MCP Server

OSS Snowflake MCP Server is an MCP server that adds data and analytics tools to AI assistants such as Claude Desktop, Claude Code and Cursor. MCP Server for Snowflake from Snowflake Labs. It has 298 GitHub stars, is released under the Apache-2.0 license and runs locally with uvx snowflake-labs-mcp.

github.com/Snowflake-Labs/mcp (opens in a new tab)

Official
Needs API key
Data & analytics
Apache-2.0
Maintained

View on GitHub

Install OSS Snowflake MCP Server

Generated from the server's MCP registry entry. Replace your-value with your own values.

Claude Desktop

claude_desktop_config.json

{
  "mcpServers": {
    "oss-snowflake-mcp-server": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "your-value",
        "SNOWFLAKE_PRIVATE_KEY": "your-value",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "your-value",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "your-value"
      }
    }
  }
}

Settings > Developer > Edit Config. macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\. Restart Claude Desktop afterwards.

Claude Code

claude mcp add --env SNOWFLAKE_PASSWORD=your-value --env SNOWFLAKE_PRIVATE_KEY=your-value --env SNOWFLAKE_PRIVATE_KEY_FILE=your-value --env SNOWFLAKE_PRIVATE_KEY_FILE_PWD=your-value --transport stdio oss-snowflake-mcp-server -- uvx snowflake-labs-mcp

Cursor

.cursor/mcp.json

{
  "mcpServers": {
    "oss-snowflake-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "your-value",
        "SNOWFLAKE_PRIVATE_KEY": "your-value",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "your-value",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "your-value"
      }
    }
  }
}

Project file; use ~/.cursor/mcp.json to enable it in every project.

VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "snowflake_password",
      "description": "SNOWFLAKE_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake_private_key",
      "description": "SNOWFLAKE_PRIVATE_KEY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake_private_key_file",
      "description": "SNOWFLAKE_PRIVATE_KEY_FILE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "snowflake_private_key_file_pwd",
      "description": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD",
      "password": true
    }
  ],
  "servers": {
    "oss-snowflake-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "${input:snowflake_password}",
        "SNOWFLAKE_PRIVATE_KEY": "${input:snowflake_private_key}",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "${input:snowflake_private_key_file}",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${input:snowflake_private_key_file_pwd}"
      }
    }
  }
}

Config formats checked against the official docs on Oct 7, 2026: modelcontextprotocol.io (opens in a new tab), code.claude.com (opens in a new tab), cursor.com (opens in a new tab), code.visualstudio.com (opens in a new tab).

Environment variables

Variables the server reads at startup.

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

About OSS Snowflake MCP Server

This community MCP server previously provided tooling for Snowflake Cortex AI, object management, and SQL orchestration. It is no longer supported. For all new and existing use cases, please use the official Snowflake MCP Server instead.

Key facts

GitHub stars	298
License	Apache-2.0
Language	Python
Transport	stdio (local)
Packages	PyPI: `snowflake-labs-mcp`
Auth	API key or token (SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY, SNOWFLAKE_PRIVATE_KEY_FILE, SNOWFLAKE_PRIVATE_KEY_FILE_PWD)
Works with	Claude Desktop, Claude Code, Cursor and VS Code
Latest release	v.1.4.2 (May 15, 2026)
Last commit	May 15, 2026
MCP registry name	`io.github.Snowflake-Labs/mcp`

Repository on GitHub Official MCP registry entry This page as Markdown

Similar MCP servers

More data & analytics MCP servers

All Data & analytics

FAQ

OSS Snowflake MCP Server FAQ

Still curious? Email info@appsgit.com.

What is OSS Snowflake MCP Server?

How do I install the OSS Snowflake MCP Server MCP server?

Add the command uvx snowflake-labs-mcp to your MCP client: put it in claude_desktop_config.json for Claude Desktop, run claude mcp add for Claude Code, or add it to .cursor/mcp.json (Cursor) or .vscode/mcp.json (VS Code). The snippets on this page are ready to paste.

Is OSS Snowflake MCP Server free?

The server is open source under the Apache-2.0 license, so running it is free. It needs credentials (SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY, SNOWFLAKE_PRIVATE_KEY_FILE and SNOWFLAKE_PRIVATE_KEY_FILE_PWD) for the service it connects to, which may require a paid account.

Is OSS Snowflake MCP Server actively maintained?

The most recent commit was on May 15, 2026. The latest release is v.1.4.2, published May 15, 2026. appsgit only lists MCP servers with a commit in the last six months and re-checks every server daily.