StarRocks MCP Server
by Medina959
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. If set, the connection will attempt to USE this database. Defaults to empty (no default database). | |
| STARROCKS_URL | No | A connection URL string that contains all connection parameters in a single variable. Format: [<schema>://]user:password@host:port/database. The schema part is optional. When set, it takes precedence over STARROCKS_HOST, STARROCKS_PORT, STARROCKS_USER, STARROCKS_PASSWORD, and STARROCKS_DB. Examples: root:mypass@localhost:9030/test_db, mysql://admin:secret@db.example.com:9030/production, starrocks://user:pass@192.168.1.100:9030/analytics | |
| 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. Also used as the TLS root certificate for Arrow Flight SQL when STARROCKS_FE_ARROW_FLIGHT_SQL_USE_TLS is enabled. | |
| STARROCKS_SSL_KEY | No | Path to the client private key (PEM) for mutual TLS (mTLS). | |
| MCP_TRANSPORT_MODE | No | Communication mode that specifies how the MCP Server exposes its services. Available options: stdio (default), streamable-http, and sse (deprecated, not recommended). | stdio |
| STARROCKS_PASSWORD | No | StarRocks password. Defaults to empty string. | |
| STARROCKS_SSL_CERT | No | Path to the client certificate (PEM) for mutual TLS (mTLS). | |
| 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, e.g. TLSv1.2,TLSv1.3. | |
| STARROCKS_PASSWORD_FILE | No | Path to a UTF-8 text file containing the password. Useful with file-based secret injection such as systemd credentials. One trailing newline is ignored. Only used when no explicit password is provided via STARROCKS_PASSWORD or STARROCKS_URL. | |
| STARROCKS_QUERY_TIMEOUT | No | Number of seconds to wait for a query's results before giving up, as an integer. Unset by default, which waits indefinitely. | |
| STARROCKS_MCP_OUTPUT_DIR | No | Directory used by read_query when its output_file argument is a relative path. The directory is created on demand. Absolute paths (including ~-prefixed paths) bypass this setting. | ~/.mcp-server-starrocks/output/ |
| STARROCKS_OVERVIEW_LIMIT | No | An approximate character limit for the total text generated by overview tools (table_overview, db_overview) when fetching data to populate 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 (when format="html"). Defaults to the system temp directory. The directory is created on demand. | |
| STARROCKS_MYSQL_AUTH_PLUGIN | No | Specifies the authentication plugin to use when connecting to the StarRocks FE service. For example, set to mysql_clear_password if your StarRocks deployment requires clear text password authentication. Only set this if your environment specifically requires it. | |
| STARROCKS_SSL_VERIFY_IDENTITY | No | Set to true to also 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 (default), or html. Invalid values fall back to jpeg with a warning. | jpeg |
| STARROCKS_CHART_INCLUDE_PLOTLYJS | No | Controls how plotly.js is bundled into HTML charts. cdn (default) keeps files small but needs network access when viewing; inline/true embeds the full library for offline use; directory and false are also accepted. | cdn |
| STARROCKS_FE_ARROW_FLIGHT_SQL_PORT | No | Arrow Flight SQL port of the StarRocks FE service. When set, the server connects using the high-performance Arrow Flight SQL protocol (via ADBC drivers) instead of the standard MySQL protocol. Leave unset to use the default MySQL connection. | |
| STARROCKS_PASSWORD_KEYCHAIN_ACCOUNT | No | (macOS only) Generic password account name to use when reading the password from Keychain. Defaults to the resolved StarRocks user. | |
| STARROCKS_PASSWORD_KEYCHAIN_SERVICE | No | (macOS only) Generic password service name to use when reading the password from Keychain. Only used when no explicit password or STARROCKS_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. When enabled, STARROCKS_SSL_CA is used as the TLS root certificate and STARROCKS_SSL_VERIFY_CERT=false (default) skips server certificate verification. | 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
ActivityActive
ResponsivenessResponsive