How does this skill help prevent N+1 query issues?

It provides patterns for using JOIN FETCH in JPQL and DTO projections to ensure that related entities are fetched efficiently in a single database round-trip.

Does it include configuration for connection pooling?

Yes, it provides recommended production-ready properties for HikariCP, including pool size, timeout settings, and PostgreSQL-specific LOB handling.

Can this skill help with database migrations?

Yes, it recommends and provides patterns for using Flyway or Liquibase to manage versioned, idempotent database migrations instead of relying on Hibernate auto-DDL.

Is this skill limited to Spring Boot applications?

While the implementation examples focus on Spring Boot and Spring Data JPA, the core JPA and Hibernate patterns are applicable to any Java-based persistence layer.

JPA Patterns & Hibernate Optimization

Name: JPA Patterns & Hibernate Optimization
Author: affaan-m

byaffaan-m

•

43,117

데이터베이스 관리

Implements industry-standard JPA and Hibernate patterns for high-performance Spring Boot data layers.

소개

This skill equips Claude with specialized knowledge of JPA and Hibernate best practices to streamline database development in Spring Boot applications. It provides expert guidance on entity design, complex relationship mapping, transaction management, and performance tuning strategies like N+1 prevention and connection pooling. Whether you are building new repositories from scratch or optimizing existing data access layers, this skill ensures your persistence tier is scalable, efficient, and follows modern software engineering principles.

주요 기능

Optimized repository patterns including DTO projections and pagination
Efficient relationship mapping with N+1 query prevention strategies
Advanced entity design with automated auditing and custom indexing
43,117 GitHub stars
Fine-tuned transaction management and HikariCP connection pooling
Best practices for database migrations using Flyway or Liquibase

사용 사례

Refactoring legacy JPA code to resolve performance bottlenecks and query issues
Designing a scalable database schema and entity model for a microservice
Setting up robust database testing environments using DataJpaTest and Testcontainers

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code jpa-patterns

For use in Claude.ai and ChatGPT

Download Skill

GitHub

소개