Skip to main content
Glama
deenesjakoruzh
christianclaudio

snowflake-mcp-server

by christianclaudio
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

❄️ snowflake-mcp-server

CI License: Apache-2.0 Python MCP Standard

Supercharge AI Agents with Native Snowflake Data Cloud & Cortex AI Superpowers! ⚡
An enterprise-grade Model Context Protocol (MCP) server providing 127 tools across 18 domain modules, zero-config connection resolution, safe SQL execution, virtual warehouse management, object inspection, and Cortex AI integrations straight to your favorite AI assistant.

🛡️ Enterprise Disclaimers & Safety

IMPORTANT

Community Project Disclaimer
snowflake-mcp-server is an independent open-source project licensed under Apache 2.0. It is not affiliated with, sponsored by, endorsed by, or supported by Snowflake Inc. "Snowflake" and "Cortex" are trademarks of Snowflake Inc.

WARNING

Safety Guardrails

  • Read-Only Safety Mode: Set SNOWFLAKE_MCP_READONLY=1 (or pass --readonly) to disable all DDL/DML mutation capabilities.

  • Destructive Safety Gates: Dropping databases, schemas, or tables requires explicit confirm=True.

  • Query Limits: Default execution limits prevent context window overflow (SNOWFLAKE_MAX_ROWS=1000, SNOWFLAKE_QUERY_TIMEOUT=120).

Related MCP server: Snowflake MCP Server

🔌 Connection & Multi-Auth Resolution

snowflake-mcp-server automatically resolves credentials across all enterprise Snowflake configurations:

  1. Snowflake CLI Inheritance (~/.snowflake/connections.toml): Zero-configuration connection. If you have configured connections via snow, the server automatically connects to your default or specified profile (-c <conn_name>).

  2. Programmatic Access Tokens (PAT) / OAuth: Set token in connections profile or SNOWFLAKE_TOKEN.

  3. RSA Key-Pair JWT Authentication: Set SNOWFLAKE_PRIVATE_KEY_PATH (and optional SNOWFLAKE_PRIVATE_KEY_PASSPHRASE).

  4. SSO / Browser Authentication: Set SNOWFLAKE_AUTHENTICATOR=externalbrowser.

  5. Environment Variables: Standard SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE.

📦 Installation & Quickstart

# 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

🛠️ Complete Tool Suite (127 Enterprise Tools)

Domain Suite

Count

Key Tools

1. SQL Queries & Transactions

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. Databases & Clones

7

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

3. Schemas & Clones

6

snowflake_list_schemas, snowflake_describe_schema, snowflake_create_schema, snowflake_drop_schema, snowflake_clone_schema, snowflake_undrop_schema

4. Tables, Views & Partitions

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. Virtual Warehouses & Scaling

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. Stages & File Operations

6

snowflake_list_stages, snowflake_describe_stage, snowflake_create_stage, snowflake_drop_stage, snowflake_list_stage_files, snowflake_remove_stage_file

7. Tasks & DAG Pipelines

7

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

8. Streams & Change Data Capture

5

snowflake_list_streams, snowflake_describe_stream, snowflake_create_stream, snowflake_drop_stream, snowflake_read_stream_changes

9. Dynamic & Iceberg Tables

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 & Ingestion

5

snowflake_list_pipes, snowflake_describe_pipe, snowflake_create_pipe, snowflake_drop_pipe, snowflake_get_pipe_status

11. Alerts & Notifications

6

snowflake_list_alerts, snowflake_describe_alert, snowflake_create_alert, snowflake_drop_alert, snowflake_resume_alert, snowflake_suspend_alert

12. Governance, RBAC & Users

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. Network & Password Policies

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 Compute Pools & 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. Object Tags & Classifications

4

snowflake_list_tags, snowflake_describe_tag, snowflake_get_object_tag_references, snowflake_set_object_tag

16. Programmability, UDFs & Secrets

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 Extensions

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. Composite Agent Workflows

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

📜 License

Apache 2.0. Copyright (c) 2026 Christian Claudio.

Install Server
RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd
A
license - permissive license
C
quality
B
maintenance

How are these scores calculated?

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.

Tools

View all tools

Related MCP Servers

  • Snowflake MCP Agent System

    silverknight404
    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.

  • Snowflake MCP Server

    sfc-gh-tjia
    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
  • Snowflake Cortex AI MCP Server by Snowflake-Labs

    Snowflake Cortex AI MCP Serverofficial

    Snowflake-Labs
    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

  • Snowflake Developer MCP Server

    mcp-tg
    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

  • kansei-mcp-server

    SaaS intelligence for AI agents. 5 unified tools cover 1,000+ services with 91-96% token savings.

  • ateam-mcp

    Build, validate, and deploy multi-agent AI solutions from any AI environment.

  • Scalix Cloud

    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