Does it provide configuration for connection pooling?

Yes, it includes recommended properties for HikariCP, including pool size, timeout settings, and validation intervals optimized for production environments.

Can I use this for database migrations?

It advocates for and provides patterns for using Flyway or Liquibase instead of Hibernate's auto-DDL to ensure safe, idempotent schema updates.

How does this skill help with the N+1 select problem?

The skill provides specific implementation patterns using JOIN FETCH in JPQL and DTO projections to ensure related entities are loaded efficiently in a single query.

What transaction strategies does it support?

It covers @Transactional usage, including read-only optimizations for query paths and careful selection of propagation levels to avoid long-running transactions.

JPA & Hibernate Patterns

Name: JPA & Hibernate Patterns
Author: unju-ai

byunju-ai

0•

데이터베이스 관리

Implements optimized JPA and Hibernate patterns for high-performance Spring Boot data persistence and entity management.

This skill provides specialized guidance for Spring Boot developers working with JPA and Hibernate to build scalable, performant data layers. It offers implementation patterns for complex entity relationships, N+1 query prevention, transaction management strategies, and database indexing. Whether you are designing a new schema or tuning an existing one, this skill helps you apply best practices for connection pooling, auditing, and efficient pagination to ensure robust database interactions.

주요 기능

01N+1 problem prevention using JOIN FETCH and DTO projections

02Optimized entity design with automated JPA auditing and indexing

03Advanced repository patterns with cursor-based and offset pagination

04Transaction management best practices for data integrity and speed

050 GitHub stars

06Performance tuning via HikariCP pooling and Hibernate batch processing

사용 사례

01Configuring automated database migrations and integration testing with Testcontainers

02Designing production-grade relational schemas for Spring Boot applications

03Refactoring legacy data access layers to eliminate performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add unju-ai/ecc jpa-patterns

For use in Claude.ai and ChatGPT