starrocks-mcp-server
by tracymacding
Overview
Provides AI clients with intelligent diagnostic and analysis capabilities for StarRocks database instances.
Installation
node starrocks-mcp.jsEnvironment Variables
- SR_HOST
- SR_USER
- SR_PASSWORD
- SR_PORT
- CENTRAL_API
- CENTRAL_API_TOKEN
- PROMETHEUS_PROTOCOL
- PROMETHEUS_HOST
- PROMETHEUS_PORT
- ENABLE_LOGGING
- SSH_USER
- SSH_KEY_PATH
Security Notes
The server acts as a proxy to execute SQL queries, Prometheus queries, local CLI commands, and remote SSH commands. The commands and queries are orchestrated by an external 'StarRocks Expert' Central API. A critical security risk exists if the Central API is compromised, as the MCP server will directly execute arbitrary shell commands received from it, both locally and remotely via SSH. This makes the server highly vulnerable to remote code execution if the Central API is not fully trusted and secured. Sensitive information is masked in logs but not during execution of commands.
Similar Servers
mcp-server-starrocks
Acts as a bridge between AI assistants and StarRocks databases for direct SQL execution, database exploration, and data visualization.
awesome-oceanbase-mcp
The `awesome-oceanbase-mcp` project provides a collection of Model Context Protocol (MCP) servers designed to enable AI assistants to interact directly with OceanBase databases and its ecosystem components.
signoz-mcp-server
Integrates SigNoz observability data, including metrics, traces, logs, alerts, and dashboards, with AI assistants and LLMs for natural language querying and management.
ask-starknet
A unified Model Context Protocol (MCP) server that provides AI-powered routing to specialized Starknet MCP servers, enabling AI applications to seamlessly interact with Starknet protocols, wallets, and DeFi applications.