-
securityA
license-
qualityA simple MCP server that can enable MCP clients to query Bluesky instances.
Last updated -
28
MIT License
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
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 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
{
"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
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
Related MCP Servers
- -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 -1
- -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 -10MIT 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