# OSS Snowflake MCP Server (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.

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

| Fact | Value |
|---|---|
| Repository | https://github.com/Snowflake-Labs/mcp |
| GitHub stars | 298 |
| License | Apache-2.0 |
| Language | Python |
| Transport | stdio |
| Packages | pypi: snowflake-labs-mcp |
| Remote URL | none |
| Needs API key | yes |
| Official | yes |
| Works with | Claude Desktop, Claude Code, Cursor, VS Code |
| Category | Data & analytics |
| Latest release | v.1.4.2 (May 15, 2026) |
| Last commit | May 15, 2026 |
| MCP registry name | io.github.Snowflake-Labs/mcp |

## Install

### Claude Desktop (claude_desktop_config.json)

```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

```sh
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)

```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)

```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 2026-10-07.

## Environment variables

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

## Similar MCP servers

- [Ida Pro MCP](https://appsgit.com/mcp-servers/ida-pro-mcp): AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP. (12,497 stars, MIT)
- [Ask Jev](https://appsgit.com/mcp-servers/ask-jev): Evaluate state with typed choice, score, and probability questions. (5,174 stars, MIT, needs API key)
- [Jitsu](https://appsgit.com/mcp-servers/jitsu): Manage Jitsu data pipelines: destinations, streams, connections, functions, live events. (5,101 stars, MIT, official)
- [Google Ads + Meta Ads + SEO/GEO MCP](https://appsgit.com/mcp-servers/google-ads-meta-ads-seo-geo-mcp): Google Ads, Meta Ads, SEO, GEO & GA4 MCP by Ryze AI - audits, reports, keywords, Search Console. (4,107 stars, MIT)
- [Blitz](https://appsgit.com/mcp-servers/blitz): Give AI agents full control over iOS/macOS development via a native macOS app with 30+ MCP tools. (1,754 stars, Apache-2.0)
- [Chunkhound](https://appsgit.com/mcp-servers/chunkhound): Your entire engineering context, deeply understood. (1,445 stars, MIT, official)

---

Canonical page: https://appsgit.com/mcp-servers/oss-snowflake-mcp-server
Source: appsgit (https://appsgit.com), the app store for github. Data from the GitHub API, refreshed nightly.
Machine access: JSON API https://appsgit.com/api/v1/apps (OpenAPI: https://appsgit.com/openapi.json), MCP server https://mcp.appsgit.com/mcp, full index https://appsgit.com/llms-full.txt.