Skip to main content
Glama
StarRocks

StarRocks MCP Server

Official
by StarRocks
OverviewSchemaRelated ServersScoreDiscussions
Python
Hybrid

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

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

Features and capabilities supported by this server

Protocol revision2025-11-25

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

Tools

Functions exposed to the LLM to take actions

NameDescription
read_queryA

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_queryA

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_queryB

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_profileB

Run a query to get it's query dump and profile, output very large, need special tools to do further processing

query_and_plotly_chartB

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_overviewA

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_summaryA

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_dbA

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.

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

Latest Blog Posts

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