MCP Snowflake Reader

Name: MCP Snowflake Reader
Author: fnf-deepHeading

@fnf-deepHeading

MCP Snowflake Reader について

A Model Context Protocol (MCP) server that provides secure, read-only access to Snowflake databases. Allows LLMs to safely query tables and describe schemas without write permissions. Built with Python and the official Snowflake SDK.

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

fnf-deepHeading

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mcp-snowflake-reader": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp-snowflake-reader",
        "--connection",
        "{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP Snowflake Reader?

MCP Snowflake Reader is a read-only MCP server that provides secure, read-only access to Snowflake databases through the MCP protocol.

How to use MCP Snowflake Reader?

Configure your MCP client (Cursor AI or Claude) with a Docker or uvx command, passing a JSON connection string with your Snowflake account, user, password, warehouse, database, schema, and role. Alternatively, install automatically via Smithery.

Key features of MCP Snowflake Reader

Read-only access to Snowflake databases
Connection via JSON configuration string
Supports Docker and uvx runtimes
Installable via Smithery for Claude Desktop
MIT licensed

Use cases of MCP Snowflake Reader

Query Snowflake data without write risk from MCP clients
Provide safe, read-only database access to AI assistants
Integrate Snowflake analytics into Cursor AI or Claude workflows
Automate table inspection and reporting in a controlled environment

FAQ from MCP Snowflake Reader

Can MCP Snowflake Reader write or modify data?

No, only read-only operations are allowed. SQL keywords like INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, GRANT, REVOKE, COMMIT, and ROLLBACK are explicitly prohibited.