isaacwasserman/mcp-snowflake-server

Overview

A Python server that integrates Snowflake with the Model Context Protocol (MCP), enabling read operations and optional write operations alongside insight tracking. It allows AI agents to query and update Snowflake data through a standardized interface.

Best for

Best for
Developers building MCP-based AI tools that need direct Snowflake access

Use cases

• Connect AI assistants to query Snowflake databases for analytics and reporting
• Enable AI-driven data ingestion or record updates via write operations
• Track usage insights and query patterns across MCP-based tools

How to use

Install

npx -y @smithery/cli install mcp_snowflake_server --client claude

Tools exposed

• database
• table_name
• read_query
• write_query
• create_table
• list_databases
• list_schemas
• list_tables
• describe_table
• append_insight

Tested with

Claude Desktop

Notes

A Python server that integrates Snowflake with the Model Context Protocol (MCP), enabling read operations and optional write operations alongside insight tracking. It allows AI agents to query and update Snowflake data through a standardized interface.

183 stars on GitHub. Last updated 2025-10-07. Licensed GPL-3.0.

Use cases

• Connect AI assistants to query Snowflake databases for analytics and reporting
• Enable AI-driven data ingestion or record updates via write operations
• Track usage insights and query patterns across MCP-based tools

Pros

• Open source with 183 GitHub stars, active community
• Supports both read and optional write operations for flexibility
• Lightweight Python implementation easy to deploy and extend

Cons

• Limited to the Model Context Protocol, not a full Snowflake connector
• Write operations are optional and may require careful configuration
• Relies on Snowflake credentials and network setup beyond the tool itself

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.