snowflake-mcp-server

概述

这个 MCP 服务器使 Claude 能够安全地查询 Snowflake 数据而无需修改信息。它支持多种认证方式，包括使用私钥的服务账户认证和外部浏览器认证。服务器实现了连接池和自动后台刷新功能，支持多种 SQL 语句类型（SELECT、SHOW、DESCRIBE、EXPLAIN、WITH），并具有安全检查以防止数据修改。提供了列出数据库、描述视图、执行查询和获取数据（带有适当的行限制以防止结果集过大）的工具。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• list_databases

  List all accessible Snowflake databases

  试试:Can you list all the databases in my Snowflake account?试试:Show me all available databases
• list_views

  List all views in a specified database and schema

  试试:List all views in the MARKETING database试试:What views are available in the SALES database?
• describe_view

  Get detailed information about a specific view including columns and SQL definition

  试试:Describe the structure of the CUSTOMER_ANALYTICS view in the SALES database试试:What are the columns in the REVENUE_BY_REGION view?
• query_view

  Query data from a view with an optional row limit

  试试:Show me sample data from the REVENUE_BY_REGION view in the FINANCE database试试:Query the top 10 records from the CUSTOMER_ANALYTICS view
• execute_query

  Execute custom read-only SQL queries with results formatted as markdown tables

  试试:Run this SQL query: SELECT customer_id, SUM(order_total) as total_spend FROM SALES.ORDERS GROUP BY customer_id ORDER BY total_spend DESC LIMIT 10试试:Query the MARKETING database to find the top 5 performing campaigns by conversion rate

可对比工具

安装

git clone https://github.com/dynamike/snowflake-mcp-server.git
cd snowflake-mcp-server

uv pip install -e .

"snowflake-mcp-server": {
  "command": "uv",
  "args": [
    "--directory",
    "/<path-to-code>/snowflake-mcp-server",
    "run",
    "snowflake-mcp-stdio"
  ]
}

FAQ

支持哪些 SQL 操作？

服务器支持 SELECT、SHOW、DESCRIBE、EXPLAIN 和 WITH 语句，具有安全检查以防止数据修改。

可用的认证方法有哪些？

支持两种方法：使用私钥的服务账户认证（用于非交互使用）和外部浏览器认证（用于交互式登录）。

snowflake-mcp-server 对比