Can it help with database migrations?

Yes, it provides guidance on using tools like Flyway or Liquibase instead of Hibernate auto-DDL to ensure safe, additive, and idempotent production migrations.

How does this skill help with N+1 query problems?

The skill provides patterns for using JOIN FETCH in JPQL and DTO projections to ensure associated data is loaded efficiently in a single database round-trip.

Does it include connection pool settings?

Yes, it offers recommended HikariCP configurations for maximum pool size, idle timeouts, and validation intervals to ensure high availability.

How does it improve entity design?

It implements standardized annotations for auditing (CreatedDate/LastModifiedDate), indexing strategy, and proper ID generation to keep entities lean.

JPA & Hibernate Patterns

Name: JPA & Hibernate Patterns
Author: LuciferDono

byLuciferDono

•

数据库管理

Optimizes Spring Boot data layers with standardized JPA/Hibernate patterns for entities, repositories, and performance tuning.

This Claude Code skill provides comprehensive guidance for designing robust and performant data access layers in Spring Boot applications using JPA and Hibernate. It automates best practices for entity mapping, complex relationship management, and transaction configuration while specifically addressing common performance pitfalls like N+1 query problems. By utilizing fetch strategies, DTO projections, and optimized indexing patterns, this skill ensures that database interactions remain efficient, scalable, and maintainable across production environments.

主要功能

01Advanced relationship mapping techniques to prevent N+1 query issues

02Data access testing guidelines using Testcontainers and SQL logging

03Standardized entity design with built-in auditing and indexing patterns

04Repository optimization using JPQL, projections, and pagination

051 GitHub stars

06Transaction management strategies and HikariCP connection pool tuning

使用场景

01Refactoring legacy repositories to eliminate performance bottlenecks and slow queries

02Configuring production-ready database connection pooling and migration workflows

03Architecting a new Spring Boot data layer with scalable entity relationships

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs jpa-patterns

For use in Claude.ai and ChatGPT