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

¡Potencia a tus agentes de IA con los superpoderes nativos de Snowflake Data Cloud y Cortex AI! ⚡
Un servidor de Model Context Protocol (MCP) de nivel empresarial que ofrece 127 herramientas en 18 módulos de dominio, resolución de conexión sin configuración, ejecución segura de SQL, gestión de almacenes virtuales, inspección de objetos e integraciones de Cortex AI directamente en tu asistente de IA favorito.

🛡️ Descargos de responsabilidad empresariales y seguridad

[!IMPORTANT] Descargo de responsabilidad del proyecto comunitario
snowflake-mcp-server es un proyecto independiente de código abierto bajo la licencia Apache 2.0. No está afiliado, patrocinado, respaldado ni soportado por Snowflake Inc. "Snowflake" y "Cortex" son marcas comerciales de Snowflake Inc.

[!WARNING] Protecciones de seguridad

  • Modo seguro de solo lectura: Configura SNOWFLAKE_MCP_READONLY=1 (o pasa --readonly) para deshabilitar todas las capacidades de mutación DDL/DML.

  • Barreras de seguridad para operaciones destructivas: Eliminar bases de datos, esquemas o tablas requiere un confirm=True explícito.

  • Límites de consulta: Los límites de ejecución predeterminados evitan el desbordamiento de la ventana de contexto (SNOWFLAKE_MAX_ROWS=1000, SNOWFLAKE_QUERY_TIMEOUT=120).

Related MCP server: Snowflake MCP Server

🔌 Conexión y resolución de autenticación múltiple

snowflake-mcp-server resuelve automáticamente las credenciales en todas las configuraciones empresariales de Snowflake:

  1. Herencia de la CLI de Snowflake (~/.snowflake/connections.toml): Conexión sin configuración. Si has configurado conexiones mediante snow, el servidor se conecta automáticamente a tu perfil predeterminado o al perfil especificado (-c <conn_name>).

  2. Tokens de acceso programático (PAT) / OAuth: Configura token en el perfil de conexiones o SNOWFLAKE_TOKEN.

  3. Autenticación JWT con par de claves RSA: Configura SNOWFLAKE_PRIVATE_KEY_PATH (y opcionalmente SNOWFLAKE_PRIVATE_KEY_PASSPHRASE).

  4. Autenticación SSO / navegador: Configura SNOWFLAKE_AUTHENTICATOR=externalbrowser.

  5. Variables de entorno: Estándar SNOWFLAKE_ACCOUNT, SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_WAREHOUSE, SNOWFLAKE_DATABASE, SNOWFLAKE_SCHEMA, SNOWFLAKE_ROLE.

📦 Instalación e inicio rápido

# 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

🛠️ Suite completa de herramientas (127 herramientas empresariales)

Suite de dominio

Cantidad

Herramientas clave

1. Consultas SQL y transacciones

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. Bases de datos y 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. Esquemas y clones

6

snowflake_list_schemas, snowflake_describe_schema, snowflake_create_schema, snowflake_drop_schema, snowflake_clone_schema, snowflake_undrop_schema

4. Tablas, vistas y particiones

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. Almacenes virtuales y escalado

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 y operaciones de archivos

6

snowflake_list_stages, snowflake_describe_stage, snowflake_create_stage, snowflake_drop_stage, snowflake_list_stage_files, snowflake_remove_stage_file

7. Tareas y pipelines DAG

7

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

8. Streams y captura de datos de cambio

5

snowflake_list_streams, snowflake_describe_stream, snowflake_create_stream, snowflake_drop_stream, snowflake_read_stream_changes

9. Tablas dinámicas e 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 e ingesta

5

snowflake_list_pipes, snowflake_describe_pipe, snowflake_create_pipe, snowflake_drop_pipe, snowflake_get_pipe_status

11. Alertas y notificaciones

6

snowflake_list_alerts, snowflake_describe_alert, snowflake_create_alert, snowflake_drop_alert, snowflake_resume_alert, snowflake_suspend_alert

12. Gobernanza, RBAC y usuarios

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. Políticas de red y de contraseñas

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. Compute Pools de SPCS y 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. Etiquetas de objetos y clasificaciones

4

snowflake_list_tags, snowflake_describe_tag, snowflake_get_object_tag_references, snowflake_set_object_tag

16. Programabilidad, UDFs y secretos

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 y extensiones de 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. Flujos de trabajo compuestos de agentes

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

📜 Licencia

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