Agent skills for Apache Doris
Apache Doris Skills is a collection of agent instructions containing Apache Doris database knowledge for designing, sizing, operating, diagnosing, and contributing to Doris clusters. It serves developers and operators using Claude Code, Cursor, Codex, Cline, Amp, and other agent tools, with the skills providing decision logic and evidence-based workflows.
Skill Claude CodeCodex ✓ vendor
Workload-aware architecture design for Apache Doris. MUST USE when designing data architectures, choosing between data models, planning ingestion strategies, sizing clusters, or translating business requirements into Apache Doris system designs. Complements doris-best-practices with decision frameworks and…
Skill Claude CodeCodex ✓ vendor
Apache Doris table design and cluster sizing best practices. MUST USE when writing, reviewing, or optimizing Doris CREATE TABLE statements, partition/bucket strategies, data models, or cluster configurations. ALSO MUST USE whenever the doris-architecture-advisor skill produces DDL — apply the Pre-Flight Checklist to…
Skill Claude CodeCodex ✓ vendor
Apache Doris production diagnostics router. Use when Apache Doris queries are slow, imports are failing or timing out, compaction is raising -235 errors, nodes are OOM or crashing, materialized views are not rewriting, or tablet/replica health is degraded. Routes to the appropriate doris-debug- skill. Covers…
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris storage-compute separation (cloud mode) issues: meta-service latency, cache miss storms, object store throughput, and shared-nothing config conflicts in compute groups.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris -235 / too many versions and compaction lag. Error raised in RowsetBuilder::checktabletversioncount when versioncount > maxtabletversionnum (default 2000) or meta serialize size limit.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris external catalog issues: Hive/Iceberg/Paimon/Hudi query failures, metadata refresh, filesystem S3/HDFS connectivity, external MV rewrite misses.
Skill Claude CodeCodex ✓ vendor
Use for Doris FE/BE startup failures, port conflicts, prioritynetworks misrouting, metadir corruption, and ADD/DROP BACKEND issues.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris Stream/Broker/Routine Load issues and Group Commit asyncmode WAL pile-up. Tunables: table groupcommitintervalms / groupcommitdatabytes; BE groupcommitinsertthreads, groupcommitwalpath, groupcommitwalmaxdisklimit.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris sync MV (rollup) miss or async MTMV refresh/rewrite issues. Commands: SHOW ALTER TABLE MATERIALIZED VIEW, mvinfos(), EXPLAIN, REFRESH MATERIALIZED VIEW.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris FE/BE OOM, crash, or false Alive. BE: MemTrackerLimiter lines in be.WARNING; FE: JVM heap / jstack. Distinguish heartbeat Alive from query/brpc serving health.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Apache Doris slow/hanging/timeout queries. Covers FE planner (Nereids timeout), BE Profile bottlenecks, and Exchange WaitForData / brpc E1008 on port 8060. Session vars: enableprofile, querytimeout, nereidstimeoutsecond.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris Workload Group / resource tag queue starvation, CPU/memory isolation leaks, and workload policy debugging. Commands: SHOW WORKLOAD GROUPS, EXPLAIN resource.
Skill Claude CodeCodex needs its repo ✓ vendor
Use for Doris tablet/replica health, version skew, clone backlog, disk balance, and tablet repair. Commands: SHOW PROC tablethealth, SHOW TABLET, ADMIN REPAIR.
Skill Codex ✓ vendor
Interpret Apache Doris query runtime profiles, especially profile bottleneck triage, misleading wait counters, per-operator metric priority, scan, join-order/runtime-filter analysis, and evidence-bounded performance explanations. Use when given a Doris profile, query id, profile URL/text, or a request to explain Doris…
Skill Claude CodeCodex ✓ vendor
Review an Apache Doris PR from a local clone with the same multi-agent, shared-ledger convergence workflow as the CI Code Review Runner. Use when the user supplies a PR to /doris-repo-review, asks to review a Doris PR locally, or asks for the CI-style review flow. Safely align only the current worktree to the exact PR…
At most 3 mods per repository are shown here, and a mod shipped inside a plugin is left to that plugin's page — the rest are on their repository pages: