StarRocks
About
Interact with [StarRocks](https://www.starrocks.io/)
Details
- Author
- StarRocks
- GitHub stars
- 179
- Downloads
- 603
- Categories
- Developer Tools, Database, Other
Jump to
- Direct SQL execution: read_query (SELECT) and write_query (DDL/DML).
- Database exploration via starrocks:// resources (list databases, tables, schemas).
- System information access through proc:// resource path.
- Detailed overviews: table_overview and db_overview with row counts, samples.
- Data visualization: query_and_plotly_chart generates Plotly charts from query results.
- Intelligent in‑memory caching of table and database overviews (bypassable).
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
StarRocksCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install uv (Python package manager) and configure an MCP host (e.g., Claude Desktop) to launch the server. Connection is set via environment variables (STARROCKS_URL or individual vars like STARROCKS_HOST, STARROCKS_PORT, etc.) or a Streamable HTTP endpoint. Run with uv run mcp-server-starrocks and optional flags like --mode stdio or --mode streamable-http --port 8000.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"starrocks": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-server-starrocks",
"mcp-server-starrocks",
"--help"
]
}
}
}
}McpServers
{
"mcp-server-starrocks": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-server-starrocks",
"mcp-server-starrocks",
"--help"
]
}
}StarRocks Official MCP Server
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases. It allows for direct SQL execution, database exploration, data visualization via charts, and retrieving detailed schema/data overviews without requiring complex client-side setup.
<a href="https://glama.ai/mcp/servers/@StarRocks/mcp-server-starrocks">
</a>
Features
- Direct SQL Execution: Run SELECT queries (read_query) and DDL/DML commands (write_query).
- Database Exploration: List databases and tables, retrieve table schemas (starrocks:// resources).
- System Information: Access internal StarRocks metrics and states via the proc:// resource path.
- Detailed Overviews: Get comprehensive summaries of tables (table_overview) or entire databases (db_overview), including column definitions, row counts, and sample data.
- Data Visualization: Execute a query and generate a Plotly chart directly from the results (query_and_plotly_chart).
- Intelligent Caching: Table and database overviews are cached in memory to speed up repeated requests. Cache can be bypassed when needed.
- Flexible Configuration: Set connection details and behavior via environment variables.
Prerequisites
- Python 3.11 or newer.
- A reachable StarRocks cluster (FE service). By default the server connects to localhost:9030 over the MySQL protocol.
- uv — a fast Python package and project manager (a modern replacement for pip + virtualenv) from Astral. This project uses uv to resolve dependencies, create the virtual environment, and launch the server. The uv run commands throughout this README automatically create an isolated environment and install the required dependencies on first use, so no manual pip install step is needed.
Installing uv
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
