Snowflake

关于

This server acts as a Model Context Protocol (MCP) implementation, facilitating robust interaction with Snowflake databases. It allows users to execute various SQL queries (read, write, DDL), manage schema by listing and describing database components, and extract data insights, exposing these capabilities as distinct tools and resources. Designed for seamless integration within AI agent frameworks like Claude Desktop, it supports dynamic data exploration and modification while offering features like optional write access, logging, and exclusion patterns for refined control.

主要功能

• Execute SQL queries for reading, writing, and creating tables in Snowflake
• Capture and aggregate data insights into a continuously updated memo resource
• Secure operation with write capabilities disabled by default, configurable with `--allow-write`
• Retrieve comprehensive Snowflake schema information (databases, schemas, tables, columns)
• 0 GitHub stars
• Expose per-table schema summaries and other dynamic data context as resources

使用案例

• Integrating AI agents or applications with Snowflake databases for data access and manipulation
• Automating data analysis and the generation of insights from Snowflake data
• Programmatically exploring and managing Snowflake database schema for development or operational tasks