Skip to content
appsgit

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

Data as of from the GitHub API and the official MCP registry; description from the project's repository. Report an error

View on GitHub (opens in a new tab)

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.

NameRequiredDescription
SNOWFLAKE_ACCOUNTNoAccount identifier (e.g. xy12345.us-east-1)
SNOWFLAKE_HOSTNoSnowflake host URL
SNOWFLAKE_USERNoUsername for authentication
SNOWFLAKE_PASSWORDsecretNoPassword or programmatic access token
SNOWFLAKE_ROLENoRole to use for connection
SNOWFLAKE_WAREHOUSENoWarehouse to use for queries
SNOWFLAKE_PASSCODENoMFA passcode for authentication
SNOWFLAKE_PRIVATE_KEYsecretNoPrivate key for key pair authentication
SNOWFLAKE_PRIVATE_KEY_FILEsecretNoPath to private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWDsecretNoPassword for encrypted private key
SNOWFLAKE_MCP_HOSTNoHost address to bind the server to (default: 0.0.0.0)
SNOWFLAKE_MCP_PORTNoPort number for the server to listen on (default: 9000)
SNOWFLAKE_MCP_ENDPOINTNoEndpoint 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.

Similar MCP servers

More data & analytics MCP servers

All Data & analytics

FAQ

OSS Snowflake MCP Server FAQ

Still curious? Email info@appsgit.com.

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.