Does it include database connection pool settings?

Yes, it includes recommended HikariCP configurations for maximum pool size, idle timeouts, and validation settings to ensure stable database connections.

Can I use this for database migrations?

The skill provides guidance on using industry-standard tools like Flyway or Liquibase instead of relying on Hibernate's automatic DDL generation in production.

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

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

Does it cover transaction management?

Yes, it includes patterns for using @Transactional effectively, including read-only optimizations and propagation strategies for service-level methods.

JPA Patterns for Spring Boot

Name: JPA Patterns for Spring Boot
Author: Fabio29T

byFabio29T

0•

数据库管理

Provides domain-specific patterns and best practices for JPA/Hibernate data modeling and performance tuning in Spring Boot applications.

This skill equips Claude with standardized patterns for Java Persistence API (JPA) and Hibernate, specifically tailored for Spring Boot environments. It offers comprehensive guidance on entity design, relationship mapping, N+1 query prevention, and transaction management. It is an essential resource for developers building robust data layers, ensuring efficient database interactions through proper indexing, connection pooling, and auditing configurations while avoiding common pitfalls in persistence logic.

主要功能

01Standardized JPA entity design and table mapping patterns

020 GitHub stars

03Strategies for N+1 query prevention using JOIN FETCH and projections

04Optimized repository patterns including custom queries and paging

05Database performance tuning for indexing and HikariCP connection pools

06Transactional management best practices for consistency and performance

使用场景

01Implementing database auditing and automated migration workflows

02Designing complex relational data models in Spring Boot services

03Optimizing slow database queries and implementing efficient pagination

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude jpa-patterns

For use in Claude.ai and ChatGPT

主要功能

01Standardized JPA entity design and table mapping patterns

020 GitHub stars

03Strategies for N+1 query prevention using JOIN FETCH and projections

04Optimized repository patterns including custom queries and paging

05Database performance tuning for indexing and HikariCP connection pools

06Transactional management best practices for consistency and performance

使用场景

01Implementing database auditing and automated migration workflows

02Designing complex relational data models in Spring Boot services

03Optimizing slow database queries and implementing efficient pagination

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude jpa-patterns

For use in Claude.ai and ChatGPT