mcp-server-starrocks

概述

StarRocks MCP 服务器通过模型上下文协议提供全面的数据库连接能力。它允许 AI 助手直接执行 SQL 查询（包括读写操作）、探索数据库架构、获取表概述并使用 Plotly 生成数据可视化。该服务器支持多种传输模式，包括 stdio 和 HTTP，并带有智能缓存机制用于频繁访问的数据。配置方式灵活，支持单独的环境变量或连接 URL，并可选 macOS Keychain 集成以实现安全密码管理。

试试问 AI

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

• read_query

  Execute a SELECT query or other commands that return a ResultSet.

  试试:Show me all users from the customers table试试:List the top 10 products by sales试试:Describe the structure of the orders table
• write_query

  Execute DDL or DML commands that don't return a ResultSet.

  试试:Create a new table called user_activity试试:Insert new records into the products table试试:Drop the temporary_orders table
• analyze_query

  Analyze a query and get analyze results using query profile or explain analyze.

  试试:Analyze the performance of the slow sales report query试试:Show me the execution plan for this complex join query试试:Get the profile for query ID abc123
• query_and_plotly_chart

  Execute a SQL query and generate a Plotly chart from the results.

  试试:Create a bar chart showing monthly revenue试试:Plot the distribution of customer ages试试:Show a scatter plot of price vs rating for products
• table_overview

  Get an overview of a specific table including columns, row count, and sample rows.

  试试:Show me an overview of the customers table试试:Describe the structure and sample data from the orders table试试:What columns are in the products table?
• db_overview

  Get an overview of all tables within a specified database.

  试试:Show me all tables in the sales database试试:What tables are available in the analytics database?试试:List all tables and their basic structure

可对比工具

安装

uv add mcp-server-starrocks

{
  "mcpServers": {
    "mcp-server-starrocks": {
      "url": "http://localhost:8000/mcp"
    }
  }
}

uv run mcp-server-starrocks --mode streamable-http --port 8000

FAQ

如何连接到需要密码保护的 StarRocks 数据库？

可以使用 STARROCKS_URL 环境变量，格式为 'user:password@host:port/database'，或者使用 STARROCKS_PASSWORD_KEYCHAIN_SERVICE 将密码存储在 macOS Keychain 中。

我可以通过此 MCP 服务器执行写操作吗？

是的，服务器支持 write_query 用于执行 DDL（CREATE、ALTER、DROP）和 DML（INSERT、UPDATE、DELETE）操作来修改数据库。

mcp-server-starrocks 对比