StarRocks
JSON →Interact with StarRocks
Install
npx @modelcontextprotocol/inspector Tools · 6
- read_query Execute a SELECT query or other commands that return a ResultSet (e.g., SHOW, DESCRIBE). Optionally write the full result to a local file instead of returning it inline — useful for results too large to fit in the model context.
- write_query Execute a DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE), or other StarRocks command that does not return a ResultSet.
- analyze_query Analyze a query and get analyze result using query profile or explain analyze.
- query_and_plotly_chart Executes a SQL query, loads the results into a Pandas DataFrame, and generates a Plotly chart using a provided Python expression. Designed for visualization in supporting UIs.
- table_overview Get an overview of a specific table: columns (from DESCRIBE), total row count, and sample rows (LIMIT 3). Uses an in-memory cache unless refresh is true.
- db_overview Get an overview (columns, row count, sample rows) for all tables within a specified database. Uses the table-level cache for each table unless refresh is true.
Environment variables
STARROCKS_URLSTARROCKS_HOSTSTARROCKS_PORTTABLE_ID
Links
★ 172 GitHub stars