CtrlK
BlogDocsLog inGet started
Tessl Logo

jpa-patterns

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

73

1.26x
Quality

63%

Does it follow best practices?

Impact

86%

1.26x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./docs/zh-CN/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.

The body is a concise, well-organized JPA patterns catalog with concrete, mostly executable code examples across entity design, relations, queries, transactions, and tuning. Its main gap is the absence of explicit validation checkpoints or feedback loops in workflows, which caps workflow_clarity at 3.

Suggestions

Add explicit validation/checkpoint steps where operations are batch or persistence-sensitive — e.g. after migration scripts or before bulk saves, note how to verify the result.

Make code fragments copy-paste ready: include imports/context for snippets like 'PageRequest page' and show how the projection interface is wired into a repository method.

Add a short 'N+1 verification' loop: enable SQL logging, run the query, confirm one SQL statement, then fix if multiple — turning the testing note into a concrete feedback workflow.

DimensionReasoningScore

Conciseness

Lean bullet-plus-code style that assumes JPA knowledge and avoids explaining basics; only minor padding in the intro and a few section openers could be trimmed.

4 / 5

Actionability

Provides concrete, executable Java and .properties snippets covering entity design, JOIN FETCH, projections, pagination, and HikariCP; minor gaps — a few fragments (e.g. 'PageRequest page' without imports, the projection interface used only as a type hint) need surrounding context to be fully copy-paste ready — keep it below 5.

4 / 5

Workflow Clarity

Sections are organized and list patterns, but there is no sequenced multi-step workflow with validation checkpoints; the testing section notes Testcontainers and SQL logging but lacks a validate→fix→retry loop, so it sits at the 3 anchor.

3 / 5

Progressive Disclosure

Single well-organized file with clear section headers and no nested references; bulk pattern content is appropriate inline, with only minor organization gaps. Per the simple-skill guidance, a self-contained file scores well here.

4 / 5

Total

15

/

20

Passed

Description

58%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.

The description is specific and well-scoped to JPA/Hibernate in Spring Boot, naming eight concrete capability areas in third person. Its main weakness is the absence of an explicit 'Use when...' trigger clause, which caps completeness at 3.

Suggestions

Add an explicit 'Use when...' clause, e.g. 'Use when designing JPA entities, modeling relationships, fixing N+1 issues, or tuning Spring Boot data access.'

Include natural trigger terms users actually say — 'N+1 problem', 'lazy loading', 'repositories', 'HikariCP', 'JPQL' — to improve trigger_term_quality.

Mention file/annotation cues (e.g. '@Entity', 'application.properties') so the description is even more distinguishable from generic SQL skills.

DimensionReasoningScore

Specificity

Names the domain (Spring Boot JPA/Hibernate) and enumerates eight concrete capability areas — '实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池' — covering most of the JPA surface with only minor gaps.

4 / 5

Completeness

Clearly states the 'what' across eight areas but has no 'Use when...' clause or equivalent trigger guidance, so per the rubric guideline completeness is capped at 3.

3 / 5

Trigger Term Quality

Contains relevant terms ('实体设计', '关系处理', '查询优化', '事务管理', '分页') but omits common natural synonyms/variations a user might say (e.g. 'N+1', 'repository', 'HikariCP', 'lazy loading').

3 / 5

Distinctiveness Conflict Risk

The JPA/Hibernate + Spring Boot framing carves a clear niche with distinct triggers; only minor overlap risk with broader Spring or SQL skills.

4 / 5

Total

14

/

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.

Validation15 / 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.