What problem does it solve? Designing a consistent data access layer is repetitive and error-prone: teams must decide CRUD methods, pagination, filtering, sorting, transaction boundaries, and query optimization for every entity. This Skill automates that work by generating a complete REPOSITORY_SPECS.md design document from your database schema and service specifications. ## Core Features & Use Cases - Repository Design Generation: Produces Repository lists, responsibilities, and standard CRUD methods (findById, findMany, create, update, delete, count) for each database entity. - Data Access Standards: Defines unified pagination, filtering, sorting, soft-delete, and transaction boundary rules, with Prisma implementation suggestions and index recommendations. - Risk & Performance Analysis: Detects N+1 query risks, missing pagination, and missing indexes, then outputs graded risk items with concrete fixes. - Use Case: Given DATABASE_SCHEMA.md and SERVICE_SPECS.md for a novel-to-script application, generate ScriptRepository, VersionRepository, and TaskRepository designs including findWithVersions, findLatestVersion, and findPendingTasks methods. ## Quick Start Ask the AI to generate the Repository layer design document from your DATABASE_SCHEMA.md and SERVICE_SPECS.md files.
