What problem does it solve? Reviewing pull requests that span backend API models, SQL queries, and frontend TypeScript types often misses subtle defects like response fields absent from SELECT columns, type mismatches across the API boundary, or unsafe SQLite transactions. This Skill provides a structured checklist so reviewers catch these recurring defect classes consistently. ## Core Features & Use Cases - Response Model / SELECT Alignment: Verifies every Pydantic response field appears in the SQL SELECT list of all query paths, including separate list and get endpoints. - Frontend/Backend Type Boundary Checks: Confirms TypeScript interfaces in api.ts match backend models and that ID types are consistent across selection state and API responses. - SQLite Transaction & Migration Safety: Flags helpers that commit inside BEGIN IMMEDIATE blocks and enforces idempotent migrations with IF NOT EXISTS and PRAGMA table_info guards. - Use Case: When reviewing a PR that adds a new field to a document list endpoint, use this Skill to verify the column exists in every SELECT, the frontend interface matches, and no unbounded Promise.allSettled polling was introduced. ## Quick Start Review this pull request using the pr-review-database-api checklist and report any violations in response models, SQL queries, transactions, or frontend type contracts.
