Snowflake MCP Server
by
Provides a Model Context Protocol server that connects to Snowflake, enabling execution of SQL queries, schema exploration, and dynamic insight aggregation through a set of tools and memo resources.
Snowflake MCP Server Overview
What is Snowflake MCP Server about?
A server implementation that exposes Snowflake database operations via Model Context Protocol tools. It lets clients run read‑only SELECT statements, optionally perform write operations, list databases/schemas/tables, describe table structures, and append data insights that appear in a continuously updated memo resource.
How to use Snowflake MCP Server?
- Install the server (recommended via Smithery or UVX). Example with Smithery:
npx -y @smithery/cli install mcp_snowflake_server --client claude - Configure connection parameters either through command‑line arguments, a TOML connections file, or environment variables (
SNOWFLAKE_USER,SNOWFLAKE_PASSWORD, etc.). - Run the server using the chosen runner (e.g.,
uvx run mcp_snowflake_serveror the npx command shown in theserverConfig). - Invoke tools from a compatible client (Claude Desktop, custom MCP client) to query data, explore schema, or add insights.
Key Features of Snowflake MCP Server
- Read Query Tool – Execute arbitrary SELECT statements and receive results as JSON objects.
- Write Query & Create Table Tools – Optional write capabilities (
--allow-write). - Schema Exploration – List databases, schemas, tables, and retrieve detailed column metadata.
- Dynamic Insight Memo –
append_insightupdatesmemo://insightsin real time. - Prefetch Context Resources – Optional per‑table context resources (
context://table/{table_name}). - Configurable Exclusions – Filter out unwanted databases, schemas, or tables.
- Logging – Adjustable log directory and level.
Use Cases of Snowflake MCP Server
- Data Analyst Assistant – Enable AI assistants to run ad‑hoc queries and retrieve schema information without direct database credentials.
- Automated Insight Collection – Applications can push discovered patterns or metrics to the memo resource for later review.
- Rapid Prototyping – Developers can interactively explore Snowflake structures and test queries within a conversational UI.
- Controlled Write Operations – Enable safe, audited data modifications in a staged environment using the
--allow-writeflag.
FAQ from Snowflake MCP Server
Q: Are write operations enabled by default?
A: No. Write tools (write_query, create_table) require the --allow-write flag.
Q: How are credentials supplied?
A: Via command‑line arguments, a TOML connections file, or environment variables (SNOWFLAKE_*).
Q: Can I limit which databases are exposed?
A: Yes, exclusion patterns can be set in runtime_config.json or via CLI flags.
Q: What does memo://insights contain?
A: An aggregated list of textual insights added through the append_insight tool.
Q: Is prefetching required for per‑table context resources?
A: Prefetch must be enabled; otherwise only the memo resource is available.
Snowflake MCP Server's README
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 theappend_insighttool. -
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
ExecuteSELECTqueries to read data from the database.
Input:query(string): TheSELECTSQL query to execute
Returns: Query results as array of objects
-
write_query(enabled only with--allow-write)
ExecuteINSERT,UPDATE, orDELETEqueries.
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 TABLESQL 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 databaseschema(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 ofmemo://insightsresource
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
-
Install Claude AI Desktop App
-
Install
uv:
curl -LsSf https://astral.sh/uv/install.sh | sh
- Create a
.envfile 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
# Alternatively, use external browser authentication:
# SNOWFLAKE_AUTHENTICATOR="externalbrowser"
-
[Optional] Modify
runtime_config.jsonto set exclusion patterns for databases, schemas, or tables. -
Test locally:
uv --directory /absolute/path/to/mcp_snowflake_server run mcp_snowflake_server
- 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_insighttool updates thememo://insightsresource dynamically.
License
MIT
Snowflake MCP Server Reviews
Login Required
Please log in to share your review and rating for this MCP.
Actions
Snowflake MCP Server's Information
- Author
- isaacwasserman
- Category
- Databases
- Language
- Python
- License
- GNU General Public License v3.0
- Stars
- 160
- Updated
- 21 days ago
Configuration
{
"mcpServers": {
"snowflake": {
"command": "npx",
"args": [
"-y",
"mcp_snowflake_server",
"--account",
"<ACCOUNT>",
"--warehouse",
"<WAREHOUSE>",
"--user",
"<USER>",
"--password",
"<PASSWORD>",
"--role",
"<ROLE>",
"--database",
"<DATABASE>",
"--schema",
"<SCHEMA>"
],
"env": {}
}
}
}Configure Clients
Similar MCP Servers like Snowflake MCP Server
Explore related MCPs that share similar capabilities and solve comparable challenges
MCP Toolbox for Databases
by googleapis
An MCP server that streamlines database tool development by handling connection pooling, authentication, observability, and secure access, allowing agents to interact with databases via natural language.
DBHub
by bytebase
Provides a universal gateway that lets MCP‑compatible clients explore and query MySQL, PostgreSQL, SQL Server, MariaDB, and SQLite databases through a single standardized interface.
MySQL MCP Server
by designcomputer
Enables secure interaction with MySQL databases via the Model Context Protocol, allowing AI applications to list tables, read contents, and execute queries safely.
MCP Server For MySQL
by benborla
Provides read‑only access to MySQL databases for large language models, allowing schema inspection and safe execution of SQL queries.
ClickHouse MCP Server
Officialby ClickHouse
Enables AI assistants to run read‑only ClickHouse queries, list databases and tables, and execute embedded chDB queries through an MCP interface.
Chroma MCP Server
by chroma-core
Offers an MCP server exposing Chroma's vector database capabilities for LLM applications, supporting collection and document management, multiple embedding functions, and flexible client types such as in‑memory, persistent, HTTP, and cloud.
Mcp Mongo Server
by kiliczsh
Enables LLMs to interact with MongoDB databases via a standardized interface, offering schema inspection, query execution, aggregation, and write capabilities, with optional read‑only mode and smart ObjectId handling.
Airtable MCP Server
by domdomegg
Provides read and write access to Airtable bases for AI systems, enabling inspection of schemas and manipulation of records.
xiyan_mcp_server
by XGenerationLab
A Model Context Protocol (MCP) server that enables natural language queries to databases