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_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 |
| STARROCKS_PASSWORD | No | StarRocks password | |
| STARROCKS_OVERVIEW_LIMIT | No | An approximate character limit for the total text generated by overview tools when fetching data to populate the cache | 20000 |
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 an 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. |