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=1000、SNOWFLAKE_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_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

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。

Available Tools

140 tools
alerts_create_alertAlerts Create AlertB

Create an alert with schedule, condition SQL, and action SQL. Destructive actions require confirm=True.

Inputs: schedule (required), action_sql (required), alert_name (required), condition_sql (required), +5 more. Returns: object

alerts_describe_alertAlerts Describe AlertB
Read-onlyIdempotent

Describe alert condition SQL, action SQL, schedule, and warehouse.

Inputs: alert_name (required), database, schema_name. Returns: object

alerts_drop_alertAlerts Drop AlertA
Destructive

Drop an alert in Snowflake. Requires confirmation.

Inputs: alert_name (required), confirm, database, schema_name. Returns: object

alerts_list_alertsAlerts List AlertsB
Read-onlyIdempotent

List configured alerts with condition queries, schedules, and state. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

alerts_resume_alertAlerts Resume AlertC
Idempotent

Resume a suspended alert.

Inputs: alert_name (required), database, schema_name. Returns: object

alerts_suspend_alertAlerts Suspend AlertB
Idempotent

Suspend an active alert.

Inputs: alert_name (required), database, schema_name. Returns: object

compute_services_describe_compute_poolCompute Services Describe Compute PoolB
Read-onlyIdempotent

Describe compute pool instance family, min/max nodes, active nodes, and state.

Inputs: pool_name (required). Returns: object

compute_services_describe_streamlitCompute Services Describe StreamlitA
Read-onlyIdempotent

Describe Streamlit application root location, stage, and query warehouse.

Inputs: streamlit_name (required), database, schema_name. Returns: object

compute_services_list_compute_poolsCompute Services List Compute PoolsB
Read-onlyIdempotent

List Snowpark Container Services (SPCS) compute pools. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

compute_services_list_image_repositoriesCompute Services List Image RepositoriesB
Read-onlyIdempotent

List OCI image repositories in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

compute_services_list_servicesCompute Services List ServicesB
Read-onlyIdempotent

List container services running on SPCS compute pools. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

compute_services_list_streamlitsCompute Services List StreamlitsB
Read-onlyIdempotent

List Streamlit applications hosted in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

compute_services_resume_compute_poolCompute Services Resume Compute PoolA
Idempotent

Resume an idle or suspended SPCS compute pool.

Inputs: pool_name (required). Returns: object

compute_services_suspend_compute_poolCompute Services Suspend Compute PoolA
Idempotent

Suspend an active SPCS compute pool to stop node provisioning costs.

Inputs: pool_name (required). Returns: object

cortex_analyst_queryCortex Analyst QueryB
Read-onlyIdempotent

Answer an analytical question via AI_COMPLETE. Optionally prefixes the prompt with semantic_model_path. Does not call Cortex Analyst REST (POST /api/v2/cortex/analyst/message).

Inputs: question (required), semantic_model_path. Returns: object

cortex_completeCortex CompleteA
Read-onlyIdempotent

Run LLM completion via Snowflake AI_COMPLETE (e.g., 'llama3.3-70b', 'llama3.1-8b'). Optional temperature (0 to 1) and max_tokens are sent as model_parameters only when set; with neither set the call stays AI_COMPLETE(model, prompt) and still returns a string.

Inputs: prompt (required), model, max_tokens, temperature. Returns: object

cortex_embed_text_768Cortex Embed Text 768A
Read-onlyIdempotent

Generate text embeddings via Snowflake AI_EMBED. Output dimension is set by the model (default snowflake-arctic-embed-m is 768); replaces legacy EMBED_TEXT_768.

Inputs: text (required), model. Returns: object

cortex_extract_answerCortex Extract AnswerB
Read-onlyIdempotent

Extract answers from text via Snowflake AI_EXTRACT. Returns the AI_EXTRACT JSON object (response/error), not a legacy plain-string answer.

Inputs: question (required), source_text (required). Returns: object

cortex_sentimentCortex SentimentA
Read-onlyIdempotent

Analyze sentiment via Snowflake AI_SENTIMENT. Returns an object with a categories array (overall plus optional aspects), not a legacy -1.0..1.0 float score.

