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.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIExecutes a SQL query on Snowflake and returns the results. Input: SQL query string. Output: Query results in a structured format.
Executes a SQL query on Snowflake and returns the results. Input: SQL query string. Output: Num rows exported. File path of the output file.
