OSS Snowflake MCP Server
io.github.Snowflake-Labs/mcp·v1.3.5·299 starsMCP Server for Snowflake from Snowflake Labs
299 stars12k downloads/wk
Reviews
Write oneNobody has reviewed OSS Snowflake MCP Server yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
OSS Snowflake MCP Server tools (16, 5 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
cortex_agentcortex_analystcortex_searchcreate_objectwrite actioncreate_or_alter_objectwrite actiondescribe_objectdescribe_semantic_viewDescribe a semantic view.
drop_objectwrite actionget_semantic_view_ddlGet the DDL for a semantic view.
list_objectslist_semantic_viewsList all semantic views in the account, database, or schema.
query_semantic_viewrun_snowflake_querywrite actionshow_semantic_dimensionsShow all semantic dimensions in the account, database, or schema.
show_semantic_metricsShow all semantic metrics in the account, database, or schema.
write_semantic_view_query_toolwrite action
Public scan report
scanner v0.1.10 · 2026-10-01 · same rubric, same numbers if you re-run it
- Code scan21 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitystatic API keys via environment variables6/15
- Maintenancelast push 139 days ago8/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year9/10
How OSS Snowflake MCP Server compares
Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 74/100
- higher than 33% of 802 Databases servers
- Tools
- 16
- the typical Databases server has 8
- Tools that change things
- 31%
- typical: 10%. Fewer write tools means less an agent can break
- GitHub stars
- 299
- more than 95% of 601 Databases servers
- Downloads a week
- 11,509
- more than 96% of 324 Databases servers with a package
What its tools let an agent do: 11 read · 3 create · 1 delete · 1 run or deploy
Install OSS Snowflake MCP Server in Claude Code, Cursor or VS Code
claude mcp add mcp -- uvx snowflake-labs-mcp
What the publisher says
From the OSS Snowflake MCP Server repository's README, as published. We do not edit it. Read it on GitHub
[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. The path to this configuration file will be passed to the server and the contents used to create MCP server tools at startup.
Cortex Services
Many Cortex Agent, Search, and Analyst services can be added. Ideal descriptions are both highly descriptive and mutually exclusive. Only the explicitly listed Cortex services will be available as tools in the MCP client.
Other Services
Other services include tooling for object management, query execution, and semantic view usage. These groups of tools can be enabled by setting them to True in the other_services section of the configuration file.
SQL Statement Permissions
The sqlstatementpermissions section ensures that only approved statements are executed across any tools with access to change Snowflake objects. The list contains SQL expression types. Those marked with True are permitted while those marked with False are not permitted. Please see SQL Execution for examples of each expression type.
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
OSS Snowflake MCP Server: common questions
- Is OSS Snowflake MCP Server safe?
- Mostly: it is graded B (74/100). Read the OSS Snowflake MCP Server safety report
- How do I install OSS Snowflake MCP Server?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does OSS Snowflake MCP Server need an API key?
- Yes. The registry entry asks for
SNOWFLAKE_PASSWORD,SNOWFLAKE_PRIVATE_KEY. - Is OSS Snowflake MCP Server maintained?
- The last commit was 171 days ago (2026-05-15). The latest release is v1.3.5.
- What can I use instead of OSS Snowflake MCP Server?
- Servers from other publishers that do the same job: Faucet MCP server.
- How does OSS Snowflake MCP Server compare with other Databases MCP servers?
- safety score 74/100 (higher than 33% of 802 Databases servers); tools 16 (the typical Databases server has 8); tools that change things 31% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to OSS Snowflake MCP Server
Same job from other publishers: the closest match first, then the best rated.
FaucetSQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.not reviewedEstablishedA