StarRocks

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

1{
2  "mcpServers": {
3    "mcp-server-starrocks": {
4      "command": "uv",
5      "args": [
6        "run",
7        "--with",
8        "mcp-server-starrocks",
9        "mcp-server-starrocks"
10      ],
11      "env": {
12        "STARROCKS_HOST": "default localhost",
13        "STARROCKS_PORT": "default 9030",
14        "STARROCKS_USER": "default root",
15        "STARROCKS_PASSWORD": "default empty"
16      }
17    }
18  }
19}

If mcp-server-starrocks is not installed as python package(in dev env), can run using local dir

1{
2  "mcpServers": {
3    "mcp-server-starrocks": {
4      "command": "uv",
5      "args": [
6        "--directory",
7        "path/to/mcp-server-starrocks",
8        "run",
9        "mcp-server-starrocks"
10      ],
11      "env": {
12        "STARROCKS_HOST": "default localhost",
13        "STARROCKS_PORT": "default 9030",
14        "STARROCKS_USER": "default root",
15        "STARROCKS_PASSWORD": "default empty"
16      }
17    }
18  }
19}

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

Contents