jpa-patterns
JPA/Hibernate patterns for entity design, relationships, query optimization
by affaan-mFree
Description
jpa-patterns is an agent skill from the ECC collection by affaan-m, listed on skills.sh. It covers JPA and Hibernate patterns for data modelling and performance tuning in Spring Boot. Its topics include designing entities and table mappings, relationships such as one-to-many, many-to-one and many-to-many, query optimisation with N+1 prevention, fetch strategies and projections, transactions, auditing and soft deletes, pagination, sorting and custom repository methods, indexing, connection pooling with HikariCP, and second-level caching. The skill applies when designing entities, defining relationships, tuning slow queries, configuring transactions or auditing, setting up pagination, or tuning the pool and cache. Because it is a SKILL.md file of instructions, an AI agent loads it for those tasks and applies the same practices each time. It is free and open source, and the skills.sh listing shows all three security audits passing.…
Highlights
- Entity design and relationship mapping
- N+1 prevention and fetch strategies
- Transactions, auditing and soft deletes
- HikariCP pooling and second-level cache
Ratings & Reviews
No ratings yet
Be the first to rate jpa-patterns.
People also visit
database-migrations
Safe, reversible database migration patterns: forward-only production changes
java-coding-standards
Java coding standards for Spring Boot and Quarkus services: naming
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
jpa-patterns FAQ
What does the jpa-patterns skill do?
It guides an agent in designing JPA and Hibernate entities and tuning their queries, transactions and pooling in Spring Boot.
Does it cover the N+1 query problem?
Yes. N+1 prevention is one of its listed topics, along with fetch strategies and projections.
What about caching and pooling?
The skill covers HikariCP connection pooling and second-level caching.
How do I install it?
Run: npx skills add https://github.com/affaan-m/ecc --skill jpa-patterns
Is it free?
Yes. It is free and open source.
Are there security findings?
The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.
What are the best jpa-patterns alternatives?
Popular alternatives to jpa-patterns include clickhouse-io, database-migrations and java-coding-standards. See all jpa-patterns alternatives