Question 1

What is the StarRocks MCP Server?

Accepted Answer

The StarRocks MCP Server is a Model Control Protocol (MCP) server that provides a standardized interface for AI models to query and manipulate StarRocks databases.

Question 2

What is MCP (Model Control Protocol)?

Accepted Answer

MCP is an open protocol that standardizes how applications provide context to LLMs. It enables AI models to interact with external data sources and tools in a structured and secure manner.

Question 3

What are the prerequisites for installing the StarRocks MCP Server?

Accepted Answer

You need Python 3.8+, a StarRocks database instance, SQLAlchemy, and the MCP Python library.

Question 4

How do I install the StarRocks MCP Server from source?

Accepted Answer

Clone the repository, navigate to the directory, and run `pip install -e .`.

Question 5

How do I start the StarRocks MCP Server?

Accepted Answer

Use the command: `python -m mcp_server_starrocks.server --host --port --user --database [--password ] [--readonly]`

Question 6

What are the available tools provided by the server?

Accepted Answer

The server provides `read-query`, `list-tables`, `describe-table`, and, when not in read-only mode, `write-query` and `create-table`.

Question 7

What does the `read-query` tool do?

Accepted Answer

The `read-query` tool executes a SELECT query on the StarRocks database.

Question 8

What does the `list-tables` tool do?

Accepted Answer

The `list-tables` tool lists all tables in the StarRocks database.

Question 9

What does the `describe-table` tool do?

Accepted Answer

The `describe-table` tool describes the schema of a specific table.

Question 10

What do the `write-query` and `create-table` tools do?

Accepted Answer

The `write-query` tool executes INSERT, UPDATE, or DELETE queries, and the `create-table` tool creates a new table in the StarRocks database. These are only available when the server is not in read-only mode.

Question 11

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

Accepted Answer

Use the `--readonly` flag when starting the server.

Question 12

Where can I find more information about UBOS?

Accepted Answer

UBOS is a Full-stack AI Agent Development Platform focused on bringing AI Agents to every business department. Visit [https://ubos.tech](https://ubos.tech) for more details.

StarRocks MCP Server

Resources

Project Details

Recomended MCP Servers

Featured Templates

Python Bug Fixer

Your Speaking Avatar

Image to text with Claude 3

AI-Powered Product List Manager

Unified Authorization Template

Talk with Claude 3

Start your free trial