Same collection group
ClickHouse MCP
Run analytical SQL queries and inspect ClickHouse through the publisher’s MCP server.
MCPOfficial publisherMCPNewly listed 2026-10-14
StarRocks MCP
by StarRocks · StarRocks/mcp-server-starrocks
Explore StarRocks databases, run SQL, inspect query performance, and turn analytical query results into charts.
Install from the author’s instructions
Before connecting
- Install uv and provide access to a StarRocks FE MySQL endpoint.
- Replace the example STARROCKS_URL with the user, password, host, port and database for your own instance.
MCP client · published package and connection URL
{
"mcpServers": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-server-starrocks",
"mcp-server-starrocks"
],
"env": {
"STARROCKS_URL": "root:password@localhost:9030/my_database"
}
}
}
}Sources: Author README · Checked 2026-10-14.
The connection URL in the README is an example. The server includes write_query; choose the database account and permissions deliberately.
Sources: Author README · Checked 2026-10-14.
Tools and capabilities
| Capability | What it does |
|---|---|
| read_query | Execute SELECT queries and optionally export large results to a file. |
| table_overview | Summarize a table’s schema, row count and sample data. |
| analyze_query | Inspect query profiles or EXPLAIN ANALYZE results. |
| write_query | Run DDL and DML with the connected database account’s permissions. |
Sources: Author README · Checked 2026-10-14.
Workflow examples
Suggested prompts for your own client. These are examples, not recorded tool executions.
Prompt 1
Summarize the schema of my selected StarRocks table and propose a SELECT query for a weekly revenue report.Prompt 2
Analyze a slow query I provide, showing the profile or EXPLAIN evidence behind each performance suggestion.Sources and verification
Author README, linked first-party setup instructions and public repository metadata reviewed on 2026-10-14. No third-party package was installed, no MCP server was executed, and no hosted service was connected.
Recent activity refers to the repository push timestamp. It does not establish the product’s original release date. Stars are a dated snapshot of the entire repository.
- GitHub repository metadataVerified 2026-10-14
- Author READMEVerified 2026-10-14