mcp-server-starrocks MCP server

StarRocks MCP (Model Context Protocol) Server

What mcp-server-starrocks does

Summarised from the project README; check the repository for the latest details.

Features

• Direct SQL Execution: Run `SELECT` queries (`readquery`) and DDL/DML commands (`writequery`).
• 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 (`tableoverview`) or entire databases (`dboverview`), including column definitions, row counts, and sample data.
• Data Visualization: Execute a query and generate a Plotly chart directly from the results (`queryandplotlychart`).
• Intelligent Caching: Table and database overviews are cached in memory to speed up repeated requests. Cache can be bypassed when needed.

Tools exposed (8)

• read_query
• write_query
• analyze_query
• top_hot_tables
• top_bad_tables
• query_and_plotly_chart
• table_overview
• db_overview

Requirements

• Python 3.11 or newer.
• A reachable StarRocks cluster (FE service). By default the server connects to `localhost:9030` over the MySQL protocol.

How to install mcp-server-starrocks

Listed on Socketlist – add this badge to your README:

Badge markdown[](https://socketlist.pages.dev/s/starrocks-mcp-server-starrocks/)

Maintain this project? Get it featured for free during launch →

Compare with codebase-memory-mcp →

Related Databases MCP servers