mcp-server-starrocks

StarRocks MCP Server

A Model Control Protocol (MCP) server for interacting with StarRocks databases. This server provides a standardized interface for AI models to query and manipulate StarRocks databases through a set of defined tools.

Overview

The StarRocks MCP Server allows AI models to:

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

Installation

Prerequisites

Python 3.8+
StarRocks database instance
SQLAlchemy
MCP Python library

Install from source

git clone https://github.com/yourusername/mcp-server-starrocks.git
cd mcp-server-starrocks
pip install -e .

Install from Smithery

npm install @smithery/sdk @modelcontextprotocol/sdk

Using MCP Inspector

npx @modelcontextprotocol/inspector uv --directory ~/mcp-server-starrocks run mcp-server-starrocks

Usage

Starting the server

python -m mcp_server_starrocks.server --host <starrocks-host> --port <starrocks-port> --user <username> --database <database-name> [--password <password>] [--readonly]

Command-line arguments:

--host: StarRocks server host (required)
--port: StarRocks server port (default: 9030)
--user: StarRocks username (required)
--database: StarRocks database name (required)
--password: StarRocks password (if required)
--readonly: Run the server in read-only mode (optional)

Available Tools

The server provides the following tools:

Read-only tools:

read-query: Execute a SELECT query on the StarRocks database
list-tables: List all tables in the StarRocks database
describe-table: Describe the schema of a specific table

Write tools (available when not in read-only mode):

write-query: Execute an INSERT, UPDATE, or DELETE query
create-table: Create a new table in the StarRocks database

Examples

Listing tables

{
    "name": "list-tables",
    "arguments": {}
}

Executing a SELECT query

{
    "name": "read-query",
    "arguments": {
        "query": "SELECT FROM my_table LIMIT 10"
    }
}

Describing a table

{
    "name": "describe-table",
    "arguments": {
        "table_name": "my_table"
    }
}

Creating a table (when not in read-only mode)

{
    "name": "create-table",
    "arguments": {
        "query": "CREATE TABLE new_table (id INT, name VARCHAR(100))"
    }
}

License

MIT License

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

This MCP server provides connection to Starrocks allows you to explore this query engine with minimum effort.

Related Resources

Reddit Discussion about this server

Related MCP Servers

mcp-shodan
BurtTheCoder
-
security
A
license
-
quality
MCP server for querying the Shodan API and Shodan CVEDB. This server provides tools for IP lookups, device searches, DNS lookups, vulnerability queries, CPE lookups, and more.
Last updated -
7
663
18
JavaScript
MIT License
Search MCP Server
fengin
-
security
A
license
-
quality
The Search MCP Server enables seamless integration of network and local search capabilities in tools like Claude Desktop and Cursor, utilizing the Brave Search API for high-concurrency and asynchronous requests.
Last updated -
1
52
Python
MIT License
clickhouse-mcp-server
burakdirin
-
security
A
license
-
quality
An MCP server implementation that enables Claude AI to interact with Clickhouse databases. Features include secure database connections, query execution, read-only mode support, and multi-query capabilities.
Last updated -
Python
MIT License
Data Gouv MCP Server
csonigo
-
security
F
license
-
quality
An MCP server that enables interaction with Datagouv APIs, primarily allowing users to search for up-to-date information about companies registered in France.
Last updated -
6
TypeScript

View all related MCP servers