What problem does it solve? Designing efficient data access layers in Spring Boot is error-prone: N+1 query problems, misconfigured relationships, missing indexes, and long-running transactions degrade performance and reliability. This Skill provides proven JPA/Hibernate patterns to model entities, optimize queries, and manage transactions correctly. ## Core Features & Use Cases - Entity Design & Auditing: Define entities with proper table mappings, unique constraints, enum handling, and automatic created/updated timestamps via @EnableJpaAuditing. - Query Optimization: Prevent N+1 issues with JOIN FETCH, lazy loading defaults, and DTO projections for lightweight read paths. - Transactions, Pagination & Pooling: Apply @Transactional best practices, offset and cursor-style pagination, composite indexing, and HikariCP connection pool tuning. - Use Case: When building a Spring Boot service backed by MySQL or PostgreSQL, use this Skill to scaffold repositories with paginated queries, fetch strategies, and Flyway-managed migrations instead of relying on Hibernate auto DDL. ## Quick Start Ask the AI to design a JPA entity with relationships, an optimized repository with pagination, and transactional service methods for your Spring Boot domain model.
