name: database-integration description: > Database integration patterns for Java services using jOOQ and Flyway. Covers code generation, read/write splitting, migration guidelines, and version compatibility. Use when setting up or maintaining PostgreSQL integration. compatibility: Java projects using Gradle with PostgreSQL metadata: version: "1.0.0" technology: java category: infrastructure tags: - java - jooq - flyway - postgresql - database

Database Integration

Database integration patterns for Java services using jOOQ and Flyway.

When to use this skill

• Setting up jOOQ code generation
• Creating Flyway migrations
• Configuring read/write database splitting
• Resolving jOOQ version conflicts
• Reviewing SQL migration safety

Skill Contents

Sections

• When to use this skill (L24-L31)
• Quick Start (L51-L97)
• Version Compatibility (L98-L117)
• References (L118-L124)
• Related Rules (L125-L129)
• Related Skills (L130-L135)

Available Resources

📚 references/ - Detailed documentation

• flyway
• jooq

Quick Start

1. Add Dependencies

# gradle/libs.versions.toml
[versions]
postgresql = "42.7.8"
testcontainers = "1.21.4"
jooq = "3.19.28"  # Spring Boot 3.5.x BOM version
flyway = "11.7.2"

[libraries]
jooq = { module = "org.jooq:jooq", version.ref = "jooq" }
jooq-codegen = { module = "org.jooq:jooq-codegen", version.ref = "jooq" }
jooq-meta = { module = "org.jooq:jooq-meta", version.ref = "jooq" }

[plugins]
flyway = { id = "org.flywaydb.flyway", version.ref = "flyway" }
jooq = { id = "nu.studer.jooq", version = "9.0" }

2. Apply jOOQ Configuration

// build.gradle
plugins {
    alias(libs.plugins.flyway)
    alias(libs.plugins.jooq)
}

apply from: "${project.rootDir}/gradle/jooq-config.gradle"

dependencies {
    implementation libs.jooq
    jooqGenerator libs.testcontainers.postgres,
            libs.postgres,
            libs.flyway.database.postgresql
}

3. Generate Code

./gradlew generateJooq

Version Compatibility

Java 21 (Gradle 8.x)

Java 25 (Gradle 9.x)

References

Related Rules

• java-jooq - Full jOOQ reference
• java-flyway-migrations - Flyway guidelines

Related Skills