starrocks-mcp
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@starrocks-mcp Show me the schema for the campaign_budget table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
starrocks-mcp
A read-only MCP (Model Context Protocol) server for StarRocks databases. Query and explore your StarRocks data through Claude and other AI assistants.
Features
Supported ✅
SQL Query Execution
Execute SQL queries directly from Claude Desktop
Automatic result truncation for large datasets
Table Operations
List all databases
List tables in a database
Get table schema details
LDAP Authentication
Secure LDAP authentication support
Each user uses their own credentials
Not Supported ❌
Data Ingestion
Table/Schema Creation or Modification
User/Permission Management
Related MCP server: imply-druid-mcp
Tools
Tool | Description |
| Execute a SQL query and return results |
| List all databases in StarRocks |
| List tables in a database |
| Get detailed schema information for a table |
Installation
Using uvx (Recommended)
uvx --from git+https://github.com/jason-ung/starrocks-mcp starrocks-mcpUsing pip
pip install git+https://github.com/jason-ung/starrocks-mcp
starrocks-mcpConfiguration
Environment Variable | Required | Default | Description |
| Yes | - | StarRocks host |
| No |
| StarRocks port |
| Yes | - | Your LDAP username |
| Yes | - | Your LDAP password |
| No |
| Default database |
| No |
| Logging level |
| No |
| Default query timeout (ms) |
| No |
| Maximum SQL query length |
Claude Desktop Setup
Add to your Claude Desktop config file:
macOS:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows:
%APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"starrocks": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/jason-ung/starrocks-mcp",
"starrocks-mcp"
],
"env": {
"STARROCKS_HOST": "starrocks.datapl.datahou.se",
"STARROCKS_PORT": "9030",
"STARROCKS_USER": "your.ldap.username",
"STARROCKS_PASSWORD": "your_ldap_password",
"STARROCKS_DATABASE": "ads"
}
}
}
}⚠️ Important: Replace your.ldap.username and your_ldap_password with your actual LDAP credentials.
Usage Examples
User: Show me all databases in StarRocks
Claude: [Uses list_databases]
- ads
- search
- user_behaviorUser: What tables are in the ads database?
Claude: [Uses list_tables with database="ads"]
- advtr_product_da_preprocessed_log
- advtr_product_sa_preprocessed_log
- campaign_budgetUser: Describe the advtr_product_da_preprocessed_log table
Claude: [Uses describe_table with table="advtr_product_da_preprocessed_log"]
Field | Type | Description
----- | ---- | -----------
eventTs | BIGINT | Event timestamp
eventType | VARCHAR | Event type (IMPRESSION, CLICK, etc.)
...User: Query the top 10 campaigns by impression count
Claude: [Uses execute_query]
SELECT campaignId, COUNT(*) as impression_count
FROM advtr_product_da_preprocessed_log
WHERE eventType = 'IMPRESSION'
AND base_dt = '2026-01-29'
GROUP BY campaignId
ORDER BY impression_count DESC
LIMIT 10Development
Local Setup
git clone https://github.com/jason-ung/starrocks-mcp.git
cd starrocks-mcp
# Create virtual environment
python -m venv venv
source venv/bin/activate # On Windows: venv\Scripts\activate
# Install dependencies
pip install -e ".[dev]"
# Copy .env.example to .env and configure
cp .env.example .env
# Edit .env with your credentials
# Run the server
starrocks-mcpTesting Connection
# Test StarRocks connection
mysql -h starrocks.datapl.datahou.se -P 9030 -u your.username -p --ssl-mode=DISABLED --enable-cleartext-pluginSecurity
Never commit credentials: Always use environment variables for sensitive data
Use personal LDAP accounts: Each user should use their own credentials
LDAP authentication: Supports cleartext LDAP authentication over secure connections
Read-only operations: This MCP server only supports SELECT queries and metadata operations
License
MIT License - see LICENSE for details.
Author
Jason Son (@jason-ung)
Made with ❤️ for Bucketplace Ads Team
Available Tools
4 toolsdescribe_tableB
Get table schema and column information
Inputs: table (required), database.
execute_queryC
Execute a SQL query against StarRocks and return results.
Inputs: sql (required).
list_databasesA
List all databases in StarRocks
Inputs: no named parameters.
list_tablesC
List tables in a database
Inputs: database.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 4 tools
Each tool has a clearly distinct purpose: describe_table focuses on schema details, execute_query handles SQL execution, list_databases enumerates databases, and list_tables lists tables within a database. There is no overlap or ambiguity between these functions.
All tool names follow a consistent verb_noun pattern (describe_table, execute_query, list_databases, list_tables) with clear, descriptive verbs and nouns. There are no deviations in naming style.
With 4 tools, the count is reasonable for a database interaction server, covering core operations like listing, describing, and querying. It might be slightly thin for advanced database management, but it's well-scoped for basic functionality.
The tools cover essential read and query operations (list, describe, execute), but there are notable gaps for a database server, such as create/update/delete operations for databases or tables, which could limit agent workflows for full lifecycle management.
Related MCP Connectors
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseCqualityDmaintenanceA read-only MCP server that enables users to query Databricks SQL, browse metadata, and monitor Delta Lake tables. It also supports tracking Databricks Jobs, DLT Pipelines, and cluster metrics through natural language interfaces.254MIT
- AlicenseAqualityDmaintenanceA read-only MCP server for Imply Cloud/Druid databases, enabling AI assistants to execute SQL queries, list tables, and explore dashboards and data cubes.121MIT
- AlicenseAqualityDmaintenanceA read-only MCP server for exploring and analyzing a Secoda data catalog, enabling AI chat, semantic search, glossary browsing, and data lineage tracing.12Apache 2.0
- AlicenseAqualityBmaintenanceA read-only MCP server for exploratory data analysis across PostgreSQL, MySQL, and ClickHouse databases, providing safe, read-only access with comprehensive analysis capabilities.1084 PyPI6MIT