Skip to main content
Glama

StarRocks MCP Server

Official

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
STARROCKS_DBNoDefault database to use if not specified in tool arguments or resource URIs
STARROCKS_URLNoA connection URL string that contains all connection parameters in a single variable. Format: [<schema>://]user:password@host:port/database
STARROCKS_HOSTNoHostname or IP address of the StarRocks FE servicelocalhost
STARROCKS_PORTNoMySQL protocol port of the StarRocks FE service9030
STARROCKS_USERNoStarRocks usernameroot
MCP_TRANSPORT_MODENoCommunication mode that specifies how the MCP Server exposes its servicesstdio
STARROCKS_PASSWORDNoStarRocks password
STARROCKS_OVERVIEW_LIMITNoAn approximate character limit for the total text generated by overview tools20000
STARROCKS_MYSQL_AUTH_PLUGINNoSpecifies the authentication plugin to use when connecting to the StarRocks FE service

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
All DatabasesList all databases in StarRocks

Tools

Functions exposed to the LLM to take actions

NameDescription
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 query to extract data from database, then using python plotly_expr to generate a chart for UI to display

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

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/StarRocks/mcp-server-starrocks'

If you have feedback or need assistance with the MCP directory API, please join our Discord server