table-creation

Generate database DDL and Java ORM code for MySQL and PostgreSQL.

22|4|Updated Feb 18, 2026
One-click install
npx skills add https://github.com/xiaoweidotnet/suifeng-skills --skill table-creation-xiaoweidotnet
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: table-creation
Source: https://github.com/xiaoweidotnet/suifeng-skills/tree/main/skills/table-creation
Command: npx skills add https://github.com/xiaoweidotnet/suifeng-skills --skill table-creation-xiaoweidotnet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill solves the problem of inconsistent database schema design and repetitive boilerplate code creation by enforcing a unified standard for base fields and ORM mappings.

Core Features & Use Cases

  • Standardized Schema: Automatically injects mandatory audit fields (created_at, updated_at, is_deleted, deleted_at) into every new table.
  • Multi-ORM Support: Generates full-stack code (Entity, Mapper, Manager) for MyBatis-Plus, standard MyBatis, or JPA/Hibernate.
  • Use Case: When starting a new feature, simply describe the business entity and the skill will generate the SQL DDL, Java entities, and service layer code, ensuring the project maintains a consistent architecture.

Quick Start

Trigger the table creation skill by asking to design a new user profile table with specific business fields and your preferred ORM framework.

Frequently Asked Questions about table-creation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate standardized database schema SQL and Java ORM code together?

You can generate standardized database schema DDL and Java ORM code by describing your business entity to trigger automated creation. This process outputs SQL DDL alongside Entity, Mapper, and Manager classes for MyBatis, MyBatis-Plus, or JPA frameworks.

What's the best way to enforce audit fields and soft-delete logic across new database tables?

To enforce audit fields and soft-delete logic, automate table creation to inject mandatory columns. Every generated table automatically includes created_at, updated_at, is_deleted, and deleted_at fields to maintain consistent architectural integrity across the service layer.

Does this database schema generation support both PostgreSQL and MySQL environments?

Yes, database schema generation supports both PostgreSQL and MySQL environments. You can design your business entities and generate DDL tailored to either database platform while ensuring standardized audit fields are included.

Can I use MyBatis-Plus or JPA for ORM code generation from a database schema?

Yes, you can use MyBatis-Plus, standard MyBatis, or JPA/Hibernate for ORM code generation. The generation process creates full-stack code including Entity, Mapper, and Manager components mapped to your standardized database schema.

Why does my generated database schema include is_deleted and deleted_at columns by default?

Generated database schemas include is_deleted and deleted_at columns by default to enforce soft-delete logic. This standardized approach ensures architectural integrity by keeping deleted records in the database while marking them as inactive.

How do I start building a new user profile table with standardized base fields?

To start building a new user profile table with standardized base fields, simply describe the business entity and your preferred ORM framework. The skill generates the SQL DDL and Java entities, ensuring consistent architecture across the project.