Snowflake MCP Server
Overview
What is Snowflake MCP Server?
The Snowflake MCP Server is a Model Context Protocol (MCP) server implementation that facilitates database interaction with Snowflake, allowing users to run SQL queries and interact with a memo of data insights.
How to use Snowflake MCP Server?
To use the Snowflake MCP Server, install it via Smithery and configure it in your Claude Desktop setup. You can execute SQL queries directly through the provided tools without needing to clone the repository.
Key features of Snowflake MCP Server?
- Execute SELECT, INSERT, UPDATE, and DELETE SQL queries.
- Create new tables in the database.
- Continuously updated memo resource for data insights.
- Tools for listing tables and describing table schemas.
Use cases of Snowflake MCP Server?
- Running complex SQL queries against Snowflake databases.
- Managing database schemas and structures.
- Aggregating and analyzing data insights dynamically.
FAQ from Snowflake MCP Server?
- Can I run any SQL query with this server?
Yes, you can run SELECT, INSERT, UPDATE, and DELETE queries as well as create tables.
- Is there a way to see the current tables in my database?
Yes, you can use the
list_tablestool to get a list of all tables in the database.
- How do I add new insights to the memo?
You can use the
append_insighttool to add new data insights, which will automatically update the memo resource.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
Tavily Mcp
ChatWiseThe second fastest AI chatbot™
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"
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.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
DeepChatYour AI Partner on Desktop
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.
Playwright McpPlaywright MCP server
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
CursorThe AI Code Editor
RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.
Amap Maps高德地图官方 MCP Server
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.
Serper MCP ServerA Serper MCP Server
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
WindsurfThe new purpose-built IDE to harness magic