Snowflake Read-Only Server
Enables running SQL queries and exposes data insights and schema context from Snowflake databases.
About
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
- 0 GitHub stars
- Aggregate and expose dynamic data insights via a memo resource
- Execute SQL SELECT queries for data retrieval
- Provides read-only access to Snowflake, preventing write operations
- List and describe Snowflake databases, schemas, and tables
- Optionally prefetches and exposes per-table schema summaries
Use Cases
- Secure read-only access for applications requiring database context
- AI-driven data analysis and exploration on Snowflake datasets
- Automated discovery and cataloging of database insights