StarRocks MCP Server
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 | Connection URL containing all connection parameters in one variable. Format: [<schema>://]user:password@host:port/database. Takes precedence over individual STARROCKS_HOST, STARROCKS_PORT, STARROCKS_USER, STARROCKS_PASSWORD, and STARROCKS_DB variables. | |
| 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_SSL_CA | No | Path to the CA certificate (PEM) used to verify the StarRocks server certificate. | |
| STARROCKS_SSL_KEY | No | Path to the client private key (PEM) for mutual TLS. | |
| MCP_TRANSPORT_MODE | No | MCP transport mode. Available options: stdio, streamable-http, and deprecated sse. | stdio |
| STARROCKS_PASSWORD | No | StarRocks password. Used when no password is embedded in STARROCKS_URL. Precedence: STARROCKS_URL password, then STARROCKS_PASSWORD, then STARROCKS_PASSWORD_FILE, then macOS Keychain. | |
| STARROCKS_SSL_CERT | No | Path to the client certificate (PEM) for mutual TLS. | |
| STARROCKS_SSL_DISABLED | No | Set to true to force-disable TLS. Overrides all other SSL settings. | false |
| STARROCKS_TLS_VERSIONS | No | Comma-separated list of allowed TLS versions, for example TLSv1.2,TLSv1.3. | |
| STARROCKS_PASSWORD_FILE | No | Path to a UTF-8 text file containing the StarRocks password. Used when no explicit password is provided via STARROCKS_PASSWORD or STARROCKS_URL. | |
| STARROCKS_QUERY_TIMEOUT | No | Number of seconds to wait for query results before giving up. Unset by default, meaning wait indefinitely. | |
| STARROCKS_MCP_OUTPUT_DIR | No | Directory used by read_query when its output_file argument is a relative path. | ~/.mcp-server-starrocks/output/ |
| STARROCKS_OVERVIEW_LIMIT | No | Approximate character limit for total text generated by overview tools when populating the cache. | 20000 |
| STARROCKS_SSL_VERIFY_CERT | No | Set to true to verify the server certificate against the CA. | false |
| STARROCKS_CHART_OUTPUT_DIR | No | Directory where query_and_plotly_chart writes interactive HTML charts. Defaults to the system temp directory. | |
| STARROCKS_MYSQL_AUTH_PLUGIN | No | Authentication plugin to use when connecting to StarRocks FE, for example mysql_clear_password. | |
| STARROCKS_SSL_VERIFY_IDENTITY | No | Set to true to verify that the server hostname matches the certificate. | false |
| STARROCKS_CHART_DEFAULT_FORMAT | No | Default output format for query_and_plotly_chart when the format argument is omitted. One of json, png, jpeg, or html. | jpeg |
| STARROCKS_CHART_INCLUDE_PLOTLYJS | No | Controls how plotly.js is bundled into HTML charts. Accepted values include cdn, inline/true, directory, and false. | cdn |
| STARROCKS_FE_ARROW_FLIGHT_SQL_PORT | No | Arrow Flight SQL port of the StarRocks FE service. When set, the server uses Arrow Flight SQL via ADBC instead of the standard MySQL protocol. | |
| STARROCKS_PASSWORD_KEYCHAIN_ACCOUNT | No | macOS Keychain generic password account name. Defaults to the resolved StarRocks user. | |
| STARROCKS_PASSWORD_KEYCHAIN_SERVICE | No | macOS Keychain generic password service name used to read the StarRocks password when no explicit password or password file is configured. | |
| STARROCKS_FE_ARROW_FLIGHT_SQL_USE_TLS | No | Set to true to use grpc+tls:// instead of plaintext grpc:// for the Arrow Flight SQL connection. | false |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityNo data
ResponsivenessSyncing