Skip to main content
Glama

❄️ snowflake-mcp-server

CI License: Apache-2.0 Python MCP Standard

使用原生 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=1000SNOWFLAKE_QUERY_TIMEOUT=120)。


Related MCP server: Snowflake MCP Server

🔌 连接与多种认证方式解析

snowflake-mcp-server 可自动解析所有企业级 Snowflake 配置中的凭据:

  1. Snowflake CLI 继承(~/.snowflake/connections.toml): 零配置连接。如果您已通过 snow 配置了连接,服务器会自动连接到您的默认或指定配置文件(-c <conn_name>)。

  2. 编程访问令牌 (PAT) / OAuth: 在连接配置文件中设置 token,或设置 SNOWFLAKE_TOKEN

  3. RSA 密钥对 JWT 认证: 设置 SNOWFLAKE_PRIVATE_KEY_PATH(以及可选的 SNOWFLAKE_PRIVATE_KEY_PASSPHRASE)。

  4. SSO / 浏览器认证: 设置 SNOWFLAKE_AUTHENTICATOR=externalbrowser

  5. 环境变量: 标准 SNOWFLAKE_ACCOUNTSNOWFLAKE_USERSNOWFLAKE_PASSWORDSNOWFLAKE_WAREHOUSESNOWFLAKE_DATABASESNOWFLAKE_SCHEMASNOWFLAKE_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

snowflake_query, snowflake_execute_dml, snowflake_cancel_query, snowflake_get_query_history, snowflake_get_query_plan, snowflake_get_query_operator_stats, snowflake_begin_transaction, snowflake_commit_transaction

2. 数据库与克隆

7

snowflake_list_databases, snowflake_describe_database, snowflake_create_database, snowflake_drop_database, snowflake_clone_database, snowflake_undrop_database, snowflake_get_database_ddl

3. 架构与克隆

6

snowflake_list_schemas, snowflake_describe_schema, snowflake_create_schema, snowflake_drop_schema, snowflake_clone_schema, snowflake_undrop_schema

4. 表、视图与分区

10

snowflake_list_tables, snowflake_list_views, snowflake_describe_table, snowflake_get_table_ddl, snowflake_sample_table, snowflake_create_table, snowflake_drop_table, snowflake_undrop_table, snowflake_truncate_table, snowflake_clone_table

5. 虚拟仓库与扩缩容

8

snowflake_list_warehouses, snowflake_describe_warehouse, snowflake_create_warehouse, snowflake_drop_warehouse, snowflake_resume_warehouse, snowflake_suspend_warehouse, snowflake_resize_warehouse, snowflake_get_warehouse_load_history

6. Stage 与文件操作

6

snowflake_list_stages, snowflake_describe_stage, snowflake_create_stage, snowflake_drop_stage, snowflake_list_stage_files, snowflake_remove_stage_file

7. 任务与 DAG 管道

7

snowflake_list_tasks, snowflake_describe_task, snowflake_create_task, snowflake_drop_task, snowflake_resume_task, snowflake_suspend_task, snowflake_execute_task

8. Stream 与变更数据捕获

5

snowflake_list_streams, snowflake_describe_stream, snowflake_create_stream, snowflake_drop_stream, snowflake_read_stream_changes

9. 动态表与 Iceberg 表

7

snowflake_list_dynamic_tables, snowflake_describe_dynamic_table, snowflake_refresh_dynamic_table, snowflake_resume_dynamic_table, snowflake_suspend_dynamic_table, snowflake_list_iceberg_tables, snowflake_describe_iceberg_table

10. Snowpipe 与数据摄取

5

snowflake_list_pipes, snowflake_describe_pipe, snowflake_create_pipe, snowflake_drop_pipe, snowflake_get_pipe_status

11. 警报与通知

6

snowflake_list_alerts, snowflake_describe_alert, snowflake_create_alert, snowflake_drop_alert, snowflake_resume_alert, snowflake_suspend_alert

12. 治理、RBAC 与用户

10

snowflake_get_current_context, snowflake_list_roles, snowflake_describe_role, snowflake_create_role, snowflake_drop_role, snowflake_list_users, snowflake_describe_user, snowflake_create_user, snowflake_list_grants_to_role, snowflake_list_grants_to_user

13. 网络与密码策略

6

snowflake_list_network_policies, snowflake_describe_network_policy, snowflake_list_network_rules, snowflake_describe_network_rule, snowflake_list_password_policies, snowflake_describe_password_policy

14. SPCS 计算池与 Streamlit

8

snowflake_list_streamlits, snowflake_describe_streamlit, snowflake_list_compute_pools, snowflake_describe_compute_pool, snowflake_resume_compute_pool, snowflake_suspend_compute_pool, snowflake_list_services, snowflake_list_image_repositories

15. 对象标签与分类

4

snowflake_list_tags, snowflake_describe_tag, snowflake_get_object_tag_references, snowflake_set_object_tag

16. 可编程性、UDF 与 Secret

8

snowflake_list_procedures, snowflake_describe_procedure, snowflake_list_functions, snowflake_describe_function, snowflake_list_secrets, snowflake_describe_secret, snowflake_list_sequences, snowflake_list_integrations

17. Cortex AI 与 NLP 扩展

8

snowflake_cortex_complete, snowflake_cortex_summarize, snowflake_cortex_sentiment, snowflake_cortex_extract_answer, snowflake_cortex_translate, snowflake_cortex_search, snowflake_cortex_embed_text_768, snowflake_cortex_analyst_query

18. 复合智能体工作流

8

snowflake_health_check, snowflake_inspect_table_with_sample, snowflake_profile_table, snowflake_warehouse_scale_and_execute, snowflake_clone_table_recipe, snowflake_export_query_to_stage, snowflake_account_usage_summary, snowflake_discover_schema_lineage


📜 许可证

Apache 2.0。版权所有 (c) 2026 Christian Claudio。

A
license - permissive license
C
quality
B
maintenance

Maintenance

Maintainers
Response time
Release cycle
1Releases (12mo)
Commit activity

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

  • F
    license
    Not graded
    quality
    D
    maintenance
    Enables 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.
  • A
    license
    A
    quality
    Not graded
    maintenance
    Enables 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.
    1
    2
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables 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.
    296
    Apache 2.0
  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables 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

View all related MCP servers

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.

View all MCP Connectors

Latest Blog Posts

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