Back to MCP directory
publicPublicdnsLocal runtime

mcp-snowflake-reader

一个为Snowflake数据库提供只读访问的MCP服务器,通过安全协议实现数据查询功能

article

README

🚀 MCP 雪花阅读器

MCP 雪花阅读器是一个只读的 MCP 服务器,可通过 MCP 协议为您提供安全的方式来访问 Snowflake 数据库,保障数据访问的安全性。

🚀 快速开始

MCP 雪花阅读器是一个只读的 MCP 服务器,用于访问 Snowflake 数据库。此服务器通过 MCP 协议提供安全的只读访问到 Snowflake 数据库。

✨ 主要特性

  • 只读访问:提供安全的只读访问到 Snowflake 数据库,保障数据安全。

📦 安装指南

Snowflake 连接

Snowflake 的连接信息应以 JSON 格式的字符串形式提供,如下所示:

{
  "account": "your-account",
  "user": "your-user",
  "password": "your-password",
  "warehouse": "your-warehouse",
  "database": "your-database",
  "schema": "your-schema",
  "role": "your-role"
}

MCP 客户端配置

将以下配置添加到您的 MCP 客户端设置文件(例如 Cursor AI 或 Claude)中:

Docker

{
  "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\"}"
      ]
    }
  }
}

UVX

{
  "mcpServers": {
    "mcp-snowflake-reader": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-reader",
        "--connection"
      ]
    }
  }
}

English | 한국어

smithery 徽章

help

Runtime guide

cloud

Hosted runtime

Hosted servers run from a provider-managed environment. You usually connect the MCP client to the hosted endpoint or follow the provider's authorization flow, without keeping a local process alive

  1. Open provider connection page
  2. Authorize or copy endpoint
  3. Connect from your MCP client
terminal

Local runtime / other methods

Local servers run on your own machine or infrastructure. You normally copy the server_config into your MCP client, install the required package, and provide env variables from env_schema when needed

  1. Copy server_config
  2. Install required package
  3. Fill env variables and restart client