orange-mcp-server-snowflake

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: - Execute SQL queries on Snowflake databases - Automatically handle database connection lifecycle (connect, reconnect on timeout, close) - Handle query results and errors - Perform database operations safely 此服务器实现了模型上下文协议，使 Claude 能够： - 在 Snowflake 数据库上执行 SQL 查询 - 自动管理数据库连接生命周期（连接创建、超时重连、连接关闭） - 处理查询结果和错误 - 安全地执行数据库操作 ## Installation / 安装 1. Clone this repository / 克隆此仓库 ```bash git clone https://github.com/datawiz168/mcp-snowflake-service.git ``` 2. Install dependencies / 安装依赖 ```bash pip install -r requirements.txt ``` ## Configuration / 配置说明 ### MCP Client Configuration Example / MCP 客户端配置示例 Add the following configuration to `claude_desktop_config.json` / 在 `claude_desktop_config.json` 中添加配置: ```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: ```json { "mcpServers": { "snowflake": { "command": "C:\\Users\\YourUsername\\anaconda3\\python.exe", "args": ["C:\\Path\\To\\mcp-snowflake\\server.py"] } } } ``` MacOS/Linux: ```json { "mcpServers": { "snowflake": { "command": "/usr/bin/python3", "args": ["/path/to/mcp-snowflake/server.py"] } } } ``` ### Snowflake Configu…