Install: /plugin install aio-starrocks@aiocean-plugins · v1.0.2

aio-starrocks

StarRocks best practices and query tuning skills based on official documentation.

Install

/plugin install aio-starrocks@aiocean-plugins

Skills

aio-starrocks-best-practices

Table design best practices — partitioning strategy, sort key selection, bucketing decisions, Primary Key table tuning, authentication/authorization, and resource group configuration.

Use when: designing new tables, optimizing existing schemas, reviewing DDL, choosing partition/bucket/sort strategies, configuring access control and resource isolation.

Covers:

• Partitioning (time-first, tenant isolation, composite keys, granularity decisions)
• Table clustering / sort keys (selection playbook, prefix index, 36-byte limit)
• Bucketing (hash vs random, colocated joins, tablet sizing, anti-patterns)
• Primary Key table tuning (index types, memory management, performance balance)
• Authentication & authorization (LDAP, OIDC, RBAC, Security Integration)
• Audit log & resource groups (CPU/memory/concurrency allocation from audit data)

aio-starrocks-query-tuning

Query performance tuning — EXPLAIN plans, Query Profile analysis, operator metrics, tuning recipes, schema optimization, query hints, and text-based profile analysis.

Use when: diagnosing slow queries, reading EXPLAIN output, analyzing query profiles, optimizing joins/scans/aggregations, applying query hints, tuning StarRocks schema.

Covers:

• 5-step tuning methodology (identify, collect, locate, apply, validate)
• EXPLAIN variants (LOGICAL, VERBOSE, COSTS, ANALYZE)
• Query Profile configuration (enable_profile, big_query_profile_threshold, runtime profiles)
• Text-based profile analysis (ANALYZE PROFILE, SHOW PROFILELIST, bottleneck highlighting)
• Tuning recipes by operator (scan, aggregation, join, exchange, sort/window)
• Schema tuning (table types, indexes, materialized views, flat vs star)
• Query hints (SET_VAR, SET_USER_VARIABLE, join hints: SHUFFLE/BROADCAST/BUCKET/COLOCATE)
• Operator metrics reference (15+ operator types with all metrics and tuning signals)

Sources

• Best Practices Overview
• Partitioning
• Table Clustering
• Bucketing
• Primary Key Table
• Authentication & Authorization
• Audit Log & Resource Group
• Query Plan Intro
• Query Planning
• Query Profile Overview
• Query Profile Tuning Recipes
• Schema Tuning
• Text-Based Analysis
• Query Hints
• Operator Metrics

Skills (2)

• aio-starrocks-best-practices — StarRocks table design best practices — partitioning strategy, sort key selection, bucketing decisions, Primary Key table tuning, authentication/authorization,…
• aio-starrocks-query-tuning — StarRocks query performance tuning — EXPLAIN plans, Query Profile analysis, operator metrics, tuning recipes, schema optimization, query hints, and text-based p…