OSS Snowflake MCP Server

by snowflake-labsio.github.Snowflake-Labs/mcpv1.3.5

Snowflake: prompt Cortex Agents, query structured and unstructured data, manage objects, run SQL and query semantic views, with RBAC and CRUD controls.

298Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Slowing5mo ago

Install OSS Snowflake MCP server

claude mcp add snowflake-labs -e SNOWFLAKE_PASSWORD='<snowflake-password>' -e SNOWFLAKE_PRIVATE_KEY='<snowflake-private-key>' -- uvx snowflake-labs-mcp --service-config-file '<--service-config-file>' --authenticator snowflake --transport stdio --server-host 0.0.0.0 --port 9000 --endpoint /mcp

{
  "mcpServers": {
    "snowflake-labs": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<--service-config-file>",
        "--authenticator",
        "snowflake",
        "--transport",
        "stdio",
        "--server-host",
        "0.0.0.0",
        "--port",
        "9000",
        "--endpoint",
        "/mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY": "<snowflake-private-key>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "snowflake-labs": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<--service-config-file>",
        "--authenticator",
        "snowflake",
        "--transport",
        "stdio",
        "--server-host",
        "0.0.0.0",
        "--port",
        "9000",
        "--endpoint",
        "/mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY": "<snowflake-private-key>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "snowflake-labs": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<--service-config-file>",
        "--authenticator",
        "snowflake",
        "--transport",
        "stdio",
        "--server-host",
        "0.0.0.0",
        "--port",
        "9000",
        "--endpoint",
        "/mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY": "<snowflake-private-key>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "snowflake-labs": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<--service-config-file>",
        "--authenticator",
        "snowflake",
        "--transport",
        "stdio",
        "--server-host",
        "0.0.0.0",
        "--port",
        "9000",
        "--endpoint",
        "/mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<snowflake-password>",
        "SNOWFLAKE_PRIVATE_KEY": "<snowflake-private-key>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
SNOWFLAKE_ACCOUNT	—	—	Account identifier (e.g. xy12345.us-east-1)
SNOWFLAKE_HOST	—	—	Snowflake host URL
SNOWFLAKE_USER	—	—	Username for authentication
SNOWFLAKE_PASSWORD	—	yes	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	—	yes	Private key for key pair authentication
SNOWFLAKE_PRIVATE_KEY_FILE	—	—	Path to private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWD	—	—	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)

Freshness

Slowing — last maintenance signal 5mo ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-05-15 · 5mo ago · GitHub
Latest release
2026-05-15 · 5mo ago · GitHub · v.1.4.2
Package published
no data · npm/PyPI
Registry entry updated
2025-10-28 · 12mo ago · official registry · v1.3.5

FAQ

›How do I install the OSS Snowflake MCP server in Claude Code?

Run: claude mcp add snowflake-labs -e SNOWFLAKE_PASSWORD='<snowflake-password>' -e SNOWFLAKE_PRIVATE_KEY='<snowflake-private-key>' -- uvx snowflake-labs-mcp --service-config-file '<--service-config-file>' --authenticator snowflake --transport stdio --server-host 0.0.0.0 --port 9000 --endpoint /mcp. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does OSS Snowflake require an API key?

Yes. It expects SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY, of which 2 are secrets.

›Can I use OSS Snowflake as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is OSS Snowflake in the official MCP registry?

Yes, as io.github.Snowflake-Labs/mcp.