
MCP-server-starrocks
Server Starrocks MCP (Model Context Protocol)
3
Github Watches
7
Github Forks
14
Github Stars
Starrocks Official MCP server
The StarRocks MCP Server acts as a bridge between AI assistants and StarRocks databases, allowing for direct SQL execution and database exploration without requiring complex setup or configuration.
Configuration
MCP server config
{
"mcpServers": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"run",
"--with",
"mcp-server-starrocks",
"mcp-server-starrocks"
],
"env": {
"STARROCKS_HOST": "default localhost",
"STARROCKS_PORT": "default 9030",
"STARROCKS_USER": "default root",
"STARROCKS_PASSWORD": "default empty"
}
}
}
}
If mcp-server-starrocks is not installed as python package(in dev env), can run using local dir
{
"mcpServers": {
"mcp-server-starrocks": {
"command": "uv",
"args": [
"--directory",
"path/to/mcp-server-starrocks",
"run",
"mcp-server-starrocks"
],
"env": {
"STARROCKS_HOST": "default localhost",
"STARROCKS_PORT": "default 9030",
"STARROCKS_USER": "default root",
"STARROCKS_PASSWORD": "default empty"
}
}
}
}
Components
Tools
-
read_query
- Execute a SELECT query or commands that return a ResultSet
-
write_query
- Execute an DDL/DML or other StarRocks command that do not have a ResultSet
Resources
Direct Resources
-
starrocks:///databases
- Lists all databases in StarRocks
Resource Templates
-
starrocks:///{db}/{table}/schema
- Gets the schema of a table using SHOW CREATE TABLE
-
starrocks:///{db}/tables
- Lists all tables in a specific database
-
proc:///{+path}
- System internal information exposed by StarRocks similar to linux /proc
- Common paths include:
-
/frontends
- Shows the information of FE nodes -
/backends
- Shows the information of BE nodes if this SR is non cloud native deployment -
/compute_nodes
- Shows the information of CN nodes if this SR is cloud native deployment -
/dbs
- Shows the information of databases -
/dbs/<DB_ID>
- Shows the information of a database by database ID -
/dbs/<DB_ID>/<TABLE_ID>
- Shows the information of tables by database ID -
/dbs/<DB_ID>/<TABLE_ID>/partitions
- Shows the information of partitions by database ID and table ID -
/transactions
- Shows the information of transactions by database -
/transactions/<DB_ID>
- Shows the information of transactions by database ID -
/transactions/<DB_ID>/running
- Shows the information of running transactions by database ID -
/transactions/<DB_ID>/finished
- Shows the information of finished transactions by database ID -
/jobs
- Shows the information of jobs -
/statistic
- Shows the statistics of each database -
/tasks
- Shows the total number of all generic tasks and the failed tasks -
/cluster_balance
- Shows the load balance information -
/routine_loads
- Shows the information of Routine Load -
/colocation_group
- Shows the information of Colocate Join groups -
/catalog
- Shows the information of catalogs
-
Prompts
None
相关推荐
I find academic articles and books for research and literature reviews.
Confidential guide on numerology and astrology, based of GG33 Public information
Emulating Dr. Jordan B. Peterson's style in providing life advice and insights.
Your go-to expert in the Rust ecosystem, specializing in precise code interpretation, up-to-date crate version checking, and in-depth source code analysis. I offer accurate, context-aware insights for all your Rust programming questions.
Advanced software engineer GPT that excels through nailing the basics.
Take an adjectivised noun, and create images making it progressively more adjective!
Découvrez la collection la plus complète et la plus à jour de serveurs MCP sur le marché. Ce référentiel sert de centre centralisé, offrant un vaste catalogue de serveurs MCP open-source et propriétaires, avec des fonctionnalités, des liens de documentation et des contributeurs.
Manipulation basée sur Micropython I2C de l'exposition GPIO de la série MCP, dérivée d'Adafruit_MCP230XX
L'application tout-en-un desktop et Docker AI avec chiffon intégré, agents AI, constructeur d'agent sans code, compatibilité MCP, etc.
Plateforme d'automatisation de workflow à code équitable avec des capacités d'IA natives. Combinez le bâtiment visuel avec du code personnalisé, de l'auto-hôte ou du cloud, 400+ intégrations.
Un puissant plugin Neovim pour gérer les serveurs MCP (Protocole de contexte modèle)
🧑🚀 全世界最好的 LLM 资料总结 (数据处理、模型训练、模型部署、 O1 模型、 MCP 、小语言模型、视觉语言模型) | Résumé des meilleures ressources LLM du monde.
MCP Server pour récupérer le contenu de la page Web à l'aide du navigateur sans tête du dramwright.
Pont entre les serveurs Olllama et MCP, permettant aux LLM locaux d'utiliser des outils de protocole de contexte de modèle
Reviews

user_ENOumRLo
As a dedicated user of mcp-server-starrocks, I can confidently say this product by StarRocks is exceptional. Its seamless integration and robust performance make data management effortless. Whether for scaling your system or handling complex queries, this server stands out. Highly recommended! Check it out at https://github.com/StarRocks/mcp-server-starrocks.