Provide JPA/Hibernate entity design and query optimization patterns for Spring Boot.
npx skills add https://github.com/Kimjiman/basic-arch --skill jpa-patterns-kimjiman
Please help me install this Agent Skill. Skill: jpa-patterns Source: https://github.com/Kimjiman/basic-arch/tree/main/.claude/skills/jpa-patterns Command: npx skills add https://github.com/Kimjiman/basic-arch --skill jpa-patterns-kimjiman
This Skill provides comprehensive guidance and best practices for effectively using JPA and Hibernate within Spring Boot applications, addressing common challenges in entity design, query optimization, and transaction management.
Use the jpa-patterns skill to generate an example of a Spring Boot JPA entity with auditing enabled.
High-intent search queries and answers about installing and using this skill.
To fix the JPA N+1 query problem, optimize entity relationship mapping using appropriate fetch strategies, DTO projections, and custom repository methods to batch retrieve data instead of issuing individual queries.
Designing JPA entities with auditing uses entity listeners and specific annotations to automatically track entity changes. This pattern ensures proper transaction management and historical data tracking within Spring Boot applications.
HikariCP connection pooling manages database connections to optimize Hibernate interactions. Configuring HikariCP in Spring Boot limits idle connections, reduces connection overhead, and improves overall database transaction throughput.
DTO projections are highly effective for JPA query optimization. By selecting only necessary columns into Data Transfer Objects instead of full entities, you reduce memory consumption and speed up database retrieval.
Transactional annotations are needed for JPA repository methods to define transaction boundaries and ensure data consistency. They configure transactional behavior, managing read-only flags and isolation levels for database operations.
nubivGuide JPA and Hibernate patterns for Spring Boot data persistence.
vrcmsOptimize JPA and Hibernate data access patterns in Spring Boot applications.
idiaz01Implement JPA/Hibernate design patterns for Spring Boot data modeling and query performance.
icartshDesign RESTful and GraphQL APIs with OpenAPI 3.0 specifications.
