StarRocks MCP Server

Name: StarRocks MCP Server
Author: hagsmand

@hagsmand

代码仓库

关于 StarRocks MCP Server

暂无概览

基本信息

分类

其他

许可证

MIT

运行时

python

传输方式

stdio

发布者

hagsmand

提交者

Ameen Gulistan

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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]"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.