Snowflake

关于

This tool acts as a secure, read-only Model Context Protocol (MCP) server specifically designed for Snowflake, empowering AI agents and Large Language Models (LLMs) with safe database interaction. Built on FastMCP, it provides a structured interface for common database operations like running SQL queries, listing schemas and tables, describing table structures, and sampling data. A strict read-only policy validates all incoming SQL to prevent any write, DDL, or transactional operations, ensuring data integrity and security for AI-driven workflows.

主要功能

• Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
• Generate random samples of table data
• 0 GitHub stars
• Built-in safety constraints with strict read-only SQL validation
• Convenience tools for schema exploration (list tables, describe tables, list schemas)
• Save executed queries and their results to specified directories

使用案例

• Securely capturing and saving SQL queries and their corresponding results generated by autonomous agents.
• Enabling AI agents to safely query and interact with Snowflake databases for data retrieval and analysis.
• Automating data exploration and schema discovery processes using LLM tool-use workflows.