How does this skill help with database performance?

It provides specific patterns for N+1 query prevention using fetch strategies, recommends optimal connection pool settings for HikariCP, and suggests indexing strategies for common query patterns.

Does it support database migrations?

Yes, the skill includes guidance on using Flyway or Liquibase for versioned database migrations rather than relying on Hibernate's auto-DDL features.

Can this skill help with Spring Data repositories?

Absolutely. It covers custom repository methods, pagination, sorting, and the use of projections for lightweight, read-only data access.

Is it limited to specific databases?

While the JPA and Hibernate patterns are generally database-agnostic, it includes specific optimizations for popular RDBMS like PostgreSQL.

Spring Data JPA Patterns

Name: Spring Data JPA Patterns
Author: Fabio29T

byFabio29T

0•

数据库管理

Optimizes Java persistence layers with production-ready JPA and Hibernate design patterns for Spring Boot applications.

This skill equips Claude with expert-level guidance for architecting robust data layers using JPA and Hibernate. It provides specialized knowledge for entity modeling, relationship management, and sophisticated query optimization to eliminate performance bottlenecks like the N+1 problem. From configuring HikariCP connection pools to implementing DTO projections and transactional logic, this skill ensures your Spring Boot database interactions are scalable, maintainable, and aligned with industry best practices.

主要功能

01Database migration best practices with Flyway and Liquibase

02N+1 query prevention using JOIN FETCH and DTO projections

03Expert entity and relationship mapping (@OneToMany, @ManyToOne)

040 GitHub stars

05Advanced pagination, sorting, and cursor-based navigation

06Transactional scoping and read-only optimization

使用场景

01Debugging and fixing Hibernate performance issues or memory leaks

02Designing high-performance database schemas for Spring Boot services

03Refactoring legacy repository code into modern, efficient JPA patterns

主要功能

01Database migration best practices with Flyway and Liquibase

02N+1 query prevention using JOIN FETCH and DTO projections

03Expert entity and relationship mapping (@OneToMany, @ManyToOne)

040 GitHub stars

05Advanced pagination, sorting, and cursor-based navigation

06Transactional scoping and read-only optimization

使用场景

01Debugging and fixing Hibernate performance issues or memory leaks

02Designing high-performance database schemas for Spring Boot services

03Refactoring legacy repository code into modern, efficient JPA patterns