Name: Infra Mybatis Po Mapper Generator
Author: ryan-alexander-zhang

Infra MyBatis PO/Mapper Generator

Overview

Generates MyBatis/MyBatis-Plus PO and Mapper patterns for infra persistence, selecting the right abstraction level based on CRUD complexity and concurrency needs. REQUIRED: Follow GENERATOR_SKILL_STRUCTURE.md. Variables in VARIABLES.md.

Templates: See references/templates.md.

When to Use

Creating PO classes under {{basePackage}}.infra.**.po
Creating Mapper interfaces under {{basePackage}}.infra.**.mapper
Mapping a Flyway migration table to persistence types
Deciding between BaseMapper (simple CRUD) and explicit SQL (claim/conditional)

Don't use when

Generating the Flyway migration itself—use infra-flyway-migration-generator
Implementing store logic (claim/lease semantics)—use

Infra MyBatis PO/Mapper Generator

Overview

Templates: See references/templates.md.

When to Use

Creating PO classes under {{basePackage}}.infra.**.po
Creating Mapper interfaces under {{basePackage}}.infra.**.mapper
Mapping a Flyway migration table to persistence types
Deciding between BaseMapper (simple CRUD) and explicit SQL (claim/conditional)

Don't use when

Generating the Flyway migration itself—use infra-flyway-migration-generator
Implementing store logic (claim/lease semantics)—use

Mistake	Why It Happens	Fix
Using BaseMapper for claim/update flows with precise predicates	Underestimating concurrency risk	Switch to explicit SQL with status/lock/lease guards for concurrent access patterns
PO field names mismatching SQL columns	Migration drift or rename without updating PO	Verify PO fields match migration columns exactly after every schema change
Leaking PO types into domain or app layers	Convenience shortcut bypassing converter	Always convert PO ↔ domain at the boundary; PO stays in infra
Missing `@TableName` annotation on PO	Copy-paste from another PO without updating	Every PO must declare `@TableName("<table>")` matching its Flyway table

Infra Mybatis Po Mapper Generator

Infra MyBatis PO/Mapper Generator

Overview

When to Use

Don't use when

Infra Mybatis Po Mapper Generator

Infra MyBatis PO/Mapper Generator

Overview

When to Use

Don't use when

Inputs Required

Outputs

Naming & Packaging

Implementation Rules

Reference Implementations

Tests

Common Mistakes

Output checklist

Phase Commit Gate

Integration

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns