MCP Server for Snowflake
MCP Server for connecting to Snowflake with read-only questions
Overview
What is MCP Server for Snowflake?
MCP Server for Snowflake is a Model Context Protocol (MCP) server designed for performing read-only operations against Snowflake databases, allowing secure querying of data without modifying any information.
How to use MCP Server for Snowflake?
To use the MCP Server, clone the repository, install the package, and configure your Snowflake credentials in a .env file. You can then run the server and connect it to Claude Desktop or any compatible MCP client.
Key features of MCP Server for Snowflake?
- Flexible authentication methods (service account with private key or external browser)
- Connection pooling with automatic refresh
- Support for multiple SQL statement types (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
- Read-only operations with security checks
- Integration with Claude Desktop for easy querying
Use cases of MCP Server for Snowflake?
- Listing all databases and views in a Snowflake account.
- Describing the structure of specific views.
- Executing custom read-only SQL queries.
- Comparing data from different views across databases.
FAQ from MCP Server for Snowflake?
- Can I modify data using this server?
No, the server enforces read-only operations to ensure data integrity.
- What authentication methods are supported?
The server supports both private key authentication and external browser authentication.
- Is there a limit on the number of queries I can run?
There is no explicit limit, but the server automatically adds LIMIT clauses to prevent large result sets.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
ChatWiseThe second fastest AI chatbot™
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
CursorThe AI Code Editor
Tavily Mcp
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
DeepChatYour AI Partner on Desktop
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
Serper MCP ServerA Serper MCP Server
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
WindsurfThe new purpose-built IDE to harness magic
Playwright McpPlaywright MCP server
Amap Maps高德地图官方 MCP Server
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.