home / mcp / snowflake mcp server

Snowflake MCP Server

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

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "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