广告合作
MCP.so
登录

MCP Snowflake Service

@datawiz168

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

datawiz168

关于 MCP Snowflake Service

MCP server implementation for Snowflake integration

MCP Snowflake Service 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-snowflake-service": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@datawiz168/mcp-service-snowflake",
        "--client",
        "claude"
      ]
    }
  }
}

MCP Snowflake Service 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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)

常见问题

1

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`.

2

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`.

3

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.

4

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.

5

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.

6

Is Mcp Snowflake Service open source? What license does it use?

Yes, it is licensed under the MIT License.

评论

数据库 分类下的更多 MCP 服务器

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作