Jpa Patterns
affaan-m/ECC
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Hack23/cia jpa-hibernate-optimization --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .claude/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.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/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .claude/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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 install https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimizationType 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.
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Hack23/cia jpa-hibernate-optimization --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .agents/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .agents/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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.
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Hack23/cia jpa-hibernate-optimization --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .cursor/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .cursor/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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 https://github.com/Hack23/cia.git --path .github/skills/jpa-hibernate-optimization--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Hack23/cia jpa-hibernate-optimization --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .gemini/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.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/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .gemini/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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.
$ gh skill install Hack23/cia jpa-hibernate-optimizationInstalls 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).
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .github/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .github/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.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/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .github/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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.
$ npx skills add Hack23/cia --skill jpa-hibernate-optimization -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Hack23/cia jpa-hibernate-optimization --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Hack23/cia.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.github/skills/jpa-hibernate-optimization .opencode/skills/jpa-hibernate-optimization && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "jpa-hibernate-optimization" agent skill from https://github.com/Hack23/cia/tree/master/.github/skills/jpa-hibernate-optimization into .opencode/skills/jpa-hibernate-optimization/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "jpa-hibernate-optimization", 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.
jpa-hibernate-optimizationOptimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
Jpa Hibernate Optimization is an agent skill from Hack23/cia. Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies
Its SKILL.md is about 530 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, Query optimization and Database schema design. The repository describes itself as: Citizen Intelligence Agency. Open-source intelligence platform analyzing Swedish political activities using AI and data visualization. Tracks politicians, government… The licence is Apache-2.0.
Read from SKILL.md and the folder at commit 6a9797b. It shows what the files ask for, not the result of running them.
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.
No scripts in the folder and no shell commands in SKILL.md (its code samples are java and yaml).
From the folder's file list and the shell code blocks in SKILL.md.
Links to these hosts (documentation or services it may open):
hibernate.orgFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Jpa Hibernate Optimization loads about 531 tokens when it runs. Until then it costs about 30 tokens; SKILL.md has 39 words of instructions outside code blocks.
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.
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.
The full file from Hack23/cia at commit 6a9797b, republished under its Apache-2.0 licence (© Hack23). 39 words, ~531 tokens.
.claude/skills/jpa-hibernate-optimization/SKILL.md (or your agent's skills folder).Optimize database access with proper entity design, query optimization, and caching.
@Entity
@Table(name = "politician", indexes = {
@Index(name = "idx_politician_party", columnList = "party"),
@Index(name = "idx_politician_district", columnList = "district")
})
@Cacheable
@org.hibernate.annotations.Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
public class Politician {
@Id
private String id;
@Column(name = "first_name", nullable = false, length = 50)
private String firstName;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "party_id")
private Party party;
@OneToMany(mappedBy = "politician", cascade = CascadeType.ALL, orphanRemoval = true)
@BatchSize(size = 20)
private List<VotingRecord> votingRecords;
}// Use JOIN FETCH to prevent N+1
@Query("SELECT p FROM Politician p JOIN FETCH p.party WHERE p.district = :district")
List<Politician> findByDistrictWithParty(@Param("district") String district);
// Use DTOs for read-only queries
@Query("SELECT new com.hack23.cia.dto.PoliticianSummary(p.id, p.firstName, p.lastName) " +
"FROM Politician p WHERE p.active = true")
List<PoliticianSummary> findActivePoliticiansSummary();
// Pagination for large result sets
Page<Politician> findByParty(String party, Pageable pageable);spring:
jpa:
properties:
hibernate:
cache:
use_second_level_cache: true
region:
factory_class: org.hibernate.cache.jcache.JCacheRegionFactory
javax:
cache:
provider: org.ehcache.jsr107.EhcacheCachingProvider© Hack23, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in .github/skills/jpa-hibernate-optimization of Hack23/cia.
Open the folder on GitHubat commit 6a9797b
Jpa Hibernate Optimization 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Jpa Hibernate Optimization this skillHack23/cia | 239 | — | ~531 | Automated safety check: Pass | Apache-2.0 | |
| Jpa Patternsaffaan-m/ECC | 274k | 5 repos | ~1.2k | Automated safety check: Pass | MIT | |
| Prisma Expertdavila7/claude-code-templates | 32k | 6 repos | ~2.6k | Automated safety check: Pass | MIT | |
| Performancekid-sid/claude-spellbook | 189 | — | ~3.8k | Automated safety check: Pass | MIT | |
| Relational Data Modelingpproenca/dot-skills | 214 | — | ~2.4k | Automated safety check: Pass | MIT | |
| DB SculptorEliasOulkadi/shokunin | 114 | — | ~3.1k | Automated safety check: Notes | MIT |
affaan-m/ECC
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
davila7/claude-code-templates
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations.
kid-sid/claude-spellbook
A skill your agent uses when diagnosing a slow HTTP endpoint or high-latency service — profiling, adding an application-level cache, offloading CPU-bound work to threads or workers, or defining a…
pproenca/dot-skills
Corrects the wrong defaults a model has when designing a relational schema — the DDL decisions an experienced engineer makes differently.
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…
modu-ai/moai-adk
Database guidance for PostgreSQL, MongoDB, Redis and Oracle plus Neon, Supabase and Firestore: schema design, indexing, query tuning and cloud database choice.
Hack23/cia
WCAG 2.1 AA compliance, ARIA attributes, keyboard navigation, screen reader optimization for accessible political data platforms
Hack23/cia
Advanced chart types, D3.js/Vaadin Charts patterns, political data visualization, time series analysis
Hack23/cia
AI governance, EU AI Act compliance, OWASP LLM security, responsible AI practices for GitHub Copilot agents
Hack23/cia
External API integration patterns, retry logic, circuit breakers, caching, rate limiting for government data APIs
Hack23/cia
AWS CloudWatch metrics, alarms, dashboards, log insights, and application monitoring for the CIA platform
Hack23/cia
AWS security best practices, VPC security, IAM, KMS, CloudTrail, GuardDuty for CIA platform deployment
Categories
Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies. Jpa Hibernate Optimization is an agent skill from Hack23/cia.
Jpa Hibernate Optimization fits situations like: tasks that involve ORMs and data access; tasks that involve Query optimization; tasks that involve Database schema design.
Run `npx skills add Hack23/cia --skill jpa-hibernate-optimization -a claude-code`. Or copy the skill folder (.github/skills/jpa-hibernate-optimization in Hack23/cia) into .claude/skills/jpa-hibernate-optimization in your project. Claude Code loads it when a task matches its description.
Run `npx skills add Hack23/cia --skill jpa-hibernate-optimization -a codex`. Or copy the skill folder (.github/skills/jpa-hibernate-optimization in Hack23/cia) into .agents/skills/jpa-hibernate-optimization in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add Hack23/cia --skill jpa-hibernate-optimization -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-hibernate-optimization, .gemini/skills/jpa-hibernate-optimization, .github/skills/jpa-hibernate-optimization and .opencode/skills/jpa-hibernate-optimization in your project.
SKILL.md names no scripts, command-line tools or credentials: Jpa Hibernate Optimization is instructions for the agent only.
SKILL.md names 1 domain. As links in the text: hibernate.org. This is read from the text; nothing was executed.
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.
Jpa Hibernate Optimization is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
About 531 tokens (SKILL.md is roughly 2.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Jpa Hibernate Optimization: Jpa Patterns (affaan-m/ECC, 274k stars), Prisma Expert (davila7/claude-code-templates, 32k stars), Performance (kid-sid/claude-spellbook, 189 stars) and Relational Data Modeling (pproenca/dot-skills, 214 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Hack23 (a GitHub organization) maintains it in Hack23/cia, which has 239 GitHub stars. The repository holds 78 skills in this directory. The repository was last updated on October 6, 2026.
Source: Hack23/cia on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.