MCP server implementation for Snowflake integration
{
"mcpServers": {
"snowflake": {
"args": [
"D:\\tools\\mcp-snowflake\\server.py"
],
"command": "C:\\Users\\K\\anaconda3\\envs\\regular310\\python.exe"
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / 一个为 Claude 提供 Snowflake 数据库访问能力的 MCP (模型上下文协议) 服务器。
Is it safe?
No known CVEs for @datawiz168/mcp-service-snowflake.
No authentication — any process on your machine can connect.
MIT. View license →
Is it maintained?
Last commit 352 days ago. 46 stars.
Will it work with my client?
Transport: stdio, http. Works with Claude Desktop, Cursor, Claude Code, and most MCP clients.
Run this in your terminal to verify the server starts. Then let us know if it worked — your result helps other developers.
npx -y '@datawiz168/mcp-service-snowflake' 2>&1 | head -1 && echo "✓ Server started successfully"
After testing, let us know if it worked:
No known vulnerabilities.
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Manage Supabase projects — databases, auth, storage, and edge functions
An official Qdrant Model Context Protocol (MCP) server implementation
Query and manage PostgreSQL databases directly from AI assistants
Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors
MCP Security Weekly
Get CVE alerts and security updates for Mcp Snowflake Service and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.
A Model Context Protocol (MCP) server that provides Claude access to Snowflake databases. / 一个为 Claude 提供 Snowflake 数据库访问能力的 MCP (模型上下文协议) 服务器。
This server implements the Model Context Protocol to allow Claude to:
此服务器实现了模型上下文协议,使 Claude 能够:
To install mcp-service-snowflake for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @datawiz168/mcp-service-snowflake --client claude
git clone https://github.com/datawiz168/mcp-snowflake-service.git
pip install -r requirements.txt
Add the following configuration to claude_desktop_config.json / 在 claude_desktop_config.json 中添加配置:
{
"mcpServers": {
"snowflake": {
"command": "C:\\Users\\K\\anaconda3\\envs\\regular310\\python.exe",
"args": ["D:\\tools\\mcp-snowflake\\server.py"]
}
}
}
Configuration parameters / 配置参数说明:
command: Full path to your Python interpreter. Please modify this according to your Python installation location. / Python 解释器的完整路径,请根据您的 Python 安装位置进行修改。args: Full path to the server script. Please modify this according to where you cloned the repository. / 服务器脚本的完整路径,请根据您克隆仓库的位置进行修改。Example paths for different operating systems / 不同操作系统的路径示例:
Windows:
{
"mcpServers": {
"snowflake": {
"command": "C:\\Users\\YourUsername\\anaconda3\\python.exe",
"args": ["C:\\Path\\To\\mcp-snowflake\\server.py"]
}
}
}
MacOS/Linux:
{
"mcpServers": {
"snowflake": {
"command": "/usr/bin/python3",
"args": ["/path/to/mcp-snowflake/server.py"]
}
}
}
Create a .env file in the project root directory and add the following configuration / 在项目根目录下创建 .env 文件,添加以下配置:
SNOWFLAKE_USER=your_username # Your username / 您的用户名
SNOWFLAKE_PASSWORD=your_password # Your password / 您的密码
SNOWFLAKE_ACCOUNT=NRB18479.US-WEST-2 # Example: NRB18479.US-WEST-2 / 示例: NRB18479.US-WEST-2
SNOWFLAKE_DATABASE=your_database # Your database / 您的数据库
SNOWFLAKE_WAREHOUSE=your_warehouse # Your warehouse / 您的数据仓库
The server provides automatic connection management features / 服务器提供以下自动连接管理功能:
Automatic connection initialization / 自动初始化连接
Connection maintenance / 连接维护
Connection cleanup / 连接清理
The server will start automatically with the Claude Desktop client. No manual startup is required. Once the server is running, Claude will be able to execute Snowflake queries. / 服务器会随 Claude Desktop 客户端自动启动,无需手动运行。服务器启动后,Claude 将能够执行 Snowflake 查询。
For development testing, you can start the server manually using / 如果需要单独启动服务器进行测试,可以使用以下命令:
python server.py
Note: Manual server startup is not needed for normal use. The Claude Desktop client will automatica