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)

よくある質問

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.