StarRocks MCP Server

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.