Generate jOOQ config
generate_jooq_configGenerates a jOOQ codegen configuration XML from a PostgreSQL schema. Lists all base tables, excludes MCPg bookkeeping, and maps JSON columns to org.jooq.JSON types.
Instructions
Read a PostgreSQL schema and emit a jooq-codegen configuration XML pointing at it. Unlike the other exporters, jOOQ generates Java code itself from a live database — the artefact here is the configuration file the user feeds to mvn jooq-codegen:generate (or the Gradle task). The XML lists every base table explicitly via an regex, excludes MCPg's bookkeeping tables, and emits a for every json / jsonb column so they map to org.jooq.JSON / org.jooq.JSONB out of the box. Default Java package is com.example.jooq; override via the target_package arg.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| target_package | No | com.example.jooq | |
| target_directory | No | src/main/java |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |