Does it support database migrations?

Yes, it promotes the use of Flyway and Liquibase over Hibernate's auto-DDL to ensure safe, idempotent, and version-controlled schema updates.

How does this skill prevent N+1 query issues?

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

Can it help with connection pool configuration?

It includes recommended HikariCP settings for various environments, including specific configurations for timeout management and PostgreSQL LOB handling.

Is it suitable for high-concurrency applications?

Yes, it emphasizes short-lived transactions, read-only optimizations, and strategic indexing to ensure high-traffic Spring Boot services remain responsive.

Does it include testing patterns for the data layer?

It includes guidance for using @DataJpaTest and Testcontainers to verify repository logic and SQL efficiency against production-like database instances.

JPA & Hibernate Patterns

Name: JPA & Hibernate Patterns
Author: x-cmd

byx-cmd

•

Database Management

Implements optimized Spring Boot data access layers using Hibernate best practices for entity design, performance tuning, and query efficiency.

This skill provides Claude with comprehensive patterns for Java Persistence API (JPA) and Hibernate within Spring Boot applications. It helps developers design robust entity models, prevent common performance pitfalls like N+1 queries through fetch strategies and DTO projections, and configure high-performance connection pooling with HikariCP. From setting up auditing with @CreatedDate to implementing cursor-based pagination and database migrations using Flyway or Liquibase, it ensures that your data layer is scalable, maintainable, and production-ready.

Key Features

01Optimized Entity Design with auditing and custom indexing

029 GitHub stars

03N+1 prevention using JOIN FETCH and DTO projections

04Database migration workflows and SQL efficiency testing

05Advanced Repository patterns including custom JPQL and paging

06Transaction management best practices for data integrity

Use Cases

01Setting up a new JPA-based microservice with best-practice entity relationships

02Refactoring a legacy Spring Boot data layer for better performance

03Optimizing slow SQL queries and connection pool settings in production

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add x-cmd/skill jpa-patterns

For use in Claude.ai and ChatGPT

Download Skill