Snowflake MCP Server
About This Server
A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake. This server enables running SQL queries with tools and interacting with a memo of data insights presented as a resource.
Server Information
This webpage is the GitHub repository for "mcp-snowflake-server" owned by isaacwasserman. It describes a Model Context Protocol (MCP) server implementation for interacting with Snowflake databases. The page provides details on the project's components, tools, and installation instructions for Claude Desktop.
ā Key Points:
- The repository is public.
- The project provides database interaction with Snowflake.
- It exposes a dynamic resource: memo://insights, which is a continuously updated data insights memo.
- The server offers six core tools for query, schema, and analysis purposes.
- Installation instructions are provided for Smithery, UVX, and local setups for use with Claude Desktop.
- The project is licensed under GPL-3.0.
- The mcp-snowflake-server facilitates interaction with Snowflake databases through a Model Context Protocol server.
- It offers resources and tools for querying, schema management, and data analysis.
- The project integrates with Claude Desktop and provides detailed installation instructions.
- The server has 15 stars and 4 forks.
- The primary programming language is Python.
- Resources: The server exposes a single dynamic resource: memo://insights
- Tools: Six core tools are available: readquery, writequery, createtable, listtables, describe-table, and append_insight.
- Installation: Installation methods include Smithery, UVX, and local installation.
- Repository details: Includes links to releases (19), contributors (2), and used-by information.
š Main Findings:
š Details:
šÆ Conclusion:
The mcp-snowflake-server is a publicly available GitHub repository offering a Snowflake database interaction server. It provides tools for querying, schema management, and data analysis, with specific integration and installation instructions for Claude Desktop. The project is licensed under GPL-3.0.
Server Features
read_query
Execute SELECT queries to read data from the database
write_query
Execute INSERT, UPDATE, or DELETE queries
create_table
Create new tables in the database
list_tables
Get a list of all tables in the database
describe-table
View column information for a specific table
append_insight
Add new data insights to the memo resource
Provider Information
Isaacwasserman
cloud Provider