Mcp Snowflake Service
@datawiz168
About Mcp Snowflake Service
MCP server implementation for Snowflake integration
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-snowflake-service": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"@datawiz168/mcp-service-snowflake",
"--client",
"claude"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Mcp Snowflake Service?
Mcp Snowflake Service is a Model Context Protocol (MCP) server that provides Claude with secure access to Snowflake databases. It automatically manages the database connection lifecycle—connecting, reconnecting on timeout, and closing—and handles query execution, result processing, and error reporting.
How to use Mcp Snowflake Service?
Install via Smithery (npx -y @smithery/cli install @datawiz168/mcp-service-snowflake --client claude) or manually by cloning the repository and installing dependencies with pip install -r requirements.txt. Configure Snowflake credentials in a .env file and add the server to claude_desktop_config.json with the path to your Python interpreter and the server script. The server starts automatically with Claude Desktop; for development testing, run python server.py manually.
Key features of Mcp Snowflake Service
- Execute SQL queries on Snowflake databases
- Automatic connection lifecycle management (connect, reconnect, close)
- Robust error handling and result processing
- Secure database access via Snowflake user credentials
- Supports both read-only and write operations based on database user permissions
Use cases of Mcp Snowflake Service
- Query Snowflake data through Claude’s natural language interface
- Automate database reporting and analysis tasks
- Perform safe database operations with controlled permissions (e.g., assigning a read-only user for read queries)
FAQ from Mcp Snowflake Service
How do I install Mcp Snowflake Service?
You can install it automatically via Smithery or manually by cloning the repository, running pip install -r requirements.txt, and configuring the server in claude_desktop_config.json.
What configuration is required for Snowflake?
Create a .env file in the project root with SNOWFLAKE_USER, SNOWFLAKE_PASSWORD, SNOWFLAKE_ACCOUNT, SNOWFLAKE_DATABASE, and SNOWFLAKE_WAREHOUSE.
How does connection management work?
The server automatically initializes a connection on the first query, monitors connection state, handles timeouts, reconnects if lost, and properly closes connections when the server stops.
Can I restrict database access to read-only?
Yes. By assigning a Snowflake user with read‑only permissions, the server will only be able to execute read queries, ensuring precise access control.
What are the runtime dependencies?
Python is required. All dependencies are listed in requirements.txt and installed via pip install -r requirements.txt. The server communicates with Claude via the MCP protocol.
Is Mcp Snowflake Service open source? What license does it use?
Yes, it is licensed under the MIT License.
More Databases MCP servers
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
Sqlite
modelcontextprotocolModel Context Protocol Servers
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Database Gateway
centralmindUniversal MCP-Server for your Databases optimized for LLMs and AI-Agents.
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Comments