jpa-patterns
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, and performance tuning in Spring Boot.
- Covers entity mapping with auditing, soft deletes, indexing, and enumerated types; includes transaction management with read-only optimization and propagation strategies
- Provides N+1 prevention techniques using lazy loading, JOIN FETCH queries, and DTO projections for lightweight reads
- Demonstrates pagination with Pageable, custom repository methods, and cursor-based patterns for large datasets
- Includes HikariCP connection pooling configuration, second-level caching guidance, and batch write optimization
- Emphasizes testing with @DataJpaTest and Testcontainers, SQL debugging via Hibernate logging, and production-safe migrations with Flyway or Liquibase
JPA/Hibernate Patterns
Use for data modeling, repositories, and performance tuning in Spring Boot.
When to Activate
- Designing JPA entities and table mappings
- Defining relationships (@OneToMany, @ManyToOne, @ManyToMany)
- Optimizing queries (N+1 prevention, fetch strategies, projections)
- Configuring transactions, auditing, or soft deletes
- Setting up pagination, sorting, or custom repository methods
- Tuning connection pooling (HikariCP) or second-level caching
Entity Design
@Entity
@Table(name = "markets", indexes = {
@Index(name = "idx_markets_slug", columnList = "slug", unique = true)
More from affaan-m/everything-claude-code
security-review
Use this skill when adding authentication, handling user input, working with secrets, creating API endpoints, or implementing payment/sensitive features. Provides comprehensive security checklist and patterns.
7.9Kgolang-patterns
Idiomatic Go patterns, best practices, and conventions for building robust, efficient, and maintainable Go applications.
7.4Kcoding-standards
Baseline cross-project coding conventions for naming, readability, immutability, and code-quality review. Use detailed frontend or backend skills for framework-specific patterns.
6.7Kfrontend-patterns
Frontend development patterns for React, Next.js, state management, performance optimization, and UI best practices.
6.6Kbackend-patterns
Backend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
6.6Kgolang-testing
Go testing patterns including table-driven tests, subtests, benchmarks, fuzzing, and test coverage. Follows TDD methodology with idiomatic Go practices.
6.1K