Menu
Debug with root-cause analysis before fixes. Use for bugs, failing tests, CI failures, runtime errors, Spark/SQL performance, schema drift, data quality incidents, logs, metrics, and unexplained behavior.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Build and maintain an internal technical LLM wiki when the user requests wiki work or a verified major or architectural change qualifies for automatic wiki review. Use for project memory, architecture notes, contracts, runbooks, decisions, glossary, incremental ingest, delta status, and wiki health. Do not use merely because a routine task or plan completed.
Explore ambiguous ideas and solution directions before evidence-backed research or implementation planning. Use for ideation, framing, assumption checks, option generation, product or architecture trade-offs, and deciding whether research or a plan is needed.
Research technical options with source-backed recommendations. Use for technology evaluation, architecture trade-offs, library/framework choices, best practices, scalability, security, maintainability, or when current external facts matter.
Create implementation plans, architecture decisions, and phased roadmaps. Use for Standard or Complex changes, new pipelines, schema changes, migrations, multi-file features, technology choices, or when acceptance criteria and verification strategy are unclear.
Review code and data pipeline changes for correctness, security, performance, maintainability, contract breaks, and missing verification. Use before merge, after implementation, for PRs, commits, pending diffs, or codebase risk scans.
Design data ingestion into landing/bronze layers. Use for source onboarding, transfer pattern selection, full/incremental/CDC scope, change detection, landing zones, schema drift, idempotent file or batch processing, and ingestion quality gates.
| name | debug |
| description | Debug with root-cause analysis before fixes. Use for bugs, failing tests, CI failures, runtime errors, Spark/SQL performance, schema drift, data quality incidents, logs, metrics, and unexplained behavior. |
Root cause first. No speculative fixes.
Root cause: <one sentence>
Evidence:
- ...
Fix:
- ...
Verification:
- <command/check/result>
Prevention:
- ...
Open questions:
- ...