StarRocks/mcp-server-starrocks
If you are the rightful owner of mcp-server-starrocks and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The StarRocks Official MCP Server facilitates seamless interaction between AI assistants and StarRocks databases, enabling SQL execution, data exploration, and visualization.
Tools
Functions exposed to the LLM to take actions
read_query
Execute a SELECT query or commands that return a ResultSet
write_query
Execute a DDL/DML or other StarRocks command that do not have a ResultSet
query_and_plotly_chart
using sql query to extract data from database, then using python plotly_expr to generate a chart for UI to display
table_overview
Get an overview of a specific table: columns, sample rows (up to 5), and total row count. Uses cache unless refresh=true
db_overview
Get an overview (columns, sample rows, row count) for ALL tables in a database. Uses cache unless refresh=True
analyze_query
Analyze query via profile
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client
All Databases
URI: starrocks:///databases
MIME: text/plain
List all databases in StarRocks
