mcp-snowflake-server

mcp-snowflake-server

3.6

If you are the rightful owner of 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 a robust implementation designed to facilitate seamless interaction with Snowflake databases. It allows users to execute SQL queries, manage database schemas, and gain insights into data through a set of well-defined tools and resources. The server is equipped with query tools for reading and writing data, schema tools for managing database structures, and analysis tools for appending insights. It also supports dynamic updates to resources, such as data insights and schema summaries, enhancing the user's ability to manage and analyze data effectively. The server can be integrated with various platforms, including Claude Desktop, and offers flexible installation options via Smithery, UVX, or local setups. With features like write operation control and resource prefetching, the Snowflake MCP Server is a versatile solution for database management and analysis.

Features

  • Execute SQL queries for data manipulation and retrieval.
  • Manage database schemas with tools for listing databases, schemas, and tables.
  • Append and update data insights dynamically.
  • Control write operations with optional enabling.
  • Support for resource prefetching to expose schema summaries.