Does it prevent common JPA performance issues?

Yes, it defaults all entity relationships to FetchType.LAZY to prevent unintended data loading and N+1 query problems.

How does it handle database transactions?

It enforces explicit @Transactional annotations on all service methods, emphasizing the use of readOnly=true for search operations to improve performance.

What repository pattern does this skill recommend?

It recommends the Repository Support pattern, which combines a standard JpaRepository interface with a custom Support interface and a QueryDSL-based implementation for complex logic.

Does it support modern Java features?

Yes, it specifically utilizes Java 17+ Records for DTO projections combined with @QueryProjection for type-safe QueryDSL results.

Spring Data JPA & QueryDSL Architect

Name: Spring Data JPA & QueryDSL Architect
Author: Allra-Fintech

byAllra-Fintech

0•

Database Management

Standardizes database schema design, JPA entity mapping, and QueryDSL implementation for robust Spring Boot backends.

This skill provides a comprehensive framework for building database layers in Spring Boot applications following high-performance standards. It guides Claude in creating JPA entities with optimized lazy loading, implementing the Repository Support pattern for complex QueryDSL queries, and managing transactional boundaries effectively. By utilizing modern Java 17+ features like Records for DTO projections and ensuring strict repository interface separation, this skill helps maintain architectural consistency and prevents common ORM pitfalls like N+1 problems or implementation leaks.

Key Features

01Explicit @Transactional management for read/write operation optimization

02Standardized JPA entity mapping with optimized lazy loading (LAZY)

03MariaDB and MySQL compatible database design patterns

04Type-safe DTO projections using Java Records and @QueryProjection

05QueryDSL Repository Support pattern for complex dynamic queries

060 GitHub stars

Use Cases

01Implementing type-safe, maintainable search queries using QueryDSL and custom repository interfaces

02Generating complex JPA entities with optimized relationship mapping and static factory methods

03Refactoring service layers to ensure correct transaction propagation and read-only optimizations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add allra-fintech/allra-ai-skills database-schema

For use in Claude.ai and ChatGPT

Download Skill