How does this skill help prevent N+1 query issues?

The skill provides patterns for using JOIN FETCH in JPQL queries and leveraging DTO projections to ensure that related data is fetched efficiently in a single trip to the database.

What entity design patterns are included?

It covers standard entity mapping, unique constraints, composite indexing, and JPA auditing for automatic 'createdAt' and 'updatedAt' timestamp management.

Can I use this skill to optimize connection pooling?

Absolutely. It includes recommended configurations for HikariCP, including pool size, connection timeouts, and validation settings optimized for production environments.

Does this skill cover database migrations?

Yes, it promotes the use of industry-standard tools like Flyway or Liquibase for additive and idempotent migrations rather than relying on Hibernate's auto-DDL features.

JPA & Hibernate Patterns

Name: JPA & Hibernate Patterns
Author: unju-ai

byunju-ai

0•

Database Management

Provides standardized patterns for JPA and Hibernate entity design, relationship mapping, and performance optimization in Spring Boot applications.

This skill equips Claude with expert-level knowledge of JPA and Hibernate, enabling it to guide developers through complex data modeling and repository implementation in Spring Boot. It focuses on building high-performance data access layers by implementing best practices such as N+1 query prevention, efficient DTO projections, strategic transaction management, and proper database indexing. Whether you are designing a new schema or refactoring an existing codebase for better scalability, this skill ensures your persistence layer is robust, maintainable, and optimized for production environments.

Key Features

01Connection pool tuning and database migration best practices

02Expert JPA entity design with built-in auditing and indexing patterns

030 GitHub stars

04Optimized relationship mapping to prevent N+1 performance issues

05Guidance on transaction propagation and read-only optimizations

06Comprehensive repository patterns including DTO projections and pagination

Use Cases

01Implementing complex pagination and sorting for high-traffic API endpoints

02Designing a scalable data model for a new Spring Boot microservice

03Refactoring existing repositories to resolve SQL performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add unju-ai/ecc jpa-patterns

For use in Claude.ai and ChatGPT