jpa-patterns

Spring Boot中的JPA/Hibernate实体设计、关系、查询优化、事务、审计、索引、分页和连接池模式。

1.09x

Quality

64%

Does it follow best practices?

Impact

96%

1.09x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

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

Evaluation results

92%

Product Catalog Data Layer

JPA entity design with auditing and migrations

Criteria

Without context

With context

IDENTITY generation strategy

100%

STRING enum persistence

100%

Audit timestamp annotations

100%

AuditingEntityListener declared

100%

EnableJpaAuditing config

100%

Slug index defined

100%

Status index defined

100%

OneToMany relationship

Column constraints applied

42%

100%

JpaRepository extension

100%

Pageable query method

100%

Migration file present

100%

No Hibernate auto DDL

100%

96%

Blog API Query Performance Overhaul

N+1 prevention and paginated query optimization

Criteria

Without context

With context

JOIN FETCH query

100%

No EAGER on collection

100%

Interface-based projection

100%

Projection used in repository

100%

PageRequest pagination

100%

Sort specified in PageRequest

50%

readOnly transaction on reads

100%

@Transactional on write methods

100%

@Param annotation on query

100%

JpaRepository extended

100%

README explains N+1 fix

100%

16%

Order Service: Production Configuration and Repository Tests

Connection pool configuration and data access testing

Criteria

Without context

With context

maximum-pool-size=20

100%

minimum-idle=5

100%

connection-timeout=30000

100%

validation-timeout=5000

100%

PostgreSQL LOB property

100%

@DataJpaTest annotation

100%

Testcontainers used

100%

SQL DEBUG logging

100%

Bind parameter TRACE logging

100%

No H2 dependency

100%

No Hibernate auto DDL in prod config

100%

Repository: haniakrim21/everything-claude-code
Commit: ae2cadd

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

Table of Contents

Product Catalog Data Layer Blog API Query Performance Overhaul Order Service: Production Configuration and Repository Tests

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.