Snowflake MCP Server

Databasestdiov1.2.0
Repositorio

Official Snowflake MCP server enabling AI agents to query and analyze data in the Snowflake AI Data Cloud. Supports running SQL against warehouses, exploring databases and schemas, describing tables, and invoking Cortex AI services for search and analytics, with role-based access control honored end to end.

Conectar

Añade esta configuración a .claude/mcp.json

{
  "mcpServers": {
    "snowflake": {
      "command": "uvx",
      "args": [
        "snowflake-labs-mcp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<YOUR_SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<YOUR_SNOWFLAKE_PASSWORD>"
      }
    }
  }
}

Herramientas (3)

run_query

Execute a read-only SQL query against a Snowflake warehouse and return rows.

{
  "type": "object",
  "required": [
    "statement"
  ],
  "properties": {
    "statement": {
      "type": "string",
      "description": "SQL statement to execute"
    },
    "warehouse": {
      "type": "string",
      "description": "Warehouse to run the query on"
    }
  }
}

list_tables

List tables in a given database and schema.

{
  "type": "object",
  "required": [
    "database",
    "schema"
  ],
  "properties": {
    "schema": {
      "type": "string",
      "description": "Schema name"
    },
    "database": {
      "type": "string",
      "description": "Database name"
    }
  }
}

describe_table

Return the column definitions and metadata for a table.

{
  "type": "object",
  "required": [
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Fully qualified table name (database.schema.table)"
    }
  }
}

Recursos

Este servidor no expone ningún recurso.

Prompts

Este servidor no expone ningún prompt.

Información del servidor

Autor
Snowflake (@Snowflake-Labs)
Repositorio
https://github.com/Snowflake-Labs/mcp
Licencia
Apache-2.0
Versión
1.2.0
Estrellas
980
Última actualización
19 de junio de 2026