Starrocks Official MCP server

The StarRocks MCP Server serves as an intermediary, facilitating interaction between AI assistants and StarRocks databases. It enables direct SQL execution and database exploration, eliminating the need for intricate setup procedures.

Configuration

The configuration section provides JSON snippets for setting up the MCP server. It includes configurations for both when mcp-server-starrocks is installed as a Python package and when running from a local directory, specifying the command, arguments, and environment variables like STARROCKS_HOST, STARROCKS_PORT, STARROCKS_USER, and STARROCKS_PASSWORD.

Components

Tools

• read_query: Executes SELECT queries or commands returning a ResultSet.
• write_query: Executes DDL/DML commands or other StarRocks commands without a ResultSet.

Resources

Direct Resources

• starrocks:///databases: Lists all databases in StarRocks.

Resource Templates

• starrocks:///{db}/{table}/schema: Retrieves the schema of a table using SHOW CREATE TABLE.
• starrocks:///{db}/tables: Lists all tables within a specified database.
• proc:///{+path}: Accesses system internal information exposed by StarRocks, similar to Linux's /proc, including paths for frontends, backends/compute_nodes, databases, transactions, jobs, statistics, and more.

Prompts

None