Sql review

Skill vaibhavsaxena022/skills/sql-review

AI-agent skills for software engineering — works with Claude Code, Codex, Cursor

Install

npx -y skills add vaibhavsaxena022/skills --skill sql-review

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

26 days oldThe repository was created 26 days ago. New is not bad, but a brand new repository carrying a familiar-sounding name is the shape a typosquat arrives in, and there has been no time for anyone else to find a problem with it.
0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Review a SQL query (Postgres/MySQL) for performance and safety before it ships. Use when given a slow query, a new query, or asked to optimize SQL. Flags missing indexes, full scans, N+1 patterns, risky writes, and inefficient pagination.

SKILL.md

1.7 KB, 285 tokens by cl100k_base, as published. Nobody here has run it

SQL Review

Audit the provided SQL for performance and correctness.

Checklist

Indexes — are the WHERE / JOIN / ORDER BY columns indexed? Suggest composite indexes in the correct column order (equality first, then range).
Index-defeating patterns — SELECT *, leading-wildcard LIKE '%x', functions/casts on indexed columns.
Joins — are join keys indexed? Any fan-out producing duplicate rows?
N+1 — is this query executed inside a loop? Suggest batching (IN (...)) or a join.
Pagination — OFFSET on large tables gets slower with depth; suggest keyset (seek) pagination.
Write safety — UPDATE/DELETE without WHERE, missing transaction, implicit type casts.

Output

Verdict — ship, or fix first.
Findings — each as: problem → why it's slow/unsafe → concrete fix.
If helpful, a rewritten query and the CREATE INDEX statements.

Rules

Ask for the table schema, approximate row counts, or EXPLAIN (ANALYZE) output when the fix depends on them.
Prefer covering indexes and keyset pagination; don't over-index — every index adds write cost.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.