Snowflake

Provides read-only access to Snowflake data via MCP with multiple authentication options and safe query tooling.

python

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "dynamike-snowflake-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "snowflake-mcp"
      ],
      "env": {
        "SNOWFLAKE_AUTH_TYPE": "private_key",
        "SNOWFLAKE_PRIVATE_KEY_PATH": "/path/to/private_key.pem",
        "SNOWFLAKE_CONN_REFRESH_HOURS": "8"
      }
    }
  }
}

Available tools

list_databases

List all accessible Snowflake databases

list_views

List all views in a specified database and schema

describe_view

Get detailed information about a specific view including columns and SQL definition

query_view

Query data from a view with an optional row limit

execute_query

Execute custom read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) with results formatted as markdown tables

Built by

VeilStrat

AI signals for GTM teams

Snowflake MCP Server - dynamike/snowflake-mcp-server | VeilStrat