remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Integrations
Provides database interaction with Snowflake, enabling SQL query execution, table management, and schema exploration. Includes tools for reading data, modifying data (with appropriate permissions), creating tables, listing available tables, and describing table structures.
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_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
ExecuteSELECT
queries to read data from the database.
Input:query
(string): TheSELECT
SQL query to execute
Returns: Query results as array of objects
write_query
(enabled only with--allow-write
)
ExecuteINSERT
,UPDATE
, orDELETE
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 nameslist_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://insights
resource
Usage with Claude Desktop
Installing via Smithery
To install Snowflake Server for Claude Desktop automatically via Smithery:
Installing via UVX
Installing Locally
- Install Claude AI Desktop App
- Install
uv
:
- Create a
.env
file with your Snowflake credentials:
- [Optional] Modify
runtime_config.json
to set exclusion patterns for databases, schemas, or tables. - Test locally:
- Add the server to your
claude_desktop_config.json
:
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 thememo://insights
resource dynamically.
License
MIT
This server cannot be installed
Snowflake integration implementing read and (optional) write operations as well as insight tracking