Snowflake
A solid Snowflake integration that wraps the full database API into MCP tools. You get read/write query execution, complete schema introspection (databases, schemas, tables, columns), and an insights memo system for tracking discovered patterns. The TOML configuration approach lets you manage multiple Snowflake environments cleanly. Write operations are disabled by default, which is smart for production safety. Reach for this when you need Claude to analyze your Snowflake data warehouse, generate reports, or help with schema exploration without switching contexts.
- GitHub stars
- 183
- tools
- 8
- last updated
- Mar 9, 2026
Tools
8 toolsPublic tool metadata for what this MCP can expose to an agent.
read_queryExecute SELECT queries to read data from the database.
Execute SELECT queries to read data from the database.
No parameter schema in public metadata yet.
write_queryExecute INSERT, UPDATE, or DELETE queries.
Execute INSERT, UPDATE, or DELETE queries.
No parameter schema in public metadata yet.
create_tableCreate new tables in the database.
Create new tables in the database.
No parameter schema in public metadata yet.
list_databasesList all databases in the Snowflake instance.
List all databases in the Snowflake instance.
No parameter schema in public metadata yet.
list_schemasList all schemas within a specific database.
List all schemas within a specific database.
No parameter schema in public metadata yet.
list_tablesList all tables within a specific database and schema.
List all tables within a specific database and schema.
No parameter schema in public metadata yet.
describe_tableView column information for a specific table.
View column information for a specific table.
No parameter schema in public metadata yet.
append_insightAdd new data insights to the memo resource.
Add new data insights to the memo resource.
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
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
Details
- Repository
- github.com/isaacwasserman/mcp-snowflake-server
- Category
- Data & Analytics
Related Data & Analytics MCP servers
View all
Google Analytics 4mindstone/mcp-serversGoogle Analytics 4 MCP server with reporting, schema discovery, and admin visibility tools0stars
Bigquery Mcpsnowleopard-ai/bigquery-mcpA SnowLeopardAI-managed MCP server that provides access to Google BigQuery data.10stars
Mcp Server Spreadsheetmarekrost/mcp-server-spreadsheetMCP server for spreadsheet files (.xlsx, .csv, .ods) - cell-level ops + DuckDB SQL engine.2stars
Snowflake MCP Servernsphung/mcp-snowflake-serverA Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants2stars
Google Sheetsio.github.mcp-z/mcp-sheetsGoogle Sheets integration with OAuth, spreadsheet management, batch operations, and formatting0stars