CtrlK
BlogDocsLog inGet started
Tessl Logo

jpa-patterns

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

72

1.18x
Quality

71%

Does it follow best practices?

Impact

96%

1.18x

Average score across 2 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

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

Quality

Content

76%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 strong, action-dense reference: executable code throughout, lean prose, and sensible section organization with no bundle to mis-navigate. Its main weakness is the absence of any sequenced workflow with validation checkpoints — appropriate sections exist (notably testing and migrations) but are presented as parallel topics rather than ordered steps with feedback loops.

Suggestions

Add a short sequenced workflow (design entities → map relationships → write repositories → verify with @DataJpaTest + SQL TRACE logs) with explicit validation checkpoints, so the topic sections hang off an ordered process.

Trim the closing 'Remember:' recap paragraph and tighten the Hibernate 6 version-specific aside (or move it to a notes/pitfalls section) to remove the last padding.

Consider moving the larger reference blocks (full auditing/entity pattern, HikariCP + LOB properties, testing configuration) into a single one-level-deep reference file to keep SKILL.md as a leaner overview.

DimensionReasoningScore

Conciseness

The body is lean and pattern-dense — mostly executable code and terse bullet lists with almost no explanation of concepts Claude already knows. Minor trimmable padding keeps it below a 5: the closing '**Remember**: Keep entities lean...' recap paragraph and the somewhat hedged version-specific aside 'Hibernate 6+ applies de-duplication automatically in some cases'.

4 / 5

Actionability

Nearly every section provides copy-paste ready material: a complete annotated entity, a JOIN FETCH repository query, an interface projection, a @Transactional service method, a PageRequest snippet, HikariCP properties, and concrete logging.level keys for SQL tracing. This matches the anchor 'Fully executable; copy-paste ready code or commands; specific examples cover the common cases'.

5 / 5

Workflow Clarity

The content is organized as a topic-organized pattern catalog rather than a sequenced workflow — there is no design→implement→validate order, and checkpoints are only implicit (the 'Testing Data Access' section with @DataJpaTest/Testcontainers and SQL log levels serves as an after-the-fact validation reference, not an inline step). The simple-skill exception does not apply (145 lines, multi-topic), so this sits at the anchor 'Steps listed but validation gaps; sequence present but checkpoints missing or implicit' at best.

3 / 5

Progressive Disclosure

No bundle files exist (no references/, scripts/, or assets/ directories), and at ~145 lines the single-file structure is reasonable with clear, well-ordered section headers (Entity Design → Relationships → Repository → Transactions → Pagination → Indexing → Pooling → Caching → Migrations → Testing). Not a 5 because a few sections (full entity/auditing patterns, HikariCP configuration, testing setup) are at the size where a one-level-deep reference file would keep SKILL.md even leaner.

4 / 5

Total

16

/

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, well-scoped description that clearly communicates what the skill covers, but it omits any explicit 'Use when...' trigger guidance, which both caps completeness and weakens its usefulness for skill selection. Adding trigger phrases and natural synonyms like 'N+1 problem', 'lazy loading', and 'HikariCP' would close the remaining gaps.

Suggestions

Append an explicit trigger clause, e.g. 'Use when designing JPA entities, mapping relationships, fixing N+1 or lazy-loading issues, or tuning HikariCP pooling in Spring Boot.'

Include natural trigger synonyms users actually say — 'N+1 problem', 'lazy loading', 'repository methods', 'HikariCP' — to improve trigger-term coverage and distinctiveness.

Phrase capabilities as concrete actions (e.g. 'Map entities and relationships, prevent N+1 queries with fetch joins and projections') rather than topic noun lists.

DimensionReasoningScore

Specificity

Lists several concrete capability areas — 'entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling' — which names specific JPA concerns rather than vague language. Not a 5 because these are domain topics phrased as noun phrases rather than explicit actions, and a couple of natural areas (e.g., N+1, lazy loading, HikariCP) are folded into generic wording.

4 / 5

Completeness

The 'what' is clear (patterns for a enumerated set of JPA concerns), but there is no 'Use when...' clause or equivalent explicit trigger guidance anywhere in the description, which caps completeness at 3 per the judging guidelines. It fits the anchor 'Has a clear what but when is missing' exactly.

3 / 5

Trigger Term Quality

Good natural keywords users would say: 'JPA', 'Hibernate', 'Spring Boot', 'entity', 'relationships', 'pagination', 'transactions', 'pooling'. A few commonly-said phrases are missing, such as 'N+1', 'lazy loading', 'repository', or 'HikariCP', which keeps it below the comprehensive synonym coverage of a 5.

4 / 5

Distinctiveness Conflict Risk

The pairing of 'JPA/Hibernate' with 'in Spring Boot' carves a clear niche with distinct triggers, unlikely to fire for unrelated skills. Minor overlap risk remains with closely related skills such as a generic Spring Boot or SQL/database tuning skill.

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
affaan-m/ECC
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.