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 efficient data management and visualization.
The StarRocks Official MCP Server is designed to act as a bridge between AI assistants and StarRocks databases, providing a streamlined interface for executing SQL commands, exploring databases, and visualizing data. This server allows users to perform direct SQL execution, retrieve detailed schema and data overviews, and generate data visualizations without the need for complex client-side setups. It supports intelligent caching to enhance performance and offers flexible configuration options through environment variables. The server is typically run via an MCP host, and it can be configured to connect to specific StarRocks database instances, making it a versatile tool for database management and data analysis.
Features
- Direct SQL Execution: Run SELECT queries and DDL/DML commands.
- Database Exploration: List databases and tables, retrieve table schemas.
- System Information: Access internal StarRocks metrics and states.
- Data Visualization: Generate Plotly charts from query results.
- Intelligent Caching: Speed up repeated requests with in-memory caching.
Tools
read_query
Execute a SELECT query or other commands that return a ResultSet.
write_query
Execute a DDL, DML, or other StarRocks command that does not return a ResultSet.
query_and_plotly_chart
Execute a SQL query and generate a Plotly chart from the results.
table_overview
Get an overview of a specific table, including columns, row count, and sample rows.
db_overview
Get an overview for all tables within a specified database.