Inputs: text (required). Returns: object

cortex_summarizeCortex SummarizeB
Read-onlyIdempotent

Summarize text via Snowflake AI_SUMMARIZE (drop-in for legacy CORTEX.SUMMARIZE).

Inputs: text (required). Returns: object

cortex_translateCortex TranslateB
Read-onlyIdempotent

Translate text via Snowflake AI_TRANSLATE (drop-in for legacy CORTEX.TRANSLATE).

Inputs: text (required), source_language (required), target_language (required). Returns: object

databases_clone_databaseDatabases Clone DatabaseB

Create a zero-copy clone of a database in Snowflake.

Inputs: source_database (required), target_database (required). Returns: object

databases_create_databaseDatabases Create DatabaseC

Create a new database in Snowflake.

Inputs: name (required), comment, if_not_exists, data_retention_time_in_days. Returns: object

databases_describe_databaseDatabases Describe DatabaseB
Read-onlyIdempotent

Describe properties, owner, retention time, and comment of a database.

Inputs: database_name (required). Returns: object

databases_drop_databaseDatabases Drop DatabaseA
Destructive

Drop a database in Snowflake. Requires confirmation flag.

Inputs: name (required), confirm. Returns: object

databases_get_database_ddlDatabases Get Database DdlB
Read-onlyIdempotent

Retrieve the exact CREATE DATABASE DDL definition.

Inputs: database_name (required). Returns: object

databases_list_databasesDatabases List DatabasesC
Read-onlyIdempotent

List all available databases accessible to the current role. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

databases_undrop_databaseDatabases Undrop DatabaseA

Restore a recently dropped database using Time Travel.

Inputs: name (required). Returns: object

dynamic_tables_describe_dynamic_tableDynamic Tables Describe Dynamic TableA
Read-onlyIdempotent

Describe dynamic table definition, target lag, warehouse, and query text.

Inputs: table_name (required), database, schema_name. Returns: object

dynamic_tables_describe_iceberg_tableDynamic Tables Describe Iceberg TableB
Read-onlyIdempotent

Describe schema, catalog integration, and external volume of an Iceberg table.

Inputs: table_name (required), database, schema_name. Returns: object

dynamic_tables_list_catalog_integrationsDynamic Tables List Catalog IntegrationsA
Read-onlyIdempotent

List catalog integrations (Polaris, AWS Glue, Object Storage) configured in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

dynamic_tables_list_dynamic_tablesDynamic Tables List Dynamic TablesC
Read-onlyIdempotent

List dynamic tables with lag targets, refresh mode, and last refresh status. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

dynamic_tables_list_external_volumesDynamic Tables List External VolumesB
Read-onlyIdempotent

List external cloud storage volumes configured for Apache Iceberg tables. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

dynamic_tables_list_iceberg_tablesDynamic Tables List Iceberg TablesB
Read-onlyIdempotent

List Apache Iceberg tables in the account, database, or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

dynamic_tables_refresh_dynamic_tableDynamic Tables Refresh Dynamic TableB
Idempotent

Trigger an immediate manual refresh of a dynamic table.

Inputs: table_name (required), database, schema_name. Returns: object

dynamic_tables_resume_dynamic_tableDynamic Tables Resume Dynamic TableC
Idempotent

Resume scheduling and lag monitoring for a dynamic table.

Inputs: table_name (required), database, schema_name. Returns: object

dynamic_tables_suspend_dynamic_tableDynamic Tables Suspend Dynamic TableB
Idempotent

Suspend automated refresh and lag evaluation for a dynamic table.

Inputs: table_name (required), database, schema_name. Returns: object

governance_create_roleGovernance Create RoleC

Create a new role in Snowflake.

Inputs: role_name (required), comment, if_not_exists. Returns: object

governance_create_userGovernance Create UserC

Create a new Snowflake user with default role and warehouse.

Inputs: user_name (required), comment, password, default_role, +2 more. Returns: object

governance_describe_roleGovernance Describe RoleA
Read-onlyIdempotent

Describe role properties and assigned grants. A name in double quotes, such as a list row's quoted_name, must match exactly.

