Does it include database migration guidance?

Yes, it provides best practices for using Flyway or Liquibase to manage schema changes incrementally rather than relying on Hibernate's auto-DDL.

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

The skill provides specific implementation patterns using JOIN FETCH and DTO projections to ensure that related entities are loaded efficiently in a single query.

Can I use this for performance tuning?

Absolutely. It covers indexing strategies, connection pool (HikariCP) optimization, and Hibernate batch size configurations for high-throughput applications.

Is the documentation available in Japanese?

Yes, this skill is part of the docs-ja-JP plugin, providing detailed guidance and patterns in Japanese for local development teams.

JPA/Hibernate Patterns

Name: JPA/Hibernate Patterns
Author: affaan-m

byaffaan-m

•

112,910

•

Database Management

Optimizes Spring Boot data layers with expert JPA and Hibernate patterns for entity design, query performance, and transaction management.

The JPA/Hibernate Patterns skill provides Claude with a comprehensive framework for architecting robust and high-performance data access layers in Spring Boot applications. It offers domain-specific guidance on complex tasks such as preventing N+1 query problems, implementing efficient DTO projections, and configuring advanced connection pooling with HikariCP. By following these established patterns for entity relationships, auditing, and indexing, developers can ensure their database interactions are scalable, maintainable, and optimized for production environments.

Key Features

01112,910 GitHub stars

02Performance tuning for HikariCP connection pooling and batch processing

03Best practices for database migrations using Flyway and Liquibase

04Expert N+1 query prevention using JOIN FETCH and DTO projections

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

06Optimized transaction management strategies for read and write paths

Use Cases

01Implementing production-ready database configurations and auditing systems

02Refactoring legacy JPA code to resolve performance bottlenecks and query inefficiencies

03Designing scalable and efficient data models for Spring Boot microservices

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

Key Features

01112,910 GitHub stars

02Performance tuning for HikariCP connection pooling and batch processing

03Best practices for database migrations using Flyway and Liquibase

04Expert N+1 query prevention using JOIN FETCH and DTO projections

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

06Optimized transaction management strategies for read and write paths

Use Cases

01Implementing production-ready database configurations and auditing systems

02Refactoring legacy JPA code to resolve performance bottlenecks and query inefficiencies

03Designing scalable and efficient data models for Spring Boot microservices

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