Agent skill

Jpa Patterns

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

MITAuto-check passedDatabases

Install Jpa Patterns

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/jpa-patterns .claude/skills/jpa-patterns && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .claude/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/jpa-patterns .agents/skills/jpa-patterns && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .agents/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/jpa-patterns .cursor/skills/jpa-patterns && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .cursor/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/affaan-m/ECC.git --path skills/jpa-patterns

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/jpa-patterns .gemini/skills/jpa-patterns && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .gemini/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/jpa-patterns .github/skills/jpa-patterns && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .github/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add affaan-m/ECC --skill jpa-patterns -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install affaan-m/ECC jpa-patterns --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/affaan-m/ECC.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/jpa-patterns .opencode/skills/jpa-patterns && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "jpa-patterns" agent skill from https://github.com/affaan-m/ECC/tree/main/skills/jpa-patterns into .opencode/skills/jpa-patterns/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-patterns", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: jpa-patterns
GitHub stars: 277k
Used in: 5 other repos
Token cost: ~1.2k tokens
SKILL.md length: 252 words
Files: 1
Skills in repo: 683
Repo updated: Oct 11, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

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

Designing JPA entities
SKILL.md covers When to Activate, Entity Design, Relationships and N+1 Prevention and Repository Patterns, plus 7 more sections
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
A Hibernate query

What it does

Jpa Patterns is an agent skill from affaan-m/ECC. JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot. Use when designing JPA entities or relationships, or when a Hibernate query, transaction, or N+1 problem needs fixing.

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering ORMs and data access, Database schema design and Backend development. It works with Spring Boot. The repository describes itself as: The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond. The licence is MIT.

When your agent uses it

Designing JPA entities
A Hibernate query
N+1 problem needs fixing

Example prompts

“/jpa-patterns”

What it can do on your machine

Read from SKILL.md and the folder at commit 2d515e4. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are java).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Jpa Patterns loads about 1.2k tokens when it runs. Until then it costs about 71 tokens; SKILL.md has 252 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~71
When it runs · the whole SKILL.md, loaded when a task matches: ~1.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from affaan-m/ECC at commit 2d515e4, republished under its MIT licence (© affaan-m). 252 words, ~1,170 tokens.

