explain

DE//AGENT currently lists 2 resources under explain: 1 tutorial, 1 skill. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.

Documented learning objectives across these resources:

• Read a plan bottom-up and name the expensive node — via SQL Query Plan Explainer
• Detect cardinality misestimation from stale statistics — via SQL Query Plan Explainer
• Decide between an index, a rewrite, or a stats refresh — via SQL Query Plan Explainer
• Separate scan cost from compute time before choosing a fix — via Read an EXPLAIN plan and pick the one fix

These resources map to stage: Python + SQL (2). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.

Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.

How scores are computed: source quality score.

Highest composite score first:

1. SQL Query Plan Explainer score 38.5 — intermediate
2. Read an EXPLAIN plan and pick the one fix score 34.15 — intermediate

Scores rank provenance, completeness and trust — read how verification works before adopting anything.

Security-flagged entries: SQL Query Plan Explainer (1 flag). Flags mean the record declares capabilities like credential use or write access — read the security posture on each page before connecting.

• SQL Query Plan Explainer — Reads EXPLAIN / EXPLAIN ANALYZE output and explains scans, joins, spills and estimated-vs-actual row skew, then proposes the single highest-impact change. details
• Read an EXPLAIN plan and pick the one fix — Take the EXPLAIN output of a slow query and read it bottom-up, naming the expensive node before you touch anything. You compare estimated rows to actual rows to catch stale statist… details

Real install commands from the registry — read the source before running any of them:

npx de-agent-platform add sql-query-plan-explainer

SQL Query Plan Explainer — review first

Adjacent topics: performance (2 shared), query-plan (2 shared).

Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.