Click on "Install 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-mcpShow 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
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
This server cannot be installed
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.