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

Treiben Sie KI-Agenten mit der nativen Snowflake Data Cloud & den Superkräften von Cortex AI zu Höchstleistungen an! ⚡
Ein Enterprise-tauglicher Model Context Protocol (MCP)-Server, der 127 Tools in 18 Domänenmodulen bereitstellt, darunter Verbindungsauflösung ohne Konfiguration, sichere SQL-Ausführung, Verwaltung virtueller Warehouses, Objektinspektion und Cortex-AI-Integrationen – direkt für Ihren bevorzugten KI-Assistenten.

🛡️ Enterprise-Haftungsausschlüsse & Sicherheit

[!IMPORTANT] Haftungsausschluss für Community-Projekte
snowflake-mcp-server ist ein unabhängiges Open-Source-Projekt, das unter Apache 2.0 lizenziert ist. Es ist nicht mit Snowflake Inc. verbunden, wird von Snowflake Inc. weder gesponsert, unterstützt noch befürwortet. „Snowflake" und „Cortex" sind Marken von Snowflake Inc.

[!WARNING] Sicherheitsvorkehrungen

  • Schreibgeschützter Sicherheitsmodus: Setzen Sie SNOWFLAKE_MCP_READONLY=1 (oder übergeben Sie --readonly), um alle DDL/DML-Mutationsfähigkeiten zu deaktivieren.

  • Sicherheitsgates für destruktive Operationen: Das Löschen von Datenbanken, Schemas oder Tabellen erfordert explizites confirm=True.

  • Abfragegrenzen: Standardmäßige Ausführungsgrenzen verhindern ein Überlaufen des Kontextfensters (SNOWFLAKE_MAX_ROWS=1000, SNOWFLAKE_QUERY_TIMEOUT=120).

Related MCP server: Snowflake MCP Server

🔌 Verbindung & Multi-Auth-Auflösung

snowflake-mcp-server löst Anmeldedaten automatisch über alle Enterprise-Snowflake-Konfigurationen hinweg auf:

  1. Snowflake-CLI-Vererbung (~/.snowflake/connections.toml): Verbindung ohne Konfiguration. Wenn Sie Verbindungen über snow konfiguriert haben, verbindet sich der Server automatisch mit Ihrem Standardprofil oder dem angegebenen Profil (-c <conn_name>).

  2. Programmatische Zugriffstokens (PAT) / OAuth: Setzen Sie token im Verbindungsprofil oder SNOWFLAKE_TOKEN.

  3. RSA-Schlüsselpaar-JWT-Authentifizierung: Setzen Sie SNOWFLAKE_PRIVATE_KEY_PATH (und optional SNOWFLAKE_PRIVATE_KEY_PASSPHRASE).

  4. SSO-/Browser-Authentifizierung: Setzen Sie SNOWFLAKE_AUTHENTICATOR=externalbrowser.

  5. Umgebungsvariablen: Standardmäßig SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE.

📦 Installation & Schnellstart

# 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

🛠️ Vollständige Tool-Suite (127 Enterprise-Tools)

Domänen-Suite

Anzahl

Wichtige Tools

1. SQL-Abfragen & Transaktionen

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. Datenbanken & Klone

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

6

snowflake_list_schemas, snowflake_describe_schema, snowflake_create_schema, snowflake_drop_schema, snowflake_clone_schema, snowflake_undrop_schema

4. Tabellen, Views & Partitionen

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. Virtuelle Warehouses & Skalierung

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

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. Dynamische & Iceberg-Tabellen

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

5

snowflake_list_pipes, snowflake_describe_pipe, snowflake_create_pipe, snowflake_drop_pipe, snowflake_get_pipe_status

11. Alarme & Benachrichtigungen

6

snowflake_list_alerts, snowflake_describe_alert, snowflake_create_alert, snowflake_drop_alert, snowflake_resume_alert, snowflake_suspend_alert

12. Governance, RBAC & Benutzer

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. Netzwerk- & Passwortrichtlinien

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. Objekt-Tags & Klassifizierungen

4

snowflake_list_tags, snowflake_describe_tag, snowflake_get_object_tag_references, snowflake_set_object_tag

16. Programmierbarkeit, 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-Erweiterungen

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. Zusammengesetzte Agenten-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

📜 Lizenz

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