StarRocks/mcp-server-starrocks

Run the published package via uv
uv run --with mcp-server-starrocks mcp-server-starrocks

Usage

• •Launch in streamable-http or stdio mode, configure the connection via env vars
• •Run read_query/write_query for SQL, table_overview/db_overview for schema insights, query_and_plotly_chart for charts

Key features

• ✓read_query and write_query for SELECT and write commands
• ✓starrocks:// database exploration resources and schema templates
• ✓proc:// resource exposing internal StarRocks metrics
• ✓table_overview and db_overview with in-memory caching
• ✓query_and_plotly_chart generating Plotly charts from query results
• ✓analyze_query, top_hot_tables and top_bad_tables analytics tools
• ✓Transports: stdio, streamable-http and sse
• ✓macOS Keychain password support and TLS/SSL configuration

Best for

Connecting AI assistants to StarRocks for query analytics, exploration and charting

Caveats

• ⚠Requires a reachable StarRocks FE cluster
• ⚠SSE mode is deprecated and unmaintained
• ⚠Output files are written on the machine where the server runs