OSS Snowflake MCP Server
● Archivedio.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.
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>"
}
}
}
}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 /mcpcodex 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 /mcpcode --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.
- 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, 2026This 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.
| Server | Stars | Last push | Live check |
|---|---|---|---|
| Dbx | 30,677 | Nov 2026 | Local / not checked |
| MCP Toolbox for Databases | 16,897 | Nov 2026 | Local / not checked |
| MCP Toolbox for Databases | 16,897 | Nov 2026 | Local / not checked |
| Finance Database | 9,627 | Nov 2026 | Working |
| DBHub | 3,868 | Nov 2026 | Local / 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.
More Databases servers
Browse all Databases →Bigquery MCP
SnowLeopard-AI
A SnowLeopardAI-managed MCP server that provides access to Google BigQuery data.
DBeast PostgreSQL MCP
snss10
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
Agent Experience Network Live Preflight
solargptnz-dev
Check public MCP reachability, protocol handshake, auth and tool schemas before connecting.
MCP Database Server
Souhar-dya
MCP server for SQLite, PostgreSQL, and MySQL with natural language to SQL and direct SQL tooling.
ParityDiff
Paritydiff-Parity-Diff
Inspect API contract changes, review private evidence, and request validated migration drafts.
Postgres MCP
sparta2025
PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
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.
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
[](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.