yannbrrd/simple_snowflake_mcp

Overview

A lightweight Python-based MCP server for Snowflake that operates behind corporate proxies. It supports both read and optional write operations, enabling AI agents and tools to interact with Snowflake databases through the Model Context Protocol.

Best for

Best for
Developers needing a simple, proxy-compatible Snowflake MCP server for basic read/write interactions

Use cases

• Connect AI assistants to Snowflake databases for read queries
• Enable write operations from agent workflows
• Deploy a Snowflake MCP server in restricted network environments with proxy support

How to use

Install

npx @modelcontextprotocol/inspector uv run simple-snowflake-mcp

Tools exposed

• execute-snowflake-sql
• execute-query
• get-connection-info
• list-snowflake-warehouses
• list-databases
• export-schema
• add-note

Tested with

Claude Desktop, VS Code

Notes

A lightweight Python-based MCP server for Snowflake that operates behind corporate proxies. It supports both read and optional write operations, enabling AI agents and tools to interact with Snowflake databases through the Model Context Protocol.

7 stars on GitHub. Last updated 2026-04-21. Licensed MIT.

Use cases

• Connect AI assistants to Snowflake databases for read queries
• Enable write operations from agent workflows
• Deploy a Snowflake MCP server in restricted network environments with proxy support

Pros

• Works behind corporate proxies without configuration hacks
• Lightweight Python implementation easy to deploy and modify
• Supports both read and write operations when enabled

Cons

• Low community adoption (7 stars) suggests limited testing and support
• May lack advanced features like connection pooling or query optimization
• Minimal documentation beyond the GitHub description

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