CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

jpa-patterns

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

1.14x
Quality

73%

Does it follow best practices?

Impact

100%

1.14x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./skills/jpa-patterns/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

68%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A lean, highly actionable JPA reference with executable code and properties throughout and good single-file organization. Its weaknesses are the absence of validation/feedback loops for database, batch, and migration operations (capping workflow clarity) and a few soft spots like the un-exemplified cursor pagination.

Suggestions

Add explicit validation checkpoints for the risky operations the skill covers, e.g., verify batch sizes take effect via hibernate.SQL DEBUG logs before/after saveAll, and a validate-migrate-test loop for Flyway/Liquibase changes, to lift workflow clarity past the database/batch cap of 3.

Replace the vague cursor-pagination hint with a concrete JPQL example (where m.id > :lastId order by m.id asc limit) mirroring the other sections' copy-paste style.

Either expand the two-bullet Caching and Migrations sections with the same concrete code/property style used elsewhere, or split them into one-level-deep reference files so every section carries its weight.

DimensionReasoningScore

Conciseness

The body is dense and pattern-focused — executable snippets with terse bullets like "Default to lazy loading; use JOIN FETCH in queries when needed" — with almost no explanation of concepts Claude already knows, matching 'efficient; minor instances of over-explanation that could be trimmed'. Not a 5 because a few lines restate common knowledge (e.g., 'Annotate service methods with @Transactional', the standard HikariCP property block) and the closing 'Remember' paragraph repeats points already made.

4 / 5

Actionability

Mostly executable, copy-paste-ready guidance: complete @Entity/@Repository/JPQL Java snippets, a concrete PageRequest line, exact HikariCP properties, and exact logging.level keys for SQL tracing — fitting 'mostly executable guidance; concrete code or commands with minor gaps'. Not a 5 because cursor pagination is only directed ("include id > :lastId in JPQL") with no example, and the transaction example depends on an undefined Market.from(entity) mapper.

4 / 5

Workflow Clarity

This is a reference-style skill with a useful 'When to Activate' section, but it prescribes database, batch-write, and migration operations without validate-fix-retry checkpoints, and the scoring notes cap workflow clarity at 3 for database/batch contexts missing feedback loops. The Testing Data Access section's log-based SQL assertion is a partial checkpoint, keeping it clearly above 2's 'validation absent' and poor definition.

3 / 5

Progressive Disclosure

No bundle files exist and the single SKILL.md is well-organized with clear, scannable section headers (Entity Design, Relationships, Transactions, Pagination, Indexing, Pooling, Caching, Migrations, Testing) of a size that justifies keeping everything inline — matching 'good structure; most content is appropriately placed; minor organization gaps'. Not a 5 because at ~145 lines covering nine topics, thin sections like Caching and Migrations (two bullets each) would benefit either from being expanded in one-level-deep reference files or folded into adjacent sections.

4 / 5

Total

15

/

20

Passed

Description

66%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A specific, domain-grounded description with good natural keyword coverage and low conflict risk. Its main weakness is the missing 'Use when...' trigger clause, which caps completeness at 3; the topic list is also noun-heavy rather than action-oriented.

Suggestions

Add an explicit trigger clause, e.g., 'Use when designing JPA entities or repositories, fixing N+1 or lazy-loading issues, or configuring transactions, HikariCP pooling, or Flyway migrations in Spring Boot.'

Convert topic nouns into concrete actions to sharpen specificity, e.g., 'Design entities and relationships, prevent N+1 queries with fetch strategies and projections, configure auditing and transactions.'

Include the natural synonyms practitioners actually say — repository, N+1, lazy loading, HikariCP, second-level cache — to round out trigger term coverage.

DimensionReasoningScore

Specificity

The description enumerates seven concrete topic areas — "entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling" — grounded in the JPA/Hibernate/Spring Boot domain, matching the 'lists several specific actions; minor gaps in coverage' anchor. It falls short of a 5 because these are topic labels rather than concrete verb-phrase actions (e.g., 'Design JPA entities', 'Prevent N+1 queries'), and above 3 because coverage is comprehensive rather than just 1-2 items.

4 / 5

Completeness

The 'what' is clear (JPA/Hibernate patterns across seven named areas), but there is no 'Use when...' clause or equivalent explicit trigger guidance, which caps completeness at 3 per the judging guidelines. It is not a 4 because 'when' is entirely absent rather than merely imprecise, and not a 2 because the 'what' half is concrete and specific.

3 / 5

Trigger Term Quality

Strong natural keywords users would say: "JPA", "Hibernate", "Spring Boot", "entity", "relationships", "transactions", "pagination", "pooling", matching 'good keyword coverage; a few natural terms missing'. Not a 5 because common variations practitioners actually say are absent — "repository", "N+1", "lazy loading", "HikariCP", "Flyway", "database" — and it is above 3 since far more than 'some relevant keywords' are present.

4 / 5

Distinctiveness Conflict Risk

The JPA/Hibernate/Spring Boot framing carves out a clear niche with distinct technical triggers, fitting 'mostly distinct; minor overlap risk with closely related skills'. It is not a 5 because the broad data-layer scope (indexing, pooling, transactions) overlaps with generic database-performance or Spring Boot skills, and clearly above 3 since the domain-specific vocabulary would not draw unrelated skills.

4 / 5

Total

15

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

15

/

16

Passed

Repository

valeriibeck-star/claude-skills

Path

skills/jpa-patterns/SKILL.md

Reviewed

Table of Contents

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.