Snowflake MCP Server

Stabledatabase

★180 starsPythonSnowflake-Labs

About

Overview

The Snowflake MCP Server enables AI agents to interact with Snowflake's cloud data platform. It provides tools for executing SQL queries, listing databases and schemas, inspecting table structures, and working with Snowflake's unique features like data sharing, time travel, and semi-structured data support.

Capabilities

Tools & Capabilities

⚡query

Execute a SQL query against Snowflake

⚡list_databases

List all databases

⚡list_schemas

List schemas in a database

⚡list_tables

List tables in a schema

⚡describe_table

Get the schema of a table

Setup

Installation

bash

Install

pip install mcp-server-snowflake

Examples

Example Usage

javascript

Usage

{
  "mcpServers": {
    "snowflake": {
      "command": "python",
      "args": ["-m", "mcp_server_snowflake"],
      "env": {
        "SNOWFLAKE_ACCOUNT": "your-account",
        "SNOWFLAKE_USER": "your-user",
        "SNOWFLAKE_PASSWORD": "your-password",
        "SNOWFLAKE_WAREHOUSE": "COMPUTE_WH"
      }
    }
  }
}

Quick Info

AuthorSnowflake-Labs

LanguagePython

StatusStable

Stars★ 180

Last UpdatedFeb 12, 2026