Schema | StarRocks MCP Server

StarRocks MCP Server

Official

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	A connection URL string that contains all connection parameters in a single variable. Format: [<schema>://]user:password@host:port/database
`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
`MCP_TRANSPORT_MODE`	No	Communication mode that specifies how the MCP Server exposes its services	stdio
`STARROCKS_PASSWORD`	No	StarRocks password
`STARROCKS_OVERVIEW_LIMIT`	No	An approximate character limit for the total text generated by overview tools	20000
`STARROCKS_MYSQL_AUTH_PLUGIN`	No	Specifies the authentication plugin to use when connecting to the StarRocks FE service

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": true }
`logging`	{}
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`extensions`	{ "io.modelcontextprotocol/ui": {} }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
read_query	Execute a SELECT query or commands that return a ResultSet. Set output_file to write the full result to disk instead of returning it inline (useful for large results).. Use set_session_db to set a per-session default database
write_query	Execute a DDL/DML or other StarRocks command that do not have a ResultSet. Use set_session_db to set a per-session default database
analyze_query	Analyze a query and get analyze result using query profile. Use set_session_db to set a per-session default database
collect_query_dump_and_profile	Run a query to get it's query dump and profile, output very large, need special tools to do further processing
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. Use set_session_db to set a per-session default database
table_overview	Get an overview of a specific table: columns, sample rows (up to 3), and total row count. Uses cache unless refresh=true. Use set_session_db to set a per-session default database
db_summary	Quickly get summary of a database with tables' schema and size information. Use set_session_db to set a per-session default database
set_session_db	Set or clear the default database for THIS MCP session. Subsequent tool calls without an explicit `db` argument will use this database. Pass an empty string or null to clear and fall back to the server's global default. Returns the new effective default for this session.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
`All Databases`	List all databases in StarRocks

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