StarRocks MCP Server

Name: StarRocks MCP Server
Author: hagsmand

@hagsmand

Repository

About StarRocks MCP Server

No overview available yet

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server-starrocks-hagsmand": {
      "command": "python",
      "args": [
        "-m",
        "mcp_server_starrocks.server",
        "--host",
        "<starrocks-host>",
        "--port",
        "<starrocks-port>",
        "--user",
        "<username>",
        "--database",
        "<database-name>",
        "[--password",
        "<password>]",
        "[--readonly]"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is StarRocks MCP Server?

The StarRocks MCP Server is a Model Context Protocol (MCP) server that provides a standardized interface for AI models to query and manipulate StarRocks databases through a set of defined tools. It is intended for developers and AI agents who need programmatic read and write access to StarRocks.

How to use StarRocks MCP Server?

Install from source using pip install -e . after cloning the repository, or install via Smithery. Start the server with python -m mcp_server_starrocks.server and provide required command-line arguments: --host, --user, --database, and optionally --port, --password, and --readonly. Once running, AI models can call the provided tools (read-query, list-tables, describe-table, write-query, create-table) via MCP.

Key features of StarRocks MCP Server

Execute SELECT queries on StarRocks databases
List available tables in a database
Describe table schemas
Create new tables (when not in read-only mode)
Execute write operations (INSERT, UPDATE, DELETE) when not in read-only mode

Use cases of StarRocks MCP Server

AI models retrieving data from StarRocks for analysis or reporting
Automated schema exploration and metadata discovery
Agent-driven data ingestion using INSERT queries
Dynamic table creation as part of AI‑orchestrated ETL workflows
Enabling conversational AI assistants to query StarRocks directly

FAQ from StarRocks MCP Server

What is the StarRocks MCP Server used for?

It gives AI models a standardized way to read from and write to StarRocks databases using a set of MCP tools, without requiring direct SQL access.

What are the prerequisites for running the server?

Python 3.8 or higher, a running StarRocks database instance, SQLAlchemy, and the MCP Python library are required.

How can I run the server in read-only mode?

Add the --readonly flag when starting the server. In this mode, only the read-query, list-tables, and describe-table tools are available; write operations are disabled.

What tools does the server expose?

The server provides read-query, list-tables, and describe-table (always available), plus write-query and create-table when not in read-only mode.

Can I create tables or write data?

Yes, if the server is not started with the --readonly flag. The create-table tool accepts a CREATE TABLE statement, and write-query can execute INSERT, UPDATE, or DELETE queries.