isaacwasserman/mcp-snowflake-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:
---
Installing via UVX
Traditional Configuration (Individual Parameters)
TOML Configuration (Recommended)
---
Installing Locally
1. Install Claude AI Desktop App
2. Install uv:
3. Create a .env file with your Snowflake credentials:
4. [Optional] Modify runtime_config.json to set exclusion patterns for databases, schemas, or tables.