Inputs: role_name (required). Returns: object

governance_describe_userGovernance Describe UserA
Read-onlyIdempotent

Describe user properties, email, disabled status, and default warehouse/role.

Inputs: user_name (required). Returns: object

governance_drop_roleGovernance Drop RoleB
Destructive

Drop a role in Snowflake. Requires confirmation.

Inputs: role_name (required), confirm. Returns: object

governance_get_current_contextGovernance Get Current ContextA
Read-onlyIdempotent

Retrieve current active session context (current user, role, warehouse, database, schema, and account).

Inputs: no named parameters. Returns: object

governance_list_connectionsGovernance List ConnectionsA
Read-onlyIdempotent

List available connection profiles configured in ~/.snowflake/connections.toml and show active profile.

Inputs: no named parameters. Returns: object

governance_list_grants_to_roleGovernance List Grants To RoleA
Read-onlyIdempotent

List privileges granted to a specific role.

Inputs: role_name (required). Returns: object

governance_list_grants_to_userGovernance List Grants To UserB
Read-onlyIdempotent

List roles granted to a specific user.

Inputs: user_name (required). Returns: object

governance_list_rolesGovernance List RolesC
Read-onlyIdempotent

List roles available in the Snowflake account. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

governance_list_usersGovernance List UsersB
Read-onlyIdempotent

List users in the Snowflake account with login status and default roles. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

governance_use_connectionGovernance Use ConnectionB
Idempotent

Dynamically switch the active Snowflake session to a different connection profile from ~/.snowflake/connections.toml.

Inputs: connection_name (required). Returns: object

horizon_describe_masking_policyHorizon Describe Masking PolicyB
Read-onlyIdempotent

Describe signature, return type, and body of a masking policy.

Inputs: policy_name (required), database, schema_name. Returns: object

horizon_describe_row_access_policyHorizon Describe Row Access PolicyB
Read-onlyIdempotent

Describe signature, filter expression, and comment of a row access policy.

Inputs: policy_name (required), database, schema_name. Returns: object

horizon_get_column_lineageHorizon Get Column LineageA
Read-onlyIdempotent

Trace origin and transformation lineage for one column from SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY (direct objects, base objects, and objects modified, including baseSources and directSources). The view lags up to 3 hours and requires Enterprise Edition (or higher).

Inputs: table_name (required), column_name (required), days, limit, +2 more. Returns: object

horizon_get_object_lineageHorizon Get Object LineageB
Read-onlyIdempotent

Retrieve upstream source and downstream dependent object lineage from Snowflake Horizon.

Inputs: object_name (required), database, direction, schema_name. Returns: object

horizon_list_masking_policiesHorizon List Masking PoliciesB
Read-onlyIdempotent

List column masking policies in the account, database, or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

horizon_list_row_access_policiesHorizon List Row Access PoliciesA
Read-onlyIdempotent

List row access policies defined in the account, database, or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

network_describe_network_policyNetwork Describe Network PolicyB
Read-onlyIdempotent

Describe allowed IP lists, blocked IP lists, and comments for a network policy.

Inputs: policy_name (required). Returns: object

network_describe_network_ruleNetwork Describe Network RuleB
Read-onlyIdempotent

Describe mode (INGRESS, INTERNAL_STAGE, EGRESS), type (IPV4, AWSVPCEID, HOST_PORT), and value list of a network rule.

Inputs: rule_name (required), database, schema_name. Returns: object

network_describe_password_policyNetwork Describe Password PolicyB
Read-onlyIdempotent

Describe password policy constraints (min length, lockout time, history, age).

Inputs: policy_name (required), database, schema_name. Returns: object

network_list_network_policiesNetwork List Network PoliciesB
Read-onlyIdempotent

List network policies configured in the account. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

network_list_network_rulesNetwork List Network RulesB
Read-onlyIdempotent

List network rules defined in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

network_list_password_policiesNetwork List Password PoliciesB
Read-onlyIdempotent

List password security policies defined in the account or database. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

pipes_create_pipePipes Create PipeC

Create a Snowpipe for continuous ingestion.

