Does this skill support Oracle-specific types like CLOB or BLOB?

Yes, it automatically maps CLOB to String and BLOB to byte[], applying the necessary @Lob and @Basic(fetch = FetchType.LAZY) annotations.

What version of JPA does this generator target?

It targets modern Jakarta Persistence (jakarta.persistence.*) conventions used in current Spring Boot and Hibernate 6+ environments.

How does it handle foreign key relationships?

It scans your project's entity directory for tables matching column names ending in _ID to automatically generate @ManyToOne relationships.

Can I customize the package placement of generated files?

The skill uses table prefixes (like OI_ or FLEXII_) to determine the package, but will ask the user for clarification if the location is ambiguous.

How are ID columns handled?

It supports standard numeric IDs with @NextOidGenerator as well as UUID CHAR(36) primary keys, following strict nullability and indexing rules.

Oracle JPA Entity Generator

Name: Oracle JPA Entity Generator
Author: peterstorm

bypeterstorm

0•

Database Management

Generates production-grade Jakarta Persistence (JPA) entity classes from Oracle SQL CREATE TABLE statements using standardized repository patterns.

This skill accelerates Java backend development by automating the conversion of Oracle DDL into fully annotated Hibernate entities. It features intelligent Oracle-to-Java type mapping, handles complex schema-qualified table names, and implements sophisticated relationship resolution by scanning your existing codebase for foreign key matches. Designed specifically for enterprise environments, it ensures architectural consistency by following strict naming conventions, package placement rules, and Jakarta Persistence best practices including lazy-loading for LOB fields and custom ID generation.

Key Features

010 GitHub stars

02Deep relationship resolution that searches local source code to generate @ManyToOne mappings.

03Automatic generation of Lombok annotations and excluded fields for cleaner, safer toString() methods.

04Automated package routing and class naming based on table prefixes and database schemas.

05Intelligent mapping of Oracle types including VARCHAR2, NUMBER, CLOB, and TIMESTAMP to Java types.

06Support for specialized persistence patterns including @NextOidGenerator and UUID primary keys.

Use Cases

01Refactoring legacy Oracle databases into modern JPA-based Hibernate entities with standardized naming.

02Ensuring consistent entity patterns across large development teams using the hibertable11 architecture.

03Scaffolding new data models in Java microservices directly from SQL schema exports.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add peterstorm/.dotfiles entity-generator

For use in Claude.ai and ChatGPT

Download Skill