Does this include database migration guidance?

Yes, it covers best practices for using Flyway or Liquibase to maintain idempotent and versioned schema changes rather than relying on auto-DDL.

Can this skill assist with performance tuning?

Absolutely. It includes recommendations for HikariCP connection pooling, indexing strategies, and batch processing settings.

Is this skill specific to a certain database?

The patterns are general to JPA/Hibernate, but it includes specific optimizations for PostgreSQL and Spring Boot configurations.

How do I implement auditing with this skill?

The skill provides ready-to-use code snippets for @EntityListeners and @EnableJpaAuditing to automatically track creation and modification dates.

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

It provides patterns for using JOIN FETCH and DTO projections to load related data efficiently in a single query instead of multiple round-trips.

JPA & Hibernate Best Practices

Name: JPA & Hibernate Best Practices
Author: LuciferDono

byLuciferDono

•

Database Management

Provides standardized JPA and Hibernate patterns for high-performance Spring Boot data modeling and persistence.

This skill equips Claude with the expertise to design and optimize data persistence layers in Spring Boot applications using JPA and Hibernate. It offers comprehensive guidance on entity design, relationship management (N+1 prevention), transaction handling, indexing, and connection pooling, specifically localized for Japanese development environments. By implementing these battle-tested patterns, developers can ensure their database interactions are scalable, maintainable, and optimized for production-grade performance.

Key Features

01N+1 query prevention via JOIN FETCH and DTO projections

02Advanced entity design including auditing and custom indexing

03Production-ready HikariCP connection pool configurations

04Standardized pagination patterns including cursor-based navigation

051 GitHub stars

06Optimized transaction management and propagation strategies

Use Cases

01Building high-performance Spring Boot backends with optimized data access

02Refactoring legacy JPA code to resolve N+1 performance bottlenecks

03Implementing standardized entity auditing and database migration workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs jpa-patterns

For use in Claude.ai and ChatGPT