OSS Snowflake MCP Server

● Archived

io.github.Snowflake-Labs/mcp

MCP Server for Snowflake from Snowflake Labs

Connect this server

One click to install, or copy the config below. Suits: Claude Desktop · Cursor.

Add to Cursor Add to VS CodeClaude Desktop / Claude Code: paste the config below.

Or add it manually — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor):

{
  "mcpServers": {
    "mcp": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp",
        "--service-config-file",
        "<service-config-file>",
        "--account",
        "--host",
        "--user",
        "--password",
        "--role",
        "--warehouse",
        "--passcode-in-password",
        "--passcode",
        "--private-key",
        "--private-key-file",
        "--private-key-file-pwd",
        "--authenticator",
        "snowflake",
        "--connection-name",
        "--transport",
        "stdio",
        "--server-host",
        "0.0.0.0",
        "--port",
        "9000",
        "--endpoint",
        "/mcp"
      ],
      "env": {
        "SNOWFLAKE_PASSWORD": "<your SNOWFLAKE_PASSWORD>",
        "SNOWFLAKE_PRIVATE_KEY": "<your SNOWFLAKE_PRIVATE_KEY>"
      }
    }
  }
}
One line, from the terminal
Claude Code
claude mcp add --env SNOWFLAKE_PASSWORD='<your SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY='<your SNOWFLAKE_PRIVATE_KEY>' --transport stdio mcp -- uvx snowflake-labs-mcp --service-config-file '<service-config-file>' --account --host --user --password --role --warehouse --passcode-in-password --passcode --private-key --private-key-file --private-key-file-pwd --authenticator snowflake --connection-name --transport stdio --server-host 0.0.0.0 --port 9000 --endpoint /mcp
OpenAI Codex CLI
codex mcp add mcp --env SNOWFLAKE_PASSWORD='<your SNOWFLAKE_PASSWORD>' --env SNOWFLAKE_PRIVATE_KEY='<your SNOWFLAKE_PRIVATE_KEY>' -- uvx snowflake-labs-mcp --service-config-file '<service-config-file>' --account --host --user --password --role --warehouse --passcode-in-password --passcode --private-key --private-key-file --private-key-file-pwd --authenticator snowflake --connection-name --transport stdio --server-host 0.0.0.0 --port 9000 --endpoint /mcp
VS Code
code --add-mcp '{"name":"mcp","type":"stdio","command":"uvx","args":["snowflake-labs-mcp","--service-config-file","<service-config-file>","--account","--host","--user","--password","--role","--warehouse","--passcode-in-password","--passcode","--private-key","--private-key-file","--private-key-file-pwd","--authenticator","snowflake","--connection-name","--transport","stdio","--server-host","0.0.0.0","--port","9000","--endpoint","/mcp"],"env":{"SNOWFLAKE_PASSWORD":"<your SNOWFLAKE_PASSWORD>","SNOWFLAKE_PRIVATE_KEY":"<your SNOWFLAKE_PRIVATE_KEY>"}}'

Syntax from each client's docs (Claude Code: claude mcp add; Codex: codex mcp add; VS Code: code --add-mcp). Placeholders in angle brackets are values you fill in.

Environment variables
  • SNOWFLAKE_PASSWORDsecretPassword or programmatic access token
  • SNOWFLAKE_PRIVATE_KEYsecretPrivate key for key pair authentication

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Databases
Version
1.3.5
Registry
active
Published
10/28/2025

On GitHub

read Nov 17, 2026

This repository is archived on GitHub: it is read-only and no longer maintained.

Stars
304
Forks
110
Last push
May 15, 2026
License
Apache-2.0

Python

From the README

[DEPRECATED] Snowflake Cortex AI Model Context Protocol (MCP) Server [!CAUTION] This project is deprecated and no longer maintained. Please migrate to the official Snowflake MCP Server. The official server is actively developed, fully supported by Snowflake, and continues to add new features. 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. Legacy documentation (for reference only) The MCP server supported the below capabilities: • Cortex Search: Query unstructured data in Snowflake as commonly used in Retrieval Augmented Generation (RAG) applications. • Cortex Analyst: Query structured data in Snowflake via rich semantic modeling. • Cortex Agent: Agentic orchestrator across structured and unstructured data retrieval • Object Management: Perform basic operations against Snowflake's most common objects such as creation, dropping, updating, and more. • SQL Execution: Run LLM-generated SQL managed by user-configured permissions. • Semantic View Querying: Discover and query Snowflake Semantic Views Getting Started Service Configuration A simple configuration file is used to drive all tooling. An example can be seen at services/configuration.yaml and a template is below.…

Read the full README on GitHub →

Alternatives to OSS Snowflake MCP Server

Best Databases servers →

The most-starred Databases servers in the index, with their live-check result.

ServerStarsLast pushLive check
Dbx30,677Nov 2026Local / not checked
MCP Toolbox for Databases16,897Nov 2026Local / not checked
MCP Toolbox for Databases16,897Nov 2026Local / not checked
Finance Database9,627Nov 2026Working
DBHub3,868Nov 2026Local / not checked

OSS Snowflake MCP Server: questions people ask

Is OSS Snowflake MCP Server a remote or a local MCP server?
According to its entry in the official MCP registry, OSS Snowflake MCP Server ships as a local package (PyPI) that your client starts on your machine.
Does OSS Snowflake MCP Server need an API key?
Its registry entry declares 2 required environment variables: SNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY. The config on this page shows where each goes.
Is OSS Snowflake MCP Server still maintained?
Archived: the repository's Archived on GitHub — read-only and no longer maintained., and it is archived on GitHub (read-only). Last push May 15, 2026, 304 GitHub stars, Apache-2.0 licence. Read from GitHub on Nov 17, 2026.
How do I add OSS Snowflake MCP Server to Claude, Cursor or VS Code?
Copy the config in "Connect this server" into your client's MCP config file (claude_desktop_config.json, ~/.cursor/mcp.json or .vscode/mcp.json), or use the one-click Add to Cursor / Add to VS Code buttons and the one-line commands for Claude Code and Codex; then restart the client.
Browse all Databases →

Add the badge to your site

Show visitors that OSS Snowflake MCP Server is listed here — it’s also the link we check for a free listing.

OSS Snowflake MCP Server — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-snowflake-labs-mcp?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="OSS Snowflake MCP Server — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![OSS Snowflake MCP Server — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-snowflake-labs-mcp?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.