StarRocks MCP Server
by FilippoVerma
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| STARROCKS_DB | No | Optional default database. Defaults to empty (no default database). | |
| STARROCKS_URL | No | Optional connection URL containing all connection parameters. 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 | Optional hostname or IP address of the StarRocks FE service. Defaults to localhost. | localhost |
| STARROCKS_PORT | No | Optional MySQL protocol port of the StarRocks FE service. Defaults to 9030. | 9030 |
| STARROCKS_USER | No | Optional StarRocks username. Defaults to root. | root |
| STARROCKS_SSL_CA | No | Optional path to the CA certificate (PEM) used to verify the StarRocks server certificate. | |
| STARROCKS_SSL_KEY | No | Optional path to the client private key (PEM) for mutual TLS. | |
| MCP_TRANSPORT_MODE | No | Optional MCP transport mode. Available options are stdio (default), streamable-http, and deprecated sse. | stdio |
| STARROCKS_PASSWORD | No | Optional StarRocks password. Defaults to an empty string. | |
| STARROCKS_SSL_CERT | No | Optional path to the client certificate (PEM) for mutual TLS. | |
| STARROCKS_SSL_DISABLED | No | Optional; set to true to force-disable TLS. Overrides all other SSL settings. Defaults to false. | false |
| STARROCKS_TLS_VERSIONS | No | Optional comma-separated list of allowed TLS versions, e.g. TLSv1.2,TLSv1.3. | |
| STARROCKS_PASSWORD_FILE | No | Optional path to a UTF-8 text file containing the password. Used only when no explicit password is provided via STARROCKS_PASSWORD or STARROCKS_URL. | |
| STARROCKS_QUERY_TIMEOUT | No | Optional integer number of seconds to wait for query results before giving up. Unset by default, which waits indefinitely. | |
| STARROCKS_MCP_OUTPUT_DIR | No | Optional directory used by read_query for relative output_file paths. Defaults to ~/.mcp-server-starrocks/output/. | ~/.mcp-server-starrocks/output/ |
| STARROCKS_OVERVIEW_LIMIT | No | Optional approximate character limit for total text generated by overview tools. Defaults to 20000. | 20000 |
| STARROCKS_SSL_VERIFY_CERT | No | Optional; set to true to verify the server certificate against the CA. Defaults to false. | false |
| STARROCKS_CHART_OUTPUT_DIR | No | Optional directory where query_and_plotly_chart writes interactive HTML charts. Defaults to the system temp directory. | |
| STARROCKS_MYSQL_AUTH_PLUGIN | No | Optional authentication plugin to use when connecting to StarRocks FE, for example mysql_clear_password. | |
| STARROCKS_SSL_VERIFY_IDENTITY | No | Optional; set to true to verify that the server hostname matches the certificate. Defaults to false. | false |
| STARROCKS_CHART_DEFAULT_FORMAT | No | Optional default output format for query_and_plotly_chart when format is omitted. One of json, png, jpeg, or html. Defaults to jpeg. | jpeg |
| STARROCKS_CHART_INCLUDE_PLOTLYJS | No | Optional control for how plotly.js is bundled into HTML charts. Accepts cdn, inline, true, directory, or false. Defaults to cdn. | cdn |
| STARROCKS_FE_ARROW_FLIGHT_SQL_PORT | No | Optional Arrow Flight SQL port of the StarRocks FE service. When set, uses Arrow Flight SQL instead of the standard MySQL protocol. | |
| STARROCKS_PASSWORD_KEYCHAIN_ACCOUNT | No | Optional macOS Keychain generic password account name. Defaults to the resolved StarRocks user. | |
| STARROCKS_PASSWORD_KEYCHAIN_SERVICE | No | Optional macOS Keychain generic password service name. Used only when no explicit password or STARROCKS_PASSWORD_FILE is configured. | |
| STARROCKS_FE_ARROW_FLIGHT_SQL_USE_TLS | No | Optional; set to true to use grpc+tls:// instead of plaintext grpc:// for Arrow Flight SQL. When enabled, STARROCKS_SSL_CA is used as the TLS root certificate. |
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
ActivityActive
ResponsivenessNo issues