Snowflake MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries via tools and exposes data insights and schema context as resources.

Components# Resources

• memo://insights
  A continuously updated memo aggregating discovered data insights.
  Updated automatically when new insights are appended via the append_insight tool.
• context://table/{table_name}
  (If prefetch enabled) Per-table schema summaries, including columns and comments, exposed as individual resources.

Tools

The server exposes the following tools:

Query Tools

• read_query
  Execute SELECT queries to read data from the database.
  Input:
• query (string): The SELECT SQL query to execute
  Returns: Query results as array of objects
• write_query (enabled only with --allow-write)
  Execute INSERT, UPDATE, or DELETE queries.
  Input:
• query (string): The SQL modification query
  Returns: Number of affected rows or confirmation
• create_table (enabled only with --allow-write)
  Create new tables in the database.
  Input:
• query (string): CREATE TABLE SQL statement
  Returns: Confirmation of table creation

Schema Tools

• list_databases
  List all databases in the Snowflake instance.
  Returns: Array of database names
• list_schemas
  List all schemas within a specific database.
  Input:
• database (string): Name of the database
  Returns: Array of schema names
• list_tables
  List all tables within a specific database and schema.
  Input:
• database (string): Name of the database
• schema (string): Name of the schema
  Returns: Array of table metadata
• describe_table
  View column information for a specific table.
  Input:
• table_name (string): Fully qualified table name (database.schema.table)
  Returns: Array of column definitions with names, types, nullability, defaults, and comments

Analysis Tools

• append_insight
  Add new data insights to the memo resource.
  Input:
• insight (string): Data insight discovered from analysis
  Returns: Confirmation of insight addition
  Effect: Triggers update of memo://insights resource

Usage with Claude Desktop# Installing via Smithery

To install Snowflake Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install mcp_snowflake_server --client claude

Installing via UVX## Traditional Configuration (Individual Parameters)

"mcpServers": {
  "snowflake_pip": {
    "command": "uvx",
    "args": [
      "--python=3.12",  // Optional: specify Python version <=3.12
      "mcp_snowflake_server",
      "--account", "your_account",
      "--warehouse", "your_warehouse",
      "--user", "your_user",
      "--password", "your_password",
      "--role", "your_role",
      "--database", "your_database",
      "--schema", "your_schema"
      // Optionally: "--private_key_path", "your_private_key_absolute_path"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

"mcpServers": {
  "snowflake_production": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "production"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  },
  "snowflake_staging": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--connections-file", "/path/to/snowflake_connections.toml",
      "--connection-name", "staging"
    ]
  }
}

Installing Locally

1. Install Claude AI Desktop App

2. Install uv:

curl -LsSf https://astral.sh/uv/install.sh | sh

3. Create a .env file with your Snowflake credentials:

SNOWFLAKE_USER="xxx@your_email.com"
SNOWFLAKE_ACCOUNT="xxx"
SNOWFLAKE_ROLE="xxx"
SNOWFLAKE_DATABASE="xxx"
SNOWFLAKE_SCHEMA="xxx"
SNOWFLAKE_WAREHOUSE="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PASSWORD="xxx"
SNOWFLAKE_PRIVATE_KEY_PATH=/absolute/path/key.p8\n\n# Alternatively, use external browser authentication:\n\n# SNOWFLAKE_AUTHENTICATOR="externalbrowser"

4. [Optional] Modify runtime_config.json to set exclusion patterns for databases, schemas, or tables.

5. Test locally:

uv --directory /absolute/path/to/mcp_snowflake_server run mcp_snowflake_server

6. Add the server to your claude_desktop_config.json:

Traditional Configuration (Using Environment Variables)

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",  // Optional
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

TOML Configuration (Recommended)

"mcpServers": {
  "snowflake_local": {
    "command": "/absolute/path/to/uv",
    "args": [
      "--python=3.12",
      "--directory", "/absolute/path/to/mcp_snowflake_server",
      "run", "mcp_snowflake_server",
      "--connections-file", "/absolute/path/to/snowflake_connections.toml",
      "--connection-name", "development"
      // Optionally: "--allow_write"
      // Optionally: "--log_dir", "/absolute/path/to/logs"
      // Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
      // Optionally: "--exclude_tools", "{tool_name}", ["{other_tool_name}"]
    ]
  }
}

Notes

• By default, write operations are disabled. Enable them explicitly with --allow-write.
• The server supports filtering out specific databases, schemas, or tables via exclusion patterns.
• The server exposes additional per-table context resources if prefetching is enabled.
• The append_insight tool updates the memo://insights resource dynamically.

License

MIT