Enables running SQL queries and exposes data insights and schema context from Snowflake databases.
This Model Context Protocol (MCP) server integrates with Snowflake, offering a secure interface for data exploration and analysis. It allows users to execute SQL `SELECT` queries, retrieve comprehensive schema information, and aggregate discovered insights without enabling any write operations. By exposing detailed database context and dynamically updated insights as resources, it empowers AI models and users to interact with Snowflake data efficiently and safely, providing a read-only view of the database environment.
Key Features
010 GitHub stars
02Aggregate and expose dynamic data insights via a memo resource
03Execute SQL SELECT queries for data retrieval
04Provides read-only access to Snowflake, preventing write operations
05List and describe Snowflake databases, schemas, and tables
06Optionally prefetches and exposes per-table schema summaries
Use Cases
01Secure read-only access for applications requiring database context
02AI-driven data analysis and exploration on Snowflake datasets
03Automated discovery and cataloging of database insights