StarRocks
FreeStarRocks 官方集成，与 StarRocks 数据库交互。
FreeFree tier
About StarRocks
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases. It allows for direct SQL execution (SELECT, DDL/DML), database exploration (listing databases, tables, schemas), access to internal system metrics via the proc:// resource path, detailed table and database overviews with column definitions, row counts, and sample data, and data visualization by generating Plotly charts from query results. It features intelligent caching for repeated requests and flexible configuration via environment variables. The server is designed to be launched by an MCP host using uv, and requires Python 3.11+ and a reachable StarRocks cluster.
Key Features
Direct SQL Execution: Run SELECT queries (read_query) and DDL/DML commands (write_query).
Database Exploration: List databases and tables, retrieve table schemas via 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.
Pros & Cons
Pros
- Seamless integration with AI assistants through the Model Context Protocol
- Supports both read and write SQL operations
- Provides rich database metadata and system information without complex setup
- Caching reduces latency for repeated queries
- Open source and free to use
- Easy to deploy with uv and no manual pip install needed
Cons
- Requires a running StarRocks cluster (FE service) – not standalone
- Prerequisites include Python 3.11+ and the uv package manager
- Limited to StarRocks databases only
- Configuration and launch require familiarity with MCP host setup
Best For
AI-powered database querying and analysisNatural language to SQL workflows via MCP hostsAutomated database schema exploration and documentationData visualization and reporting from StarRocksIntegration with AI coding assistants for database-backed applications
FAQ
What is StarRocks MCP Server?
It is an official MCP server that acts as a bridge between AI assistants and StarRocks databases, enabling SQL execution, database exploration, and data visualization.
How do I install and run it?
Install uv (a Python package manager), then run: uv run --with mcp-server-starrocks mcp-server-starrocks --help. The server is typically launched via an MCP host.
What are the prerequisites?
Python 3.11 or newer, a reachable StarRocks cluster (default localhost:9030 via MySQL protocol), and the uv package manager.
Does it support write operations?
Yes, the write_query tool allows executing DDL and DML commands.