simple_snowflake_mcp

[](https://archestra.ai/mcp-catalog/yannbrrd__simple_snowflake_mcp)

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.

The server exposes comprehensive MCP tools to interact with Snowflake:

Core Database Operations:

• execute-snowflake-sql: Executes a SQL query on Snowflake and returns the result (list of dictionaries)
• execute-query: Executes a SQL query in read-only mode (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) or not (if read_only is false), result in markdown format
• query-view: Queries a view with an optional row limit (markdown result)

Discovery and Metadata:

• list-snowflake-warehouses: Lists available Data Warehouses (DWH) on Snowflake
• list-databases: Lists all accessible Snowflake databases
• list-schemas: Lists all schemas in a specified database
• list-tables: Lists all tables in a database and schema
• list-views: Lists all views in a database and schema
• describe-table: Gives details of a table (columns, types, constraints)
• describe-view: Gives details of a view (columns, SQL)

Advanced Operations:

• get-table-sample: Gets sample data from a table
• explain-query: Explains the execution plan of a SQL query
• show-query-history: Shows recent query history
• get-warehouse-status: Gets current warehouse status and usage
• validate-sql: Validates SQL syntax without execution

The server now includes a comprehensive YAML-based configuration system that allows you to customize all aspects of the server behavior.