How does this skill help with database performance?

It provides specific patterns for JOIN FETCH and DTO projections to prevent N+1 query issues and ensure that only necessary data is retrieved from the database.

Does it support database migration tools?

Yes, the skill explicitly recommends and provides guidance for using Flyway or Liquibase instead of relying on Hibernate's auto-DDL in production environments.

What connection pool does this skill recommend?

It provides optimized configuration properties for HikariCP, which is the high-performance default connection pool for Spring Boot applications.

Can it help with transaction management?

Absolutely. It includes best practices for @Transactional usage, including read-only optimizations and advice on choosing the correct propagation levels.

Does it cover entity relationships?

Yes, it covers OneToMany and ManyToOne relationships, focusing on lazy loading by default and using specialized queries for eager fetching when required.

Spring Boot JPA & Hibernate Patterns

Name: Spring Boot JPA & Hibernate Patterns
Author: Nixdorfer

byNixdorfer

•

数据库管理

Provides optimized JPA and Hibernate patterns for building high-performance, scalable Spring Boot data layers.

This skill equips Claude with best practices for Spring Boot data persistence, covering everything from entity design and relationship mapping to advanced performance tuning. It helps developers prevent common pitfalls like the N+1 query problem, manage complex transaction boundaries, and implement efficient pagination and indexing strategies. Whether you are setting up a new repository or troubleshooting slow database interactions, this skill ensures your database layer is lean, intentional, and production-ready.

主要功能

01Standardized repository patterns and DTO projections for lightweight queries

02Database connection pooling and HikariCP configuration best practices

03Performance tuning strategies including N+1 prevention and fetch joins

041 GitHub stars

05Optimized entity design with auditing and indexing patterns

06Transaction management guidance and read-only path optimization

使用场景

01Designing scalable and maintainable data models for enterprise Spring Boot applications

02Implementing standardized database migration and auditing workflows

03Refactoring existing repositories to resolve Hibernate performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nixdorfer/claudecodetool jpa-patterns

For use in Claude.ai and ChatGPT

Download Skill