jpa-patterns

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

Install with Tessl CLI

npx tessl i github:ysyecust/everything-claude-code --skill jpa-patterns

What are skills?

1.14x

Quality

61%

Does it follow best practices?

Impact

100%

1.14x

Average score across 3 eval scenarios

Optimize this skill with Tessl

npx tessl skill review --optimize ./skills/jpa-patterns/SKILL.md

SKILL.md

Review

Evals

Evaluation results

100%

10%

Loan Application Entity

Entity design, auditing, and indexing

Criteria

Without context

With context

IDENTITY generation

100%

String enum mapping

100%

Auditing listener

100%

@CreatedDate as Instant

100%

@LastModifiedDate as Instant

100%

EnableJpaAuditing config

100%

@Table with index

100%

Unique index on slug/ref

100%

Column constraints

100%

Enum default value

100%

Without context: $0.2529 · 12m 38s · 14 turns · 97 in / 3,446 out tokens

With context: $0.3879 · 9m · 21 turns · 382 in / 4,410 out tokens

100%

Order Management Service

Relationships, N+1 prevention, and transactions

Criteria

Without context

With context

CascadeType.ALL on collection

100%

orphanRemoval = true

100%

No EAGER on collection

100%

JOIN FETCH query

100%

Interface projection

100%

@Transactional on writes

100%

@Transactional(readOnly=true) on reads

100%

No select * in JPQL

100%

JpaRepository extension

100%

Custom @Query for fetch

100%

Without context: $0.3195 · 7m 22s · 14 turns · 113 in / 4,724 out tokens

With context: $0.4800 · 28m 6s · 22 turns · 431 in / 5,577 out tokens

100%

29%

Event Log Pagination and Infrastructure Configuration

Pagination, connection pooling, and migrations

Criteria

Without context

With context

PageRequest.of with Sort

50%

100%

Descending sort

100%

Page return type

100%

HikariCP max pool size

100%

HikariCP min idle

100%

HikariCP connection timeout

100%

HikariCP validation timeout

100%

Migration tool present

100%

No auto DDL in production

100%

LOB non-contextual creation

100%

Additive migrations

100%

Without context: $0.2235 · 6m 1s · 11 turns · 89 in / 2,979 out tokens

With context: $0.4088 · 18m 57s · 22 turns · 155 in / 4,679 out tokens

Evaluated: 5 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Loan Application Entity Order Management Service Event Log Pagination and Infrastructure Configuration

Is this your skill?

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.