StarRocks

High-performance analytical database for real-time and batch analytics at scale.

MCPCLI

About StarRocks

High-performance analytical database for real-time and batch analytics at scale. Explore how StarRocks integrates with the agentic data stack ecosystem and supports autonomous data operations.

Key Features

  • Sub-second OLAP query engine optimized for real-time, multi-dimensional analytics
  • Vectorized execution engine with SIMD optimization delivering 3-10x performance gains
  • Cost-based optimizer (CBO) with cascades framework supporting all 99 TPC-DS queries
  • Real-time data ingestion with ACID transactions, primary key upserts, and partial updates
  • Intelligent materialized views that auto-refresh and transparently rewrite queries
  • Data lake analytics with native connectors for Hive, Iceberg, Delta Lake, and Hudi
  • Flexible architecture supporting both shared-nothing and storage-compute separation
  • MySQL protocol compatibility allowing connection from any MySQL client or BI tool

Agent Integration

CLI — mysql (MySQL-protocol compatible)

$ brew install mysql-client
CLI Documentation

External Links

StarRocks MCP Server (Official)

Official MCP server with SQL execution, database exploration, Plotly visualization, and caching

LangChain Vector Store Integration

LangChain integration for using StarRocks as a vector store for semantic search and RAG

API Reference

Official SQL reference, function reference, and system configuration documentation

StarRocks Python Client

Python client with SQLAlchemy dialect and Alembic support

Integrations

Official integrations page covering BI tools, data loading, and orchestration connectors

← Back to SQL Engine