snowflake-mcp-server
❄️ snowflake-mcp-server
使用原生 Snowflake Data Cloud 与 Cortex AI 超级能力,为 AI 智能体强力赋能! ⚡
一个企业级 Model Context Protocol (MCP) 服务器,提供横跨 18 个领域模块的 127 个工具,支持零配置连接解析、安全的 SQL 执行、虚拟仓库管理、对象检查以及 Cortex AI 集成,可直接接入您最喜爱的 AI 助手。
🛡️ 企业免责声明与安全
[!IMPORTANT] 社区项目免责声明
snowflake-mcp-server是一个依据 Apache 2.0 许可证发布的独立开源项目,与 Snowflake Inc. 没有关联,也不受其赞助、背书或支持。"Snowflake" 与 "Cortex" 是 Snowflake Inc. 的商标。
[!WARNING] 安全护栏
只读安全模式: 设置
SNOWFLAKE_MCP_READONLY=1(或传入--readonly)以禁用所有 DDL/DML 变更能力。破坏性操作安全闸门: 删除数据库、架构或表需要显式传入
confirm=True。查询限制: 默认执行限制可防止上下文窗口溢出(
SNOWFLAKE_MAX_ROWS=1000、SNOWFLAKE_QUERY_TIMEOUT=120)。
Related MCP server: Snowflake MCP Server
🔌 连接与多种认证方式解析
snowflake-mcp-server 可自动解析所有企业级 Snowflake 配置中的凭据:
Snowflake CLI 继承(
~/.snowflake/connections.toml): 零配置连接。如果您已通过snow配置了连接,服务器会自动连接到您的默认或指定配置文件(-c <conn_name>)。编程访问令牌 (PAT) / OAuth: 在连接配置文件中设置
token,或设置SNOWFLAKE_TOKEN。RSA 密钥对 JWT 认证: 设置
SNOWFLAKE_PRIVATE_KEY_PATH(以及可选的SNOWFLAKE_PRIVATE_KEY_PASSPHRASE)。SSO / 浏览器认证: 设置
SNOWFLAKE_AUTHENTICATOR=externalbrowser。环境变量: 标准
SNOWFLAKE_ACCOUNT、SNOWFLAKE_USER、SNOWFLAKE_PASSWORD、SNOWFLAKE_WAREHOUSE、SNOWFLAKE_DATABASE、SNOWFLAKE_SCHEMA、SNOWFLAKE_ROLE。
📦 安装与快速开始
# Install via pip
pip install snowflake-mcp-server
# Run with a specific Snowflake CLI connection profile
snowflake-mcp -c my_connection
# Run in read-only mode
snowflake-mcp -c my_connection --readonly
# Run with Docker
docker build -t snowflake-mcp-server .
docker run -i --rm snowflake-mcp-server🛠️ 完整工具套件(127 个企业级工具)
领域套件 | 数量 | 关键工具 |
1. SQL 查询与事务 | 8 |
|
2. 数据库与克隆 | 7 |
|
3. 架构与克隆 | 6 |
|
4. 表、视图与分区 | 10 |
|
5. 虚拟仓库与扩缩容 | 8 |
|
6. Stage 与文件操作 | 6 |
|
7. 任务与 DAG 管道 | 7 |
|
8. Stream 与变更数据捕获 | 5 |
|
9. 动态表与 Iceberg 表 | 7 |
|
10. Snowpipe 与数据摄取 | 5 |
|
11. 警报与通知 | 6 |
|
12. 治理、RBAC 与用户 | 10 |
|
13. 网络与密码策略 | 6 |
|
14. SPCS 计算池与 Streamlit | 8 |
|
15. 对象标签与分类 | 4 |
|
16. 可编程性、UDF 与 Secret | 8 |
|
17. Cortex AI 与 NLP 扩展 | 8 |
|
18. 复合智能体工作流 | 8 |
|
📜 许可证
Apache 2.0。版权所有 (c) 2026 Christian Claudio。
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceEnables intelligent data analysis and querying of Snowflake databases through specialized AI agents. Features 20+ tools for data operations, lineage tracing, usage analysis, and performance optimization with multi-agent architecture.
- AlicenseAqualityNot gradedmaintenanceEnables AI assistants to securely connect to Snowflake data warehouses and execute SQL queries through natural language interactions. Supports multiple authentication methods and provides formatted query results with built-in security controls.12
- AlicenseNot gradedqualityDmaintenanceEnables interaction with Snowflake through Cortex AI services including search, analyst, and agents for querying structured and unstructured data, plus SQL execution and object management capabilities.296Apache 2.0
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to perform comprehensive Snowflake database operations including DDL, DML, and warehouse management. It allows users to query data, manage database objects, and configure permissions using natural language commands.MIT
Related MCP Connectors
SaaS intelligence for AI agents. 5 unified tools cover 1,000+ services with 91-96% token savings.
Build, validate, and deploy multi-agent AI solutions from any AI environment.
The agent-native cloud: database, functions, AI, storage, computers. 50 tools, one API key.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/christianclaudio/mcp-server-snowflake'
If you have feedback or need assistance with the MCP directory API, please join our Discord server