Inputs: pipe_name (required), copy_statement (required), database, auto_ingest, +2 more. Returns: object

pipes_describe_pipePipes Describe PipeC
Read-onlyIdempotent

Describe pipe definition and COPY statement.

Inputs: pipe_name (required), database, schema_name. Returns: object

pipes_drop_pipePipes Drop PipeB
Destructive

Drop a Snowpipe. Requires confirmation.

Inputs: pipe_name (required), confirm, database, schema_name. Returns: object

pipes_get_pipe_statusPipes Get Pipe StatusA
Read-onlyIdempotent

Get execution and health status of a Snowpipe (pending file count, last ingested timestamp).

Inputs: pipe_name (required), database, schema_name. Returns: object

pipes_list_pipesPipes List PipesB
Read-onlyIdempotent

List Snowpipes configured in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

programmability_describe_functionProgrammability Describe FunctionB
Read-onlyIdempotent

Describe UDF function signature, return type, language, and body.

Inputs: function_signature (required), database, schema_name. Returns: object

programmability_describe_procedureProgrammability Describe ProcedureA
Read-onlyIdempotent

Describe procedure signature, return type, language, and definition body.

Inputs: procedure_signature (required), database, schema_name. Returns: object

programmability_describe_secretProgrammability Describe SecretA
Read-onlyIdempotent

Describe secret metadata, type (GENERIC_STRING, OAUTH2), and owner without exposing secret value.

Inputs: secret_name (required), database, schema_name. Returns: object

programmability_list_event_tablesProgrammability List Event TablesB
Read-onlyIdempotent

List event tables used for application logging, tracing, and SPCS telemetry. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

programmability_list_functionsProgrammability List FunctionsB
Read-onlyIdempotent

List user-defined functions (UDFs) in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

programmability_list_integrationsProgrammability List IntegrationsB
Read-onlyIdempotent

List external integrations (API, Storage, Notification, Security integrations). Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, integration_type. Returns: object

programmability_list_notification_integrationsProgrammability List Notification IntegrationsC
Read-onlyIdempotent

List notification integrations configured for alerts, tasks, and cloud messaging (SNS, PubSub, Webhooks). Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

programmability_list_proceduresProgrammability List ProceduresC
Read-onlyIdempotent

List stored procedures in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

programmability_list_secretsProgrammability List SecretsB
Read-onlyIdempotent

List security secrets (API keys, OAuth credentials) stored in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

programmability_list_sequencesProgrammability List SequencesB
Read-onlyIdempotent

List auto-increment sequences in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

queries_begin_transactionQueries Begin TransactionA
Idempotent

Begin an explicit transaction on the active session.

Inputs: no named parameters. Returns: object

queries_cancel_queryQueries Cancel QueryA
Destructive

Cancel an active running Snowflake query by its Query ID. Requires confirmation.

Inputs: query_id (required), confirm. Returns: object

queries_commit_transactionQueries Commit TransactionA
Idempotent

Commit the current active transaction on the session.

Inputs: no named parameters. Returns: object

queries_execute_dmlQueries Execute DmlB
Destructive

Execute a data modification SQL statement (INSERT, UPDATE, DELETE, MERGE, CREATE). Requires confirmation.

Inputs: statement (required), confirm. Returns: object

queries_get_query_historyQueries Get Query HistoryB
Read-onlyIdempotent

Retrieve recent query execution history for the current account/user.

Inputs: limit. Returns: object

queries_get_query_operator_statsQueries Get Query Operator StatsB
Read-onlyIdempotent

Retrieve operator-level execution statistics and profiling data for a past Query ID.

Inputs: query_id (required). Returns: object

queries_get_query_planQueries Get Query PlanA
Read-onlyIdempotent

Generate the EXPLAIN execution plan for a SQL query without executing it.

Inputs: query (required). Returns: object

queries_queryQueries QueryB
Read-onlyIdempotent

Execute a SQL SELECT or read-only query on Snowflake and return structured rows with metadata.

Inputs: query (required), max_rows. Returns: object

queries_rollback_transactionQueries Rollback TransactionA
Destructive

