Starrocks Official MCP server
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases, allowing for direct SQL execution and database exploration without requiring complex setup or configuration.
Configuration
MCP server config
{
"mcpServers": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-server-starrocks",
"mcp-server-starrocks"
],
"env": {
"STARROCKS_HOST": "default localhost",
"STARROCKS_PORT": "default 9030",
"STARROCKS_USER": "default root",
"STARROCKS_PASSWORD": "default empty"
}
}
}
}
If mcp-server-starrocks is not installed as python package(in dev env), can run using local dir
{
"mcpServers": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"--directory",
"path/to/mcp-server-starrocks",
"run",
"mcp-server-starrocks"
],
"env": {
"STARROCKS_HOST": "default localhost",
"STARROCKS_PORT": "default 9030",
"STARROCKS_USER": "default root",
"STARROCKS_PASSWORD": "default empty"
}
}
}
}
Components
Tools
read_query
- Execute a SELECT query or commands that return a ResultSet
write_query
- Execute an DDL/DML or other StarRocks command that do not have a ResultSet
Resources
Direct Resources
starrocks:///databases
- Lists all databases in StarRocks
Resource Templates
starrocks:///{db}/{table}/schema
- Gets the schema of a table using SHOW CREATE TABLE
starrocks:///{db}/tables
- Lists all tables in a specific database
proc:///{+path}
- System internal information exposed by StarRocks similar to linux /proc
- Common paths include:
/frontends
- Shows the information of FE nodes/backends
- Shows the information of BE nodes if this SR is non cloud native deployment/compute_nodes
- Shows the information of CN nodes if this SR is cloud native deployment/dbs
- Shows the information of databases/dbs/<DB_ID>
- Shows the information of a database by database ID/dbs/<DB_ID>/<TABLE_ID>
- Shows the information of tables by database ID/dbs/<DB_ID>/<TABLE_ID>/partitions
- Shows the information of partitions by database ID and table ID/transactions
- Shows the information of transactions by database/transactions/<DB_ID>
- Shows the information of transactions by database ID/transactions/<DB_ID>/running
- Shows the information of running transactions by database ID/transactions/<DB_ID>/finished
- Shows the information of finished transactions by database ID/jobs
- Shows the information of jobs/statistic
- Shows the statistics of each database/tasks
- Shows the total number of all generic tasks and the failed tasks/cluster_balance
- Shows the load balance information/routine_loads
- Shows the information of Routine Load/colocation_group
- Shows the information of Colocate Join groups/catalog
- Shows the information of catalogs
Prompts
None
StarRocks MCP Server
Project Details
- starrocks/mcp-server-starrocks
- Apache License 2.0
- Last Updated: 4/18/2025
Recomended MCP Servers
A Model Context Protocol (MCP) server that bridges Video & Audio content with Large Language Models using yt-dlp.
Read your Apple Notes with Claude Model Context Protocol
MCP Server for kicking off and getting status of your crew deployments
AlibabaCloud CloudOps MCP Server
Dify 1.0 Plugin MCP HTTP with SSE or Streamable HTTP transport Tools
Stata MCP Extension for VS Code and Cursor IDE
MCP Server for interacting with a Steel web browser
Rijksmuseum MCP integration for artwork exploration and analysis

Talk with your notes in Claude. RAG over your Apple Notes using Model Context Protocol.