doris-debug

Name: doris-debug
Author: apache

github.com/apacheData & databases4772 installsUpdated 4w ago

About doris-debug

doris-debug is a troubleshooting skill for Apache Doris operators. It routes symptoms to focused guides and combines diagnostic commands, source maps, metrics, configuration references, and production cases.

Key features

01Routes Doris symptoms to domain skills
02Provides diagnostic SQL, API, and CLI references
03Maps symptoms to Doris source code
04Indexes production cases, metrics, and configuration
05Uses evidence-led, top-down investigation

Use cases

01Investigating slow or hanging queries
02Diagnosing load, compaction, or tablet issues
03Tracing FE/BE crashes and startup failures
04Troubleshooting catalogs and resource isolation

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/apache/doris-skills --skill doris-debug

After installing, type/doris-debugin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

cloud/references/

case-001-warmup-empty-batch.md

compaction/references/

case-001-too-many-versions.md

case-002-schema-change-base-score.md

data-lake/references/

case-001-glue-pagination.md

import/references/

case-001-group-commit-wal-pileup.md

case-002-rpc-timeout-heavy-work-pool.md

case-003-insert-job-fe-oom.md

materialized-view/references/

case-001-mtmv-rewrite-miss.md

node/references/

case-001-be-oom-memtracker.md

case-002-filecache-lru-leak.md

case-003-be-scanner-pileup-memory.md

case-004-fe-bdbje-corruption.md

query/references/

case-001-exchange-waitfordata.md

case-002-plan-time-iceberg-rpc.md

case-003-exchange-e11-fanout.md

resource-isolation/references/

case-001-workload-policy-cme.md

shared/guides/

cascade-import-wal-versions.md

cascade-query-timeout-exchange.md

shared/references/

01-common-commands.md

02-source-map.md

03-cir-case-index.md

04-metrics-guide.md

05-config-quick-ref.md

Details

From the project README

Doris Debug Router

How to use

Identify the symptom domain from the table below.
Read shared/references/01-common-commands.md for diagnostic SQL and API commands.
Read shared/references/02-source-map.md to map symptoms to Apache Doris source code locations.
Open the target skill (<domain>/SKILL.md) and follow its cause table and decision tree.
Check shared/references/03-case-index.md for matching production case patterns.

Skill routing

Symptom	Skill
Slow / timeout / hanging query, Profile analysis, Exchange WaitForData	`query/SKILL.md`
Stream Load / Broker Load / Routine Load failure, Group Commit WAL pile-up	`import/SKILL.md`
-235 / too many versions, compaction score high, compaction lag	`compaction/SKILL.md`
BE/FE OOM, crash, false Alive, memory leak	`node/SKILL.md`
Sync MV miss, async MTMV refresh/rewrite issues	`materialized-view/SKILL.md`
Tablet replica missing, clone backlog, disk skew, tablet repair	`tablet/SKILL.md`
FE/BE startup failure, port conflict, priority_networks misconfig	`deployment/SKILL.md`
Hive/Iceberg/Paimon/Glue catalog query failure, metadata refresh, S3/HDFS connectivity	`data-lake/SKILL.md`
Workload Group queue starvation, CPU/memory isolation leaks, spill issues	`resource-isolation/SKILL.md`
Storage-compute separation, meta-service latency, file cache, warmup	`cloud/SKILL.md`

Shared references

Document	Content
`shared/references/01-common-commands.md`	Diagnostic SQL, HTTP API, and CLI commands
`shared/references/02-source-map.md`	Symptom → Doris source code mapping (with version annotations)
`shared/references/03-case-index.md`	45 production case summaries across 8 domains
`shared/references/04-metrics-guide.md`	Per-domain key metrics with thresholds
`shared/references/05-config-quick-ref.md`	Per-domain key configuration parameters with tuning guidance
`shared/guides/`	Cross-module cascade troubleshooting

Companion skills

doris-profile-reader: Deep Profile analysis for query bottlenecks (referenced by query/SKILL.md Cause C — BE compute bottleneck).
doris-best-practices: Preventive table design and configuration guidance.
doris-architecture-advisor: Workload-aware architecture decisions.

Methodology

Client → FE → BE → Disk/Network top-down investigation
Logs / Metrics / Profile / SHOW PROC evidence first
Stop the bleeding (throttle, kill, reset_rpc_channel) before root cause
Verify hypotheses against Doris source code (02-source-map.md)
Match known case patterns (03-case-index.md) to avoid rediscovery

Comments

Markdown supported

Details

Author: apache
Repository: apache/doris-skills
Category: Data & databases
Installs: 72
GitHub stars: 47

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).