# StarRocks MCP Server — Streamable HTTP + Stdio

> StarRocks/mcp-server-starrocks is an MCP server for StarRocks (stdio+HTTP); verified 171★ and documents overview caps and output paths.

## Install

Merge the JSON below into your `.mcp.json`:

## Quick Use

```bash
uv run mcp-server-starrocks --mode streamable-http --host 0.0.0.0 --port 8080
uv run mcp-server-starrocks --mode stdio
STARROCKS_URL='root:@localhost:8000' uv run mcp-server-starrocks --test
```

## Intro

StarRocks/mcp-server-starrocks is an MCP server for StarRocks (stdio+HTTP); verified 171★ and documents overview caps and output paths.

**Best for:** Analytical teams who want an MCP bridge to StarRocks for schema overview and read queries from AI tools

**Works with:** MCP hosts (Claude Desktop/Cursor) via stdio, or remote clients via streamable HTTP/SSE; StarRocks URL/env vars

**Setup time:** 10-20 minutes

### Key facts (verified)

- GitHub: 171 stars · 54 forks · pushed 2026-05-07.
- License: Apache-2.0 · owner avatar + repo URL verified via GitHub API.
- README-backed entrypoint: `uv run mcp-server-starrocks --mode streamable-http --port 8000`.

## Main

- Start with `--test` to validate credentials/URL before wiring MCP host configs.

- Use `STARROCKS_OVERVIEW_LIMIT` to cap overview output and avoid huge schema dumps on large clusters.

- Control file outputs: `STARROCKS_MCP_OUTPUT_DIR` determines where relative output files land (docs note files are written where the MCP server runs).

### Source-backed notes

- README shows `uv run mcp-server-starrocks` examples for Streamable HTTP and stdio modes, plus a `--test` flag.
- Docs list `STARROCKS_OVERVIEW_LIMIT` (default 20000 chars) to cap overview tool output.
- Docs describe `STARROCKS_MCP_OUTPUT_DIR` for output files and warn outputs are written on the server machine.

### FAQ

- **Is this a StarRocks client or an MCP server?**: It’s an MCP server wrapper that exposes StarRocks access to MCP hosts/clients (per README).
- **Can it run remotely?**: Yes — README documents Streamable HTTP/SSE transports in addition to stdio.
- **How do I avoid huge outputs?**: Use `STARROCKS_OVERVIEW_LIMIT` and keep output files under `STARROCKS_MCP_OUTPUT_DIR`.

## Source & Thanks

> Source: https://github.com/StarRocks/mcp-server-starrocks
> License: Apache-2.0
> GitHub stars: 171 · forks: 54

---

<!-- ZH -->

## Quick Use

```bash
uv run mcp-server-starrocks --mode streamable-http --host 0.0.0.0 --port 8080
uv run mcp-server-starrocks --mode stdio
STARROCKS_URL='root:@localhost:8000' uv run mcp-server-starrocks --test
```

## Intro

StarRocks/mcp-server-starrocks 为 StarRocks 提供 MCP server，支持 stdio 与 Streamable HTTP；已验证 171★，并说明 overview 字符上限与输出目录控制等防护。

**Best for:** 需要从 AI 工具侧获取 schema 概览并执行查询的分析团队（StarRocks）

**Works with:** 本地 MCP host（stdio）或远程（Streamable HTTP/SSE）；通过 URL/环境变量配置 StarRocks 连接

**Setup time:** 10-20 minutes

### Key facts (verified)

- GitHub：171 stars · 54 forks；最近更新 2026-05-07。
- 许可证：Apache-2.0；作者头像与仓库链接均已通过 GitHub API 复核。
- README 中可对照的入口命令：`uv run mcp-server-starrocks --mode streamable-http --port 8000`。

## Main

- 先用 `--test` 验证连接 URL/凭据，再接入 MCP host 配置文件。

- 大库/大 schema 场景用 `STARROCKS_OVERVIEW_LIMIT` 限制 overview 输出，避免一次性 dump 过大内容。

- 涉及输出文件时要控路径：`STARROCKS_MCP_OUTPUT_DIR` 决定相对路径写入位置（文档提醒写入发生在 server 机器上）。

### Source-backed notes

- README 给出 `uv run mcp-server-starrocks` 的 Streamable HTTP / stdio 示例，并提供 `--test` 参数。
- 文档列出 `STARROCKS_OVERVIEW_LIMIT`（默认 20000 字符）用于限制 overview 工具输出。
- 文档解释 `STARROCKS_MCP_OUTPUT_DIR` 用于控制输出路径，并提醒写入发生在 server 机器上。

### FAQ

- **它是客户端还是 MCP server？**：是 MCP server：把 StarRocks 能力通过 MCP 暴露给 host/client（README 描述）。
- **能远程跑吗？**：能。README 覆盖 Streamable HTTP/SSE，以及本地 stdio。
- **如何避免输出太大？**：用 `STARROCKS_OVERVIEW_LIMIT`，并用 `STARROCKS_MCP_OUTPUT_DIR` 约束输出文件。

## Source & Thanks

> Source: https://github.com/StarRocks/mcp-server-starrocks
> License: Apache-2.0
> GitHub stars: 171 · forks: 54


---
Source: https://tokrepo.com/en/workflows/starrocks-mcp-server-streamable-http-stdio
Author: MCP Hub