StarRocks Official MCP Server
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases. It allows for direct SQL execution, database exploration, data visualization via charts, and retrieving detailed schema/data overviews without requiring complex client-side setup.
Features
- Direct SQL Execution: Run
SELECTqueries (read_query) and DDL/DML commands (write_query). - 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 (
table_overview) or entire databases (db_overview), including column definitions, row counts, and sample data. - Data Visualization: Execute a query and generate a Plotly chart directly from the results (
query_and_plotly_chart). - Intelligent Caching: Table and database overviews are cached in memory to speed up repeated requests. Cache can be bypassed when needed.
- Flexible Configuration: Set connection details and behavior via environment variables.