Rollback the current active transaction on the session. Requires confirmation.

Inputs: confirm. Returns: object

recipes_account_usage_summaryRecipes Account Usage SummaryA
Read-onlyIdempotent

Composite recipe: Summary of warehouse compute credits and storage consumption over the past 7 days.

Inputs: no named parameters. Returns: object

recipes_clone_table_recipeRecipes Clone Table RecipeA

Composite recipe: Clone table with Time Travel timestamp or statement ID in 1 call.

Inputs: source_table (required), target_table (required), at_or_before. Returns: object

recipes_discover_schema_lineageRecipes Discover Schema LineageB
Read-onlyIdempotent

Composite recipe: Discover all tables and views in a schema along with their column definitions.

Inputs: database, schema_name. Returns: object

recipes_export_query_to_stageRecipes Export Query To StageC

Composite recipe: Unload query results to a stage as Parquet or CSV files.

Inputs: query (required), stage_location (required), header, file_format. Returns: object

recipes_health_checkRecipes Health CheckA
Read-onlyIdempotent

Composite recipe: Run health check on connection, active session, warehouse state, and credit consumption.

Inputs: no named parameters. Returns: object

recipes_inspect_table_with_sampleRecipes Inspect Table With SampleB
Read-onlyIdempotent

Composite recipe: Describe table schema, row count, column types, and preview sample rows in 1 call.

Inputs: table_name (required), database, sample_rows, schema_name. Returns: object

recipes_profile_tableRecipes Profile TableB
Read-onlyIdempotent

Composite recipe: Profile table metadata, row count, and column inventory.

Inputs: table_name (required), database, schema_name. Returns: object

recipes_warehouse_scale_and_executeRecipes Warehouse Scale And ExecuteB
Destructive

Composite recipe: Safely scale up a warehouse, run a heavy query, and optionally restore previous size. Requires confirmation.

Inputs: query (required), target_size (required), warehouse_name (required), confirm, +1 more. Returns: object

schemas_clone_schemaSchemas Clone SchemaB

Create a zero-copy clone of a schema.

Inputs: source_schema (required), target_schema (required), database. Returns: object

schemas_create_schemaSchemas Create SchemaC

Create a new schema inside a specified database.

Inputs: name (required), comment, database, if_not_exists. Returns: object

schemas_describe_schemaSchemas Describe SchemaA
Read-onlyIdempotent

Describe schema properties, owner, and retention settings.

Inputs: schema_name (required), database. Returns: object

schemas_drop_schemaSchemas Drop SchemaB
Destructive

Drop a schema in Snowflake. Requires confirmation flag.

Inputs: name (required), confirm, database. Returns: object

schemas_list_schemasSchemas List SchemasB
Read-onlyIdempotent

List all schemas within a specific database or the current active database. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database. Returns: object

schemas_undrop_schemaSchemas Undrop SchemaB

Restore a recently dropped schema using Time Travel.

Inputs: name (required), database. Returns: object

stages_create_stageStages Create StageC

Create an internal named stage in Snowflake.

Inputs: stage_name (required), comment, database, schema_name, +1 more. Returns: object

stages_describe_stageStages Describe StageB
Read-onlyIdempotent

Describe stage location URL, storage integration, and file format properties.

Inputs: stage_name (required), database, schema_name. Returns: object

stages_drop_stageStages Drop StageA
Destructive

Drop a stage in Snowflake. Requires confirmation.

Inputs: stage_name (required), confirm, database, schema_name. Returns: object

stages_list_stage_filesStages List Stage FilesB
Read-onlyIdempotent

List files inside a Snowflake stage location (e.g. '@MY_STAGE/path/').

Inputs: stage_location (required), pattern. Returns: object

stages_list_stagesStages List StagesB
Read-onlyIdempotent

List internal and external stages available in the active database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

stages_remove_stage_fileStages Remove Stage FileB
Destructive

Remove a file from a stage location. Requires confirmation.

Inputs: stage_file_path (required), confirm. Returns: object

streams_create_streamStreams Create StreamC

Create a CDC stream on a table or view.

Inputs: on_table (required), stream_name (required), database, append_only, +2 more. Returns: object

