Snowflake icon

Snowflake

Enables interaction with Snowflake databases through a Model Context Protocol (MCP) server, facilitating SQL query execution and data insight memo management.

About

The Snowflake MCP Server provides an interface for interacting with Snowflake databases within the Model Context Protocol ecosystem. It exposes tools for querying, creating, and describing tables, as well as appending data insights to a continuously updated memo resource. This server empowers applications to retrieve data, modify schemas (with proper authorization), and capture analytical findings directly within Snowflake.

Key Features

  • Offers configurable access controls and logging options.
  • Provides tools for listing tables and describing table schemas.
  • Executes SELECT, INSERT, UPDATE, and DELETE queries on Snowflake databases.
  • Maintains a dynamic memo resource that aggregates data insights.
  • Integrates with Claude Desktop via Smithery or direct configuration.
  • 21 GitHub stars

Use Cases

  • Analyzing data stored in Snowflake using natural language processing tools.
  • Building data-driven applications that require real-time insights from Snowflake.
  • Automating database schema discovery and documentation.