Snowflake MCP Server

Databasestdiov1.2.0

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.

snowflake data-warehouse sql analytics cortex olap

Connect

Add this configuration to .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>"
      }
    }
  }
}

Tools (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)"
    }
  }
}

Resources

This server does not expose any resources.

Prompts

This server does not expose any prompts.

Server Information

Author: Snowflake (@Snowflake-Labs)
Repository: https://github.com/Snowflake-Labs/mcp
License: Apache-2.0
Version: 1.2.0
Stars: 980
Last Updated: June 19, 2026