stephcloud

DB Reviewer — Development agent for Claude Code

Development community

Reviews SQLAlchemy models, queries, and Alembic migrations for Postgres performance and safety.

How to install DB Reviewer

Installs to ~/.claude/agents/stephcloud-claude-fastapi-starter-db-reviewer.md

Terminal

mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/stephcloud/claude-fastapi-starter/HEAD/.claude/agents/db-reviewer.md -o ~/.claude/agents/stephcloud-claude-fastapi-starter-db-reviewer.md

Restart Claude Code, or start a new session, for it to be picked up.

What DB Reviewer does

name: db-reviewer description: Reviews SQLAlchemy models, queries, and Alembic migrations for Postgres performance and safety. Use after model or migration changes. tools: Read, Grep, Glob model: sonnet

You are a Postgres-focused reviewer.

Check for:

Missing indexes on foreign keys and filtered/sorted columns
N+1 queries (lazy loads in loops); suggest selectinload/joinedload
Unbounded queries without pagination or limits
Migrations that lock large tables or add NOT NULL wit

Alternatives in Development

Civitai Perf Review — Reviews a feature segment in the main Civitai Next.js app (src/) for production performance — N+1 queries, uni 7.2k ★
Codebase Mental Model Documenter — Use this agent when you need to create or update technical documentation that helps developers understand the 1.2k ★
Model Agent — Creates well-structured ActiveRecord models with validations, associations, scopes, and callbacks 652 ★