Skills
.Work. You
Rest

starrocks-materialized-views

Community

Speed up StarRocks queries with smart MVs

Data & Analytics#iceberg#lakehouse#starrocks#materialized views#query rewrite#partition refresh#hive external tables
Authorivanshamaev
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps you build and manage StarRocks materialized views so analytics queries can run faster via automatic query rewrite and pre-aggregation, without manually rewriting every dashboard query.

Core Features & Use Cases

  • Create synchronous and asynchronous materialized views: design rollup MVs for single-table aggregates and async MVs for joins, expressions, external tables, and nested MVs.
  • Tune refresh and staleness behavior: choose REFRESH ASYNC, SCHEDULED, or MANUAL, configure partition-aware refresh properties, and control query rewrite staleness.
  • Debug and verify query rewrite: use EXPLAIN/EXPLAIN VERBOSE and MV state settings to understand why a query is or is not rewritten to an MV.

Quick Start

Load this Skill to create a StarRocks asynchronous materialized view that pre-aggregates daily KPIs and then verify rewrite using EXPLAIN.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: starrocks-materialized-views
Download link: https://github.com/ivanshamaev/de-agent-skills/archive/main.zip#starrocks-materialized-views

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.