database-reviewer

A PostgreSQL database review that examines SQL queries, table design, indexes, and database migrations. PostgreSQL is a relational database system; migrations are controlled changes to its structure.

In plain words
What is it for?
Reviewing SQL, planning migrations, designing schemas, and checking query performance and indexing strategies.
Why use it?
It helps find slow queries, unsafe schema changes, missing indexes, and database design problems before they affect users.

Skill for Claude CodeCodex

Install

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.

agentmods
npx agentmods add skills/random6913/claude-code-superkit/database-reviewer
Any agent
npx skills add RaNDoM6913/claude-code-superkit --skill database-reviewer
Clone the repo
git clone --depth 1 https://github.com/RaNDoM6913/claude-code-superkit

Made for: Claude Code, Codex.

Per session 25 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,601 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5 $0.00025 $0.01601
Opus 5 $0.00013 $0.00800
Sonnet 5 $0.00005 $0.00320
Haiku 4.5 $0.00003 $0.00160

Measured 2d ago against content hash c02d5c51e655, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

database-reviewer 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.

packages/codex/skills/database-reviewer/SKILL.md · 148 lines

How it starts

The opening of the file, as written. The whole thing — 148 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Database Reviewer

PostgreSQL specialist focused on query performance, schema design, index strategy, and migration safety. Use proactively when reviewing SQL, creating migrations, or designing schemas.

Phase 0: Load Project Context

Read if exists:

  1. AGENTS.md or CLAUDE.md — project conventions, database info
  2. docs/architecture/database-schema.md — tables, constraints, indexes, migrations

Use this context to:

  • Know existing table structure and naming conventions
  • Understand migration numbering and tooling (golang-migrate, Alembic, Prisma, etc.)
  • Identify query patterns used in the project (pgx, sqlx, Prisma, raw SQL)

Review Discipline (two-stage)

Stage 1 — Discovery (coverage, not filtering): Surface EVERY candidate finding you notice, at any severity. Do not pre-filter for importance here. Better to surface a finding that gets filtered downstream than to silently miss a real bug.

Stage 2 — Triage: For each candidate, assign Severity (CRITICAL/WARNING/SUGGESTION) and Confidence (HIGH/MEDIUM/LOW). Report HIGH/MEDIUM-confidence findings normally. Route LOW-confidence or ambiguous items to an Open Questions list — never drop them.

A clean review is a valid review — do not manufacture findings to look productive.

Evidence Gate (before emitting any finding)

Before reporting a finding, confirm ALL of:

  1. Exact citationfile:line (or file:start-end) you actually read.
  2. Concrete failure mode — the specific input/path that triggers it (no "could be problematic").
  3. Context checked — you read the surrounding code / caller, not just the line.
  4. Defensible severity — you can justify CRITICAL/WARNING/SUGGESTION to a skeptic.

Skip (do not report): style nits already enforced by a linter, hypotheticals with no trigger, and findings you cannot cite. A clean review is valid.

Review Process

Phase 1: Checklist (quick scan)

Run through the Review Checklist items below. Report violations immediately.

Phase 2: Deep Analysis

  1. What queries will this change generate?
  2. What are the performance implications at scale (100K+ rows)?
  3. Are there index implications?
  4. Could this cause lock contention or deadlocks?

Read the full file on GitHub · 148 lines

Changes

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.

  1. 2d ago First seen · 148 lines · 25 tokens per session scan A c02d5c51e655

Subscribe to this mod's changes

database-reviewer is a skill published in the GitHub repository RaNDoM6913/claude-code-superkit (2 stars, last pushed 1mo ago), licensed MIT. It adds 25 tokens to every session and 1,601 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-08-31.

Related

Other skills, from other repositories

apm-issue-autopilot

Use this skill to drive any open microsoft/apm issue (bug, feature, docs, refactor, perf) from raw intake to a mergeable PR with triage as the central, paramount gate. Run the apm-triage-panel rubric per issue first, then present ONE consolidated triage review for the whole batch and escalate to the maintainer BY…

microsoft/apm · 238 tokens

apm-review-panel

Use this skill to run a multi-persona expert advisory review on a labelled pull request in microsoft/apm. The panel fans out to five mandatory specialists plus a test-coverage specialist (active on every PR that touches src/) plus three conditional specialists (auth, doc-writer, performance-expert), all running in…

microsoft/apm · 178 tokens

apm-triage-panel

Use this skill to triage one microsoft/apm issue selected by the daily sweep, the status/needs-triage fast path, or manual dispatch. Emit one synthesized comment with a decision, label set, exact milestone, and suggested next action.

microsoft/apm · 59 tokens

batch-bug-shepherd

Use this skill to drive a batch of suspected bugs in microsoft/apm from raw issue list to mergeable PR queue. Fan out one triage subagent per issue (LEGIT / UNCLEAR / FIXED-AT-HEAD), gate every legit bug against PRINCIPLES.md via an apm-ceo strategic-alignment pass, cross-reference legit issues against open PRs, then…

microsoft/apm · 227 tokens

apm-spec-guardian

Use this skill to run a four-panel adversarial advisory review on any pull request that touches the OpenAPM specification artifact (docs/src/content/docs/specs/openapm-.md), its inline / sidecar JSON Schemas (docs/src/content/docs/specs/schemas/.schema.json), or the conformance fixture seed…

microsoft/apm · 215 tokens

cli-logging-ux

Use this skill when editing or creating CLI output, logging, warnings, error messages, progress indicators, or diagnostic summaries in the APM codebase. Activate whenever code touches console helpers (richsuccess, richwarning, richerror, richinfo, richecho), DiagnosticCollector, STATUSSYMBOLS, CommandLogger, or any…

microsoft/apm · 94 tokens