DE//AGENT
Explore
Agent community beginner

SQL Reviewer

Review SQL before it merges, catching correctness bugs and fan-out joins.

At a glance

What Review SQL before it merges, catching correctness bugs and fan-out joins.
Where SQL

Purpose

Review SQL before it merges, catching correctness bugs and fan-out joins.

Security scan

Last sweep 2026-10-24: 0 finding(s), 0 marked as examples.

Registry stats

Verification community · Sep 30, 2026
Completeness 80
Trust multiplier ×1
Composite 34.5 · adequate
Freshness 24 days since last source check
Difficulty beginner
Version 0.2.0
License Apache-2.0
Security flags 1

Workflow

  • Read the diff and the file context.
  • Establish the grain of every result set.
  • Apply the SQL review rules; stop at the first fan-out.
  • Emit findings with file:line and a rewritten clause.

Inputs

  • A pull request or a .sql file
  • The target dialect (postgres/duckdb/snowflake)

Outputs

  • Findings list (severity, location, rule, fix)
  • Grain statement for each SELECT

Guardrails

  • Read-only: never executes SQL
  • Does not modify files without explicit approval

Example

Reviewing a PR that joins orders to a non-unique customer snapshot — flags fan-out and proposes a dedupe CTE.

Evaluation

On a 12-case fixture of known-bad SQL, correctly identifies 11 correctness bugs and 0 false positives.

Tools

  • read_file
  • git_diff_unstaged

Skills

MCP Servers