streams_describe_streamStreams Describe StreamA
Read-onlyIdempotent

Describe stream metadata, source table, and stale status.

Inputs: stream_name (required), database, schema_name. Returns: object

streams_drop_streamStreams Drop StreamB
Destructive

Drop a stream. Requires confirmation.

Inputs: stream_name (required), confirm, database, schema_name. Returns: object

streams_list_streamsStreams List StreamsB
Read-onlyIdempotent

List table/view streams in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

streams_read_stream_changesStreams Read Stream ChangesB
Read-onlyIdempotent

Query unconsumed CDC changes recorded in a stream (default 10 rows).

Inputs: stream_name (required), limit. Returns: object

tables_clone_tableTables Clone TableB

Create a zero-copy clone of an existing table.

Inputs: source_table (required), target_table (required). Returns: object

tables_create_tableTables Create TableC

Create a table in Snowflake with specified column definitions SQL.

Inputs: table_name (required), columns_sql (required), database, schema_name, +1 more. Returns: object

tables_describe_tableTables Describe TableB
Read-onlyIdempotent

Describe column definitions, data types, nullability, and primary keys for a table or view.

Inputs: table_name (required), database, schema_name. Returns: object

tables_drop_tableTables Drop TableB
Destructive

Drop a table in Snowflake. Requires confirmation flag.

Inputs: table_name (required), confirm. Returns: object

tables_get_table_ddlTables Get Table DdlB
Read-onlyIdempotent

Retrieve the exact CREATE OR REPLACE TABLE/VIEW DDL definition for an object.

Inputs: object_name (required), object_type. Returns: object

tables_list_tablesTables List TablesB
Read-onlyIdempotent

List tables in a database schema with row counts and bytes. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

tables_list_viewsTables List ViewsB
Read-onlyIdempotent

List views in a database schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

tables_sample_tableTables Sample TableC
Read-onlyIdempotent

Preview sample rows from a table (default 10 rows).

Inputs: table_name (required), sample_size. Returns: object

tables_truncate_tableTables Truncate TableA
Destructive

Truncate all data rows from a table while preserving schema. Requires confirmation.

Inputs: table_name (required), confirm. Returns: object

tables_undrop_tableTables Undrop TableA

Restore a recently dropped table using Time Travel.

Inputs: table_name (required). Returns: object

tags_describe_tagTags Describe TagA
Read-onlyIdempotent

Describe tag properties, allowed values, and comment. A name in double quotes, such as a list row's quoted_name, must match exactly.

Inputs: tag_name (required), database, schema_name. Returns: object

tags_get_object_tag_referencesTags Get Object Tag ReferencesB
Read-onlyIdempotent

Get tag key/value assignments on a specific database object.

Inputs: object_name (required), object_domain. Returns: object

tags_list_tagsTags List TagsB
Read-onlyIdempotent

List object tags defined in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

tags_set_object_tagTags Set Object TagC
Idempotent

Set or assign a tag value on a Snowflake object (TABLE, SCHEMA, DATABASE, etc.).

Inputs: tag_name (required), tag_value (required), object_name (required), object_domain. Returns: object

tasks_create_taskTasks Create TaskA

Create a task. schedule is optional and is omitted from CREATE TASK when unset. EXECUTE TASK runs a standalone or root task once; it does not run a child task. A child runs after its predecessors (AFTER), a finalizer runs with FINALIZE, and a triggered task uses WHEN (for example SYSTEM$STREAM_HAS_DATA) with no schedule. This tool sets only an optional SCHEDULE; it does not set AFTER, FINALIZE, or WHEN. Resuming fails unless the task has a SCHEDULE, AFTER, FINALIZE, or WHEN trigger.

Inputs: task_name (required), sql_statement (required), database, schedule, +3 more. Returns: object

tasks_describe_taskTasks Describe TaskA
Read-onlyIdempotent

Describe task definition, schedule, warehouse, and definition SQL.

Inputs: task_name (required), database, schema_name. Returns: object

tasks_drop_taskTasks Drop TaskA
Destructive

Drop a task in Snowflake. Requires confirmation.

