What problem does it solve? Spring Boot developers frequently encounter N+1 query problems, poorly indexed tables, misconfigured transactions, and inefficient pagination when building JPA/Hibernate data layers, leading to slow applications and production incidents. ## Core Features & Use Cases - Entity & Relationship Design: Provides annotated entity templates with auditing (@CreatedDate, @LastModifiedDate), proper @OneToMany mappings, and index definitions. - Query Optimization: Prevents N+1 issues with JOIN FETCH queries, DTO projections, and lazy-loading strategies for read paths. - Transactions, Pagination & Pooling: Covers @Transactional best practices, Pageable-based pagination, HikariCP tuning, and Flyway/Liquibase migration guidance. - Use Case: When building a Spring Boot service with a Market entity that has child positions, apply these patterns to define the mapping, fetch positions without N+1 queries, paginate results by status, and configure the connection pool. ## Quick Start Ask the AI to design a JPA entity with relationships and an optimized repository for your Spring Boot domain model using these patterns.