Download SKILL.mdSave it as .claude/skills/jpa-patterns/SKILL.md (or your agent's skills folder).

name: jpa-patterns
description: JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot. Use when designing JPA entities or relationships, or when a Hibernate query, transaction, or N+1 problem needs fixing.
metadata.origin: ECC

JPA/Hibernate Patterns

Use for data modeling, repositories, and performance tuning in Spring Boot.

When to Activate

Designing JPA entities and table mappings
Defining relationships (@OneToMany, @ManyToOne, @ManyToMany)
Optimizing queries (N+1 prevention, fetch strategies, projections)
Configuring transactions, auditing, or soft deletes
Setting up pagination, sorting, or custom repository methods
Tuning connection pooling (HikariCP) or second-level caching

Entity Design

java

@Entity
@Table(name = "markets", indexes = {
  @Index(name = "idx_markets_slug", columnList = "slug", unique = true)
})
@EntityListeners(AuditingEntityListener.class)
public class MarketEntity {
  @Id @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;

  @Column(nullable = false, length = 200)
  private String name;

  @Column(nullable = false, unique = true, length = 120)
  private String slug;

  @Enumerated(EnumType.STRING)
  private MarketStatus status = MarketStatus.ACTIVE;

  @CreatedDate private Instant createdAt;
  @LastModifiedDate private Instant updatedAt;
}

Enable auditing:

java

@Configuration
@EnableJpaAuditing
class JpaConfig {}

Relationships and N+1 Prevention

java

@OneToMany(mappedBy = "market", cascade = CascadeType.ALL, orphanRemoval = true)
private List<PositionEntity> positions = new ArrayList<>();

Default to lazy loading; use JOIN FETCH in queries when needed
Avoid EAGER on collections; use DTO projections for read paths

java

@Query("select m from MarketEntity m left join fetch m.positions where m.id = :id")
Optional<MarketEntity> findWithPositions(@Param("id") Long id);

Repository Patterns

java

public interface MarketRepository extends JpaRepository<MarketEntity, Long> {
  Optional<MarketEntity> findBySlug(String slug);

  @Query("select m from MarketEntity m where m.status = :status")
  Page<MarketEntity> findByStatus(@Param("status") MarketStatus status, Pageable pageable);
}

Use projections for lightweight queries:

java

public interface MarketSummary {
  Long getId();
  String getName();
  MarketStatus getStatus();
}
Page<MarketSummary> findAllBy(Pageable pageable);

Transactions

Annotate service methods with @Transactional
Use @Transactional(readOnly = true) for read paths to optimize
Choose propagation carefully; avoid long-running transactions

java

@Transactional
public Market updateStatus(Long id, MarketStatus status) {
  MarketEntity entity = repo.findById(id)
      .orElseThrow(() -> new EntityNotFoundException("Market"));
  entity.setStatus(status);
  return Market.from(entity);
}

Pagination

java

PageRequest page = PageRequest.of(pageNumber, pageSize, Sort.by("createdAt").descending());
Page<MarketEntity> markets = repo.findByStatus(MarketStatus.ACTIVE, page);

For cursor-like pagination, include id > :lastId in JPQL with ordering.

Indexing and Performance

Add indexes for common filters (status, slug, foreign keys)
Use composite indexes matching query patterns (status, created_at)
Avoid select *; project only needed columns
Batch writes with saveAll and hibernate.jdbc.batch_size

Connection Pooling (HikariCP)

Recommended properties:

spring.datasource.hikari.maximum-pool-size=20
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.validation-timeout=5000

For PostgreSQL LOB handling, add:

spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

Caching

1st-level cache is per EntityManager; avoid keeping entities across transactions
For read-heavy entities, consider second-level cache cautiously; validate eviction strategy

Migrations

Use Flyway or Liquibase; never rely on Hibernate auto DDL in production
Keep migrations idempotent and additive; avoid dropping columns without plan

Testing Data Access

Prefer @DataJpaTest with Testcontainers to mirror production
Assert SQL efficiency using logs: set logging.level.org.hibernate.SQL=DEBUG and logging.level.org.hibernate.orm.jdbc.bind=TRACE for parameter values

Remember: Keep entities lean, queries intentional, and transactions short. Prevent N+1 with fetch strategies and projections, and index for your read/write paths.

Files

Just SKILL.md in skills/jpa-patterns of affaan-m/ECC.

Open the folder on GitHubat commit 2d515e4

Used in 5 other repositories

We found 13 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 5 other GitHub owners. This page covers the copy in affaan-m/ECC, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Jpa Patterns next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Jpa Patterns compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Jpa Patterns this skillaffaan-m/ECC	277k	5 repos	~1.2k	Automated safety check: Pass	MIT	today
Prisma Expertdavila7/claude-code-templates	33k	7 repos	~2.6k	Automated safety check: Pass	MIT	today
Hibernate Upgradebenchflow-ai/skillsbench	1.8k	—	~1.9k	Automated safety check: Pass	Apache-2.0	2 mo ago
Jpa Hibernate OptimizationHack23/cia	239	—	~531	Automated safety check: Pass	Apache-2.0	yesterday
Jpa Patternsxu-xiang/everything-claude-code-zh	2k	—	~896	Automated safety check: Pass	MIT	7 mo ago
DB SculptorEliasOulkadi/shokunin	114	—	~3.1k	Automated safety check: Notes	MIT	6 days ago

Similar skills

Prisma Expert
davila7/claude-code-templates
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations.
33k GitHub starsUsed in 7 repos~2.6k tokens
DatabasesAuto-check passed
Hibernate Upgrade
benchflow-ai/skillsbench
Migrate Hibernate 5 to Hibernate 6 with Spring Boot 3. An agent skill from benchflow-ai/skillsbench.
1.8k GitHub stars~1.9k tokensUpdated 2 mo ago
DatabasesAuto-check passed
Jpa Hibernate Optimization
Hack23/cia
Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
239 GitHub stars~531 tokensUpdated yesterday
DatabasesAuto-check passed
Jpa Patterns
xu-xiang/everything-claude-code-zh
Spring Boot 中用于实体设计、关联关系、查询优化、事务、审计、索引、分页和连接池的 JPA/Hibernate 模式。
2k GitHub stars~896 tokensUpdated 7 mo ago
DatabasesAuto-check passed
DB Sculptor
EliasOulkadi/shokunin
Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…
114 GitHub stars~3.1k tokensUpdated 6 days ago
DatabasesAuto-check: notes
Discover Database
rand/cc-polymath
Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection.
181 GitHub stars~2k tokensUpdated 7 mo ago
DatabasesAuto-check passed

Questions about Jpa Patterns

What does Jpa Patterns do?

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot. Jpa Patterns is an agent skill from affaan-m/ECC. JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

When should I use Jpa Patterns?

Jpa Patterns fits situations like: designing JPA entities; A Hibernate query; N+1 problem needs fixing.

How do I install Jpa Patterns in Claude Code?

Run `npx skills add affaan-m/ECC --skill jpa-patterns -a claude-code`. Or copy the skill folder (skills/jpa-patterns in affaan-m/ECC) into .claude/skills/jpa-patterns in your project. Claude Code loads it when a task matches its description.

How do I install Jpa Patterns in Codex?

Run `npx skills add affaan-m/ECC --skill jpa-patterns -a codex`. Or copy the skill folder (skills/jpa-patterns in affaan-m/ECC) into .agents/skills/jpa-patterns in your project. Codex loads it when a task matches its description.

Can I use Jpa Patterns in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add affaan-m/ECC --skill jpa-patterns -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/jpa-patterns, .gemini/skills/jpa-patterns, .github/skills/jpa-patterns and .opencode/skills/jpa-patterns in your project.

What does Jpa Patterns need to run?

SKILL.md names no scripts, command-line tools or credentials: Jpa Patterns is instructions for the agent only.

Does Jpa Patterns access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Jpa Patterns safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Jpa Patterns use?

Jpa Patterns is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Jpa Patterns use?

About 1.2k tokens (SKILL.md is roughly 4.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Jpa Patterns?

Skills that share tags, products or a category with Jpa Patterns: Prisma Expert (davila7/claude-code-templates, 33k stars), Hibernate Upgrade (benchflow-ai/skillsbench, 1.8k stars), Jpa Hibernate Optimization (Hack23/cia, 239 stars) and Jpa Patterns (xu-xiang/everything-claude-code-zh, 2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Jpa Patterns?

affaan-m (a GitHub user) maintains it in affaan-m/ECC, which has 276,673 GitHub stars. The repository holds 683 skills in this directory. The repository was last updated on October 11, 2026.

Source: affaan-m/ECC on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Jpa Patterns

Facts

At a glance

What it does

When your agent uses it

Example prompts

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

JPA/Hibernate Patterns

When to Activate

Entity Design

Relationships and N+1 Prevention

Repository Patterns

Transactions

Pagination

Indexing and Performance

Connection Pooling (HikariCP)

Caching

Migrations

Testing Data Access

Files

Used in 5 other repositories

Compare with similar skills

Similar skills

More from affaan-m/ECC

Related

Questions about Jpa Patterns