The MCP server is built with Python, required as a prerequisite (3.8+), and the server is launched using Python commands
Used for database connectivity with the StarRocks database, enabling execution of SELECT queries, table management, and database operations
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
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
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 databaselist-tables
: List all tables in the StarRocks databasedescribe-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 querycreate-table
: Create a new table in the StarRocks database
Examples
Listing tables
Executing a SELECT query
Describing a table
Creating a table (when not in read-only mode)
License
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
This server cannot be installed
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
Related MCP Servers
- -securityAlicense-qualityA simple MCP server that can enable MCP clients to query Bluesky instances.Last updated -24TypeScriptMIT License
- -securityFlicense-qualityAn MCP server that enables searching and retrieving content from Confluence documentation systems, providing capabilities for both document searches and full page content retrieval.Last updated -1Python
- -securityAlicense-qualityStores metadata for MCP servers and provides smart search capabilities, allowing users to find appropriate MCP servers for their queries and route requests to the most suitable server.Last updated -9PythonMIT License
- AsecurityAlicenseAqualityAn MCP server that allows searching for and retrieving information about Model Context Protocol servers registered on the MCP Hub.Last updated -11MIT License