Server 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 |
Schema
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 |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read_query | Execute a SELECT query or commands that return a ResultSet |
| write_query | Execute a DDL/DML or other StarRocks command that do not have a ResultSet |
| query_and_plotly_chart | using sql |
| table_overview | Get an overview of a specific table: columns, sample rows (up to 5), and total row count. Uses cache unless refresh=true |
| db_overview | Get an overview (columns, sample rows, row count) for ALL tables in a database. Uses cache unless refresh=True |
| analyze_query | Analyze query via profile |