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

The skill provides patterns for identifying EAGER loading risks and recommends using JOIN FETCH in JPQL or DTO projections for specific read paths to ensure efficient data retrieval.

Does it support advanced JPA features like auditing?

Yes, it provides implementation details for JpaAuditing, including @CreatedDate, @LastModifiedDate, and entity listener configurations.

Does it include database migration best practices?

Yes, it promotes the use of versioned migration tools like Flyway or Liquibase and advises against using Hibernate's automatic DDL generation in production environments.

Can this skill help with database connection pooling?

Absolutely. It includes recommended HikariCP configurations for connection timeouts, pool sizes, and validation intervals to ensure stable database connectivity.

JPA/Hibernate Patterns

Name: JPA/Hibernate Patterns
Author: xu-xiang

byxu-xiang

•

323

•

Gestión de Bases de Datos

Optimizes Spring Boot data modeling and database performance using standardized JPA and Hibernate implementation patterns.

The jpa-patterns skill provides a comprehensive set of best practices and implementation blueprints for Spring Boot applications using JPA and Hibernate. It guides Claude in designing robust entity models, preventing common performance pitfalls like the N+1 select problem, and configuring efficient transaction management. Whether you are setting up complex table relationships, optimizing query performance with DTO projections, or configuring connection pools and auditing, this skill ensures your database layer is production-ready, scalable, and follows industry standards for modern Java development.

Características Principales

01Expert JPA entity design and relationship mapping (@OneToMany, @ManyToOne) guidance.

02Optimized repository patterns and custom JPQL query development.

03Database performance tuning including indexing strategies and HikariCP optimization.

04323 GitHub stars

05Proactive N+1 problem prevention using JOIN FETCH and DTO projections.

06Advanced transaction management, auditing, and soft-delete configuration.

Casos de Uso

01Refactoring legacy data access layers to eliminate performance bottlenecks and slow queries.

02Implementing standardized database migrations and automated auditing for enterprise applications.

03Designing complex relational database schemas for high-concurrency Spring Boot services.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-xiang/everything-claude-code-zh jpa-patterns

For use in Claude.ai and ChatGPT

Características Principales

01Expert JPA entity design and relationship mapping (@OneToMany, @ManyToOne) guidance.

02Optimized repository patterns and custom JPQL query development.

03Database performance tuning including indexing strategies and HikariCP optimization.

04323 GitHub stars

05Proactive N+1 problem prevention using JOIN FETCH and DTO projections.

06Advanced transaction management, auditing, and soft-delete configuration.

Casos de Uso

01Refactoring legacy data access layers to eliminate performance bottlenecks and slow queries.

02Implementing standardized database migrations and automated auditing for enterprise applications.

03Designing complex relational database schemas for high-concurrency Spring Boot services.