StarRocks MCP Server

What it does

The StarRocks MCP Server provides a robust bridge between LLMs and StarRocks databases. It enables AI agents to perform real-time data analysis by executing SQL queries, exploring database schemas, and generating visual charts from result sets, eliminating the need for manual data exports.

Tools

• read_query: Executes SELECT queries and returns results in CSV-like format.
• write_query: Executes DDL (CREATE, ALTER, DROP) and DML (INSERT, UPDATE, DELETE) commands.
• analyze_query: Provides deep query analysis using profiles or EXPLAIN ANALYZE.
• query_and_plotly_chart: Fetches data and generates a Plotly chart as a base64 PNG image.
• table_overview: Retrieves columns, row counts, and sample data for a specific table.
• db_overview: Generates a comprehensive summary of all tables within a database.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mcp-server-starrocks": {
      "command": "uv",
      "args": ["run", "--with", "mcp-server-starrocks", "mcp-server-starrocks"],
      "env": {
        "STARROCKS_URL": "user:password@host:port/database"
      }
    }
  }
}

Supported hosts

• claude