Starrocks MCP Server

Python SQLAlchemy Dialect for StarRocks with optional Alembic integration

What the server does

StarRocks is the world's fastest open query engine for sub-second, ad-hoc analytics both on and off the data lakehouse. With average query performance 3x faster than other popular alternatives, StarRocks is a query engine that eliminates the need for denormalization and adapts to your use cases, without having to move your data or rewrite SQL. A Linux Foundation project.

• 🚀 Native vectorized SQL engine: — StarRocks adopts vectorization technology to make full use of the parallel computing power of CPU, achieving sub-second query returns in multi-dimensional analyses, which is 5 to 10 times faster than previous systems
• 📊 Standard SQL: — StarRocks supports ANSI SQL syntax (fully supported TPC-H and TPC-DS). It is also compatible with the MySQL protocol. Various clients and BI software can be used to access StarRocks
• 💡 Smart query optimization: — StarRocks can optimize complex queries through CBO (Cost Based Optimizer). With a better execution plan, the data analysis efficiency will be greatly improved
• ⚡ Real-time update: — The updated model of StarRocks can perform upsert/delete operations according to the primary key, and achieve efficient query while concurrent updates
• 🪟 Intelligent materialized view: — The materialized view of StarRocks can be automatically updated during the data import and automatically selected when the query is executed
• ✨ Querying data in data lakes directly — StarRocks allows direct access to data from Apache Hive™, Apache Iceberg™, Delta Lake™ and Apache Hudi™ without importing

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.