Loading connector details…
StarRocks MCP Server
MCPOfficialOpen SourceApache-2.066.3
by StarRocks • Data & Databases
A bridge that lets AI assistants run SQL, explore schemas, and visualize data from StarRocks databases without client-side setup.
Example Use Cases
- 1
Execute SELECT or DDL/DML statements against StarRocks and receive formatted results or confirmations.
- 2
Inspect database/schema metadata, list databases/tables, and retrieve table schemas or internal proc information.
- 3
Produce data visualizations from query results (Plotly charts) for use in UIs or reports.
Description
StarRocks MCP Server exposes tools and resources to execute read/write SQL, analyze queries, fetch table and database overviews, and generate Plotly charts from query results. It supports direct resource URIs (starrocks://, proc://), in-memory caching for overviews, multiple transport modes (including streamable HTTP), and flexible configuration via environment variables or a connection URL. The server is designed to simplify integration of AI agents with StarRocks clusters by providing ready-made APIs for common database workflows and lightweight deployment options.
Capabilities(8 total)
Tools (7)
read_query
Execute a SELECT query or commands that return a ResultSet
query:string*db:any
write_query
Execute a DDL/DML or other StarRocks command that do not have a ResultSet
query:string*db:any
analyze_query
Analyze a query and get analyze result using query profile
uuid:anysql:anydb:any
collect_query_dump_and_profile
Run a query to get it's query dump and profile, output very large, need special tools to do further processing
query:string*db:any
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
query:string*plotly_expr:string*format:stringdb:any
Resources (1)
All Databases
List all databases in StarRocks
URI: starrocks:///databasesMIME: text/plain
Quick Actions
Security
Scanned 3 month(s) agoRisk Level
MINIMAL
Read-only data retrieval, no side effects
Trust Score
C56/100
6/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities7 Tools / 0 Prompts / 1 Resources
OwnerStarRocks
CategoryData & Databases
DependenciesStandalone
Tags
DatabaseSQLVisualizationMetadata