Inputs: task_name (required), confirm, database, schema_name. Returns: object

tasks_execute_taskTasks Execute TaskB
Destructive

Trigger an immediate one-time execution of a task. Requires confirmation.

Inputs: task_name (required), confirm, database, schema_name. Returns: object

tasks_list_tasksTasks List TasksB
Read-onlyIdempotent

List tasks in a database or schema with schedule, state, and predecessor info. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern, database, schema_name. Returns: object

tasks_resume_taskTasks Resume TaskA
Idempotent

Resume a suspended task. Snowflake error 091453 means the task has no SCHEDULE, AFTER, FINALIZE, or WHEN trigger. A schedule-less task can still be run once with EXECUTE TASK.

Inputs: task_name (required), database, schema_name. Returns: object

tasks_suspend_taskTasks Suspend TaskB
Idempotent

Suspend an active scheduled task.

Inputs: task_name (required), database, schema_name. Returns: object

warehouses_create_warehouseWarehouses Create WarehouseC

Create a new virtual warehouse in Snowflake.

Inputs: warehouse_name (required), comment, auto_resume, auto_suspend, +2 more. Returns: object

warehouses_describe_warehouseWarehouses Describe WarehouseA
Read-onlyIdempotent

Describe details and running state of a specific virtual warehouse. A name in double quotes, such as a list row's quoted_name, must match exactly.

Inputs: warehouse_name (required). Returns: object

warehouses_drop_warehouseWarehouses Drop WarehouseB
Destructive

Drop a virtual warehouse. Requires confirmation.

Inputs: warehouse_name (required), confirm. Returns: object

warehouses_get_warehouse_load_historyWarehouses Get Warehouse Load HistoryC
Read-onlyIdempotent

Get execution load, queuing, and provisioning history for a warehouse.

Inputs: warehouse_name (required). Returns: object

warehouses_list_warehousesWarehouses List WarehousesB
Read-onlyIdempotent

List virtual warehouses in the account with size, state, and auto-suspend configurations. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Inputs: pattern. Returns: object

warehouses_resize_warehouseWarehouses Resize WarehouseB

Change warehouse compute size (XSMALL, SMALL, MEDIUM, LARGE, XLARGE, 2XLARGE, etc.).

Inputs: size (required), warehouse_name (required). Returns: object

warehouses_resume_warehouseWarehouses Resume WarehouseB
Idempotent

Resume a suspended virtual warehouse.

Inputs: warehouse_name (required). Returns: object

warehouses_suspend_warehouseWarehouses Suspend WarehouseA
Idempotent

Suspend an active virtual warehouse to save compute costs.

Inputs: warehouse_name (required). Returns: object

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    C2.9/5.0

    Scored across 140 tools

    Disambiguation3/5

    Most tools are clearly scoped by resource and action, but the huge surface creates overlapping families such as tables/views/dynamic tables/Iceberg tables and list/describe variants. Composite recipes also duplicate underlying tools like describe/sample/clone, so an agent has multiple plausible choices for similar tasks.

    Naming Consistency4/5

    Tool names broadly follow a predictable snake_case category_prefix + verb_noun pattern, e.g. tables_list_tables and warehouses_suspend_warehouse. Minor deviations exist, such as recipes_clone_table_recipe, occasional get_ vs describe_ usage, and domain-specific suffixes like embed_text_768.

    Tool Count1/5

    With 140 tools, this is far beyond a well-scoped MCP surface and exceeds the extreme-mismatch threshold. The breadth mirrors much of Snowflake, but it imposes very high selection and context burden for an agent.

    Completeness3/5

    Core objects such as databases, schemas, tables, warehouses, stages, streams, tasks, pipes, roles, and users have useful lifecycle coverage. However, many resources are read-only or lack create/drop/alter operations, including grants, views, policies, procedures/functions/secrets, dynamic/Iceberg tables, and SPCS resources, leaving notable gaps despite generic SQL fallbacks.

    Maintenance

    ActivityActive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    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
      MIT
    • A
      license
      Not graded
      quality
      F
      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.
      9,504 PyPI
      304
      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