Snowflake
Summary
Snowflake MCP Server provides secure access to Snowflake databases for any MCP-compatible client, enabling SQL query execution with robust connection management. Built by David Amom, it handles database connection lifecycle (connect, reconnect on timeout, close), supports both password and key pair authentication methods, and processes query results safely. The implementation is particularly valuable for AI assistants that need to interact with Snowflake data warehouses without requiring users to switch contexts or manually execute queries, making it ideal for data analysis, reporting, and exploration workflows.
Available Actions(2)
execute_query
Executes a SQL query on Snowflake and returns the results. Input: SQL query string. Output: Query results in a structured format.
export_to_csv
Executes a SQL query on Snowflake and returns the results. Input: SQL query string. Output: Number of rows exported and the file path of the output file.
社区评论
暂无评论. 成为第一个评论的人!
登录以参与讨论