LogoClawIndex
CasesSkillsAbout
LogoClawIndex

jpa-postgres - Design JPA entities and PostgreSQL persistence

Provides guidance for JPA entity design, relationship mapping, Flyway migrations, query optimization, and PostgreSQL-specific persistence practices.

Tags

Updated: 2026-10-01
JPAPostgreSQLFlywayHibernateSpring Data JPAdatabase

Capabilities

Design JPA entitiesMap entity relationshipsConfigure entity auditingImplement soft deletes

Typical Inputs

Source filesMigration scriptsEntity classes

Typical Outputs

JPA entity classesRepository interfacesFlyway migration scripts

What this skill does

  • Design JPA entities
  • Map entity relationships
  • Configure entity auditing
  • Implement soft deletes
  • Optimize fetch queries
  • Detect N+1 queries
  • Create entity projections
  • Write Flyway migrations
  • Create repository queries
  • Generate integration tests

Inputs

  • Source files
  • Migration scripts
  • Entity classes
  • Repository interfaces

Outputs

  • JPA entity classes
  • Repository interfaces
  • Flyway migration scripts
  • JPQL and native queries
  • Integration test classes

Requirements

  • Kotlin or Java
  • Spring Boot
  • Spring Data JPA
  • Hibernate
  • PostgreSQL

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.