JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
87
81%
Does it follow best practices?
Impact
100%
1.14xAverage score across 3 eval scenarios
Passed
No known issues
Entity design, auditing, and indexing
IDENTITY generation
100%
100%
String enum mapping
100%
100%
Auditing listener
100%
100%
@CreatedDate as Instant
100%
100%
@LastModifiedDate as Instant
100%
100%
EnableJpaAuditing config
100%
100%
@Table with index
100%
100%
Unique index on slug/ref
100%
100%
Column constraints
100%
100%
Enum default value
0%
100%
Relationships, N+1 prevention, and transactions
CascadeType.ALL on collection
100%
100%
orphanRemoval = true
100%
100%
No EAGER on collection
100%
100%
JOIN FETCH query
100%
100%
Interface projection
100%
100%
@Transactional on writes
100%
100%
@Transactional(readOnly=true) on reads
100%
100%
No select * in JPQL
100%
100%
JpaRepository extension
100%
100%
Custom @Query for fetch
100%
100%
Pagination, connection pooling, and migrations
PageRequest.of with Sort
50%
100%
Descending sort
100%
100%
Page return type
100%
100%
HikariCP max pool size
100%
100%
HikariCP min idle
100%
100%
HikariCP connection timeout
0%
100%
HikariCP validation timeout
0%
100%
Migration tool present
100%
100%
No auto DDL in production
100%
100%
LOB non-contextual creation
0%
100%
Additive migrations
100%
100%
79cc4e3
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.