Simple Snowflake MCP server
Enhanced Snowflake MCP Server with comprehensive configuration system and full MCP protocol compliance.
A production-ready MCP server that provides seamless Snowflake integration with advanced features including configurable logging, resource subscriptions, and comprehensive error handling. Designed to work seamlessly behind corporate proxies.
For release details, see CHANGELOG.md.
Tools
The server exposes the following MCP tools to interact with Snowflake:
Database Operations:
- execute-snowflake-sql: Executes a SQL query on Snowflake and returns the result. Supports
json(default),markdown, andcsvoutput via theformatargument. - execute-query: Executes a SQL query with server-enforced read-only protection. In read-only mode (the default) only
SELECT,SHOW,DESCRIBE,EXPLAIN, andWITHstatements (without DML) are allowed. Read-only mode is governed solely by server configuration and cannot be relaxed by the caller. Supports alimit, anoffsetfor paging, andmarkdown(default)/json/csvoutput viaformat. When a result is truncated the response includes theoffsetfor the next page.






