Jean Bisutti
Community@jeanbisutti
Diagnoses and fixes N+1 select problems in Spring Data JPA and Hibernate, applying JOIN FETCH, entity graphs, batch fetching, and DTO projections.
Agent Skills by Jean Bisutti
Showing 1 vetted skills indexed across 1 GitHub repositories.
Frequently Asked Questions About Jean Bisutti
FAQPage SchemaWhat tasks can I accomplish with the jpa-nplus1-fix skill?▼
You can diagnose and fix N+1 select problems in Spring Data JPA, JPA, and Hibernate code. It selects and applies the right remediation per use case, including JOIN FETCH, @EntityGraph, @BatchSize, entity graphs, DTO projections, and pagination-safe fetching patterns.
Who should use this N+1 query remediation skill?▼
Java backend engineers and Spring developers facing slow JPA/Hibernate endpoints, too many SQL selects, repeated queries in loops, LazyInitializationException, MultipleBagFetchException, or HHH000104 and HHH90003004 warnings benefit most from this skill.
When is this skill triggered even if I never mention N+1?▼
It activates whenever you report symptoms like too many SQL selects, repeated queries fired in a loop, slow JPA endpoints, LazyInitializationException, or ask to tune JOIN FETCH, @EntityGraph, @BatchSize, entity graphs, DTO projections, or Hibernate fetching generally.
Does the skill handle pagination when fixing N+1 queries?▼
Yes. It covers pagination-safe remediation patterns, choosing approaches such as @BatchSize or DTO projections instead of collection JOIN FETCH when pagination is required, avoiding in-memory pagination warnings like HHH000104.
What are the prerequisites for using this skill?▼
You need an existing Java codebase using Spring Data JPA, JPA, or Hibernate with observable query performance issues or fetch-related exceptions. No additional installation is described in the skill manifest beyond the skill itself.