pr-review

Inspects PostgreSQL database schema, validates DDL migrations for locking risks, checks query parameterization, and audits indexing.

Discovers and normalizes a GitHub issue or free-form task into a structured work item JSON document.

Commits staged changes using Conventional Commits, pushes branch, and opens a GitHub Pull Request with structured template.

Classifies a work item into Feature, Bug, Database Migration, Refactor, or Spike with confidence scoring and risk evaluation.

Audits git diff against security policies, PostgreSQL safety guidelines, layering rules, and naming conventions.

Verifies project prerequisites, git clean state, and bootstraps .devpilot/config.json from template if missing.

Decomposes a triaged work item into a structured sequence of subtasks based on project configuration templates.

Guidelines and protocols for orchestrator agents to delegate specialized tasks (like PostgreSQL architecture or PR review) to subagents.

Generates an exhaustive, deterministic, step-by-step implementation plan covering file creations, modifications, SQL migrations, and test commands.

Lightweight codebase exploration skill to scan repository structure, directory layout, framework detection, and configuration patterns.

Performs deep contextual analysis of the repository returning exact file:line references, AST structures, and dependency graphs.

Executes the deterministic implementation plan step by step in the isolated worktree or branch, writing code, migrations, and tests.