SQL

DE//AGENT currently lists 3 resources under SQL: 2 skills, 1 rule pack. 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:

• Prove a join cannot fan out before writing it — via SQL Review
• Spot NULL-unsafe `NOT IN` and `=` predicates — via SQL Review
• State the grain of a result set in one sentence — via SQL Review
• Configure SQLFluff for your warehouse dialect — via SQLFluff Core Rule Pack
• Customize rules for team standards — via SQLFluff Core Rule Pack
• Integrate SQLFluff into CI/CD pipelines — via SQLFluff Core Rule Pack
• Fix legacy SQL debt incrementally — via SQLFluff Core Rule Pack
• Read a plan bottom-up and name the expensive node — via SQL Query Plan Explainer

2 more objectives live on the individual resource pages.

These resources map to stage: Python + SQL (3). 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 Review score 39.9 — beginner
2. SQLFluff Core Rule Pack score 39.7 — beginner
3. SQL Query Plan Explainer score 38.5 — intermediate

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

Start here if you're new: SQL Review, SQLFluff Core Rule Pack.

Security-flagged entries: SQL Review (1 flag), SQLFluff Core Rule Pack (1 flag), 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 Review — Reviews a SQL statement for fan-out joins, NULL-unsafe predicates, implicit casts, non-deterministic ordering, and functions that silently change grain. details
• SQLFluff Core Rule Pack — A curated SQLFluff configuration with rules optimized for modern data engineering workflows. Includes dialect-specific rules for dbt (Jinja), Spark SQL, Snowflake, BigQuery, and Re… details
• 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

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

npx de-agent-platform add sql-review

SQL Review — review first

pip install sqlfluff==3.0.0 sqlfluff-templater-dbt

SQLFluff Core Rule Pack — review first

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

SQL Query Plan Explainer — review first

Adjacent topics: DuckDB (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.