StarRocks MCP Server
OfficialServer Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| STARROCKS_DB | No | Default database to use if not specified in tool arguments or resource URIs | |
| STARROCKS_URL | No | A connection URL string that contains all connection parameters in a single variable. Format: [<schema>://]user:password@host:port/database | |
| STARROCKS_HOST | No | Hostname or IP address of the StarRocks FE service | localhost |
| STARROCKS_PORT | No | MySQL protocol port of the StarRocks FE service | 9030 |
| STARROCKS_USER | No | StarRocks username | root |
| MCP_TRANSPORT_MODE | No | Communication mode that specifies how the MCP Server exposes its services | stdio |
| STARROCKS_PASSWORD | No | StarRocks password | |
| STARROCKS_OVERVIEW_LIMIT | No | An approximate character limit for the total text generated by overview tools | 20000 |
| STARROCKS_MYSQL_AUTH_PLUGIN | No | Specifies the authentication plugin to use when connecting to the StarRocks FE service |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_queryC | Execute a SELECT query or commands that return a ResultSet |
| write_queryA | Execute a DDL/DML or other StarRocks command that do not have a ResultSet |
| analyze_queryC | Analyze a query and get analyze result using query profile |
| collect_query_dump_and_profileC | Run a query to get it's query dump and profile, output very large, need special tools to do further processing |
| query_and_plotly_chartC | using sql |
| table_overviewA | Get an overview of a specific table: columns, sample rows (up to 3), and total row count. Uses cache unless refresh=true |
| db_summaryA | Quickly get summary of a database with tables' schema and size information |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| All Databases | List all databases in StarRocks |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/StarRocks/mcp-server-starrocks'
If you have feedback or need assistance with the MCP directory API, please join our Discord server