MCP Snowflake Reader

MCP雪花阅读器

英语 | 韩语

](https://smithery.ai/server/@fnf-deepHeading/mcp-snowflake-reader)

英语

Snowflake数据库的只读MCP服务器。此服务器通过MCP协议提供对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）中：

码头工人

{
  "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",
        "{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
      ]
    }
  }
}

通过Smithery安装

通过以下方式自动安装克劳德桌面版雪花阅读器 史密瑟里:

npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude

局限性

• 只允许只读操作
• 表名只能包含字母数字字符、下划线和点
• 禁止使用以下SQL关键字：

- 插入 - 更新 - 删除 - 丢弃 - 截断 - 修改 - 创建 - 授予 - 撤销 - 提交 - 回滚

许可证

此项目根据MIT许可证获得许可-请参阅 许可证 文件以获取详细信息。

韩语

从Snowflake数据库中读取表的微服务控制协议（MCP）服务器。

主要功能

• 只读访问：安全的只读访问Snowflake数据库

设置

关于Snowflake连接

Snowflake连接信息以以下格式提供：

{
  "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）的配置文件中添加以下设置：

码头工人

{
  "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",
        "{\"account\":\"your-account\",\"user\":\"your-user\",\"password\":\"your-password\",\"warehouse\":\"your-warehouse\",\"database\":\"your-database\",\"schema\":\"your-schema\",\"role\":\"your-role\"}"
      ]
    }
  }
}

使用Smithery安装

史密瑟里通过Claude Desktop自动安装Snowflake Reader：

npx -y @smithery/cli install @fnf-deepHeading/mcp-snowflake-reader --client claude

限制

• 只允许只读操作
• 表名只允许字母数字、参考底数和点
• 禁止以下SQL关键字：

- 插入 - 更新 - 删除 - 丢弃 - 截断 - 修改 - 创建 - 授予 - 撤销 - 提交 - 回滚

许可证

此项目符合MIT许可证。有关详细信息，请访问 许可证 请参考文件。