Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add commands/luanmorenommaciel/agentspec/sql-reviewgit clone --depth 1 https://github.com/luanmorenommaciel/agentspecWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/commands/luanmorenommaciel/agentspec/sql-review)<a href="https://agentmods.dev/commands/luanmorenommaciel/agentspec/sql-review"><img src="https://agentmods.dev/badge/commands/luanmorenommaciel/agentspec/sql-review.svg" alt="Measured on agentmods" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00018 | $0.00386 |
| Opus 5 | $0.00009 | $0.00193 |
| Sonnet 5 | $0.00004 | $0.00077 |
| Haiku 4.5 | $0.00002 | $0.00039 |
Grade A, and why
sql-review scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
SQL Review Command
Review SQL code for anti-patterns, performance, and cross-dialect correctness
Usage
/sql-review <file-or-directory>
Examples
/sql-review models/marts/mart_revenue.sql
/sql-review models/staging/
/sql-review "Review all SQL in this PR for Snowflake compatibility"
What This Command Does
- Invokes the code-reviewer agent with DE capability enabled
- Escalates SQL optimization questions to sql-optimizer agent
- Loads KB patterns from
sql-patterns,data-quality, anddbtdomains - Reviews for:
- SQL anti-patterns (
SELECT *, implicit coercion, missing partition filters) - Performance issues (full table scans, N+1 patterns, missing indexes)
- Cross-dialect correctness (Snowflake, BigQuery, Postgres, DuckDB)
- PII detection and masking compliance
- dbt-specific issues (ref usage, incremental guards, test coverage)
- SQL anti-patterns (
Agent Delegation
| Agent | Role |
|---|---|
code-reviewer |
Primary — DE review capability (anti-patterns, PII, tests) |
sql-optimizer |
Escalation — query plan analysis, window functions |
dbt-specialist |
Escalation — dbt-specific patterns and macros |
KB Domains Used
sql-patterns— SQL anti-patterns, window functions, CTEsdata-quality— quality checks, PII detectiondbt— model patterns, testing conventions
Output
A structured review report with severity-classified issues and fix suggestions.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 2d ago First seen · 55 lines · 18 tokens per session scan A cb9b2a4bce3c
sql-review is a command published in the GitHub repository luanmorenommaciel/agentspec (244 stars, last pushed 3d ago), licensed MIT. It adds 18 tokens to every session and 386 once invoked, about $0.0001 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-01.
Other commands, from other repositories
notebook-query
Query the notebook knowledge base (SQLite) built by /agy:notebook — precise, grounded, cited. Ask in natural language ("sum the amounts by category", "which docs mention 'Acme Corp'", "build a project timeline") or pass raw SQL. Read-only. Use this when you need exact aggregates/lookups across a document corpus…
database-setup
Use when a project needs to store data and has no database yet. Setting up Supabase, creating tables, writing queries, and connecting them to the frontend. Written for designers.
ingest
Manually add knowledge to the Weaviate store.
integrate
/forge:integrate is the integration assistant for connecting your project to external services. It covers version control (GitHub, GitLab), monitoring (Sentry, Datadog), communication (Slack, Discord), databases (PostgreSQL, Redis, MongoDB), and cloud platforms (AWS, GCP, Vercel, Netlify). For each service, it checks…
db-reviewer
Reviews Postgres/Supabase schema, migrations, queries, and RLS for safety and performance. Use when DB code changes, before applying a migration, or inside /...
symfony-migrations
Create and manage Doctrine migrations for database schema changes.