isaacwasserman_mcp-snowflake-server
If you are the rightful owner of isaacwasserman_mcp-snowflake-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.
The Snowflake MCP Server is designed to facilitate seamless interaction with Snowflake databases through the Model Context Protocol. It allows users to execute SQL queries, manage database schemas, and analyze data insights efficiently. The server supports both read and write operations, enabling users to perform a wide range of database tasks. Additionally, it features a dynamic resource that aggregates data insights, which can be updated in real-time as new insights are discovered. This makes it an ideal tool for data analysts and developers who need to interact with Snowflake databases in a structured and efficient manner.
Features
- Execute SQL queries for reading and modifying data.
- Manage database schemas with tools for listing and describing tables.
- Dynamic resource for aggregating and updating data insights.
- Supports both read and write operations with appropriate permissions.
- Integration with Claude Desktop for seamless usage.
Tools
read_query
Execute SELECT query and return query results
write_query
Execute an INSERT, UPDATE, or DELETE query to return the number of affected rows
create_table
Create a new table and return confirmation information
list_tables
List all table names in the database
describe-table
View column information for a specific table
append_insight
Add data insights into memo resources and trigger memo updates
