🎯

database-integration

🎯Skill

from bitsoex/bitso-java

What it does

Streamlines PostgreSQL database integration in Java projects by configuring jOOQ code generation, Flyway migrations, and version compatibility.

database-integration

Installation

Install skill:

npx skills add https://github.com/bitsoex/bitso-java --skill database-integration

AddedJan 25, 2026

View on GitHub Back to Skills

Skill Details

SKILL.md

Overview

# 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](#when-to-use-this-skill) (L24-L31)
[Quick Start](#quick-start) (L51-L97)
[Version Compatibility](#version-compatibility) (L98-L117)
[References](#references) (L118-L124)
[Related Rules](#related-rules) (L125-L129)
[Related Skills](#related-skills) (L130-L135)

Available Resources

📚 references/ - Detailed documentation

[flyway](references/flyway.md)
[jooq](references/jooq.md)

---

Quick Start

1. Add Dependencies

```toml

# 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

```groovy

// 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

```bash

./gradlew generateJooq

```

Version Compatibility

Java 21 (Gradle 8.x)

| Component | Version |

|-----------|---------|

| jOOQ | 3.19.28 |

| jOOQ Plugin | 9.0 |

| Flyway | 11.7.2 |

| PostgreSQL Driver | 42.7.8 |

Java 25 (Gradle 9.x)

| Component | Version |

|-----------|---------|

| jOOQ | 3.20.10 |

| jOOQ Plugin | 10.1.1 |

| Flyway | 11.19.0 |

| PostgreSQL Driver | 42.7.8 |

References

| Reference | Description |

|-----------|-------------|

| [references/jooq.md](references/jooq.md) | jOOQ setup, code generation, read/write splitting |

| [references/flyway.md](references/flyway.md) | Migration guidelines, locking, best practices |

Related Rules

.cursor/rules/java-jooq.mdc - Full jOOQ reference
.cursor/rules/java-flyway-migrations.mdc - Flyway guidelines

Related Skills

| Skill | Purpose |

|-------|---------|

| [gradle-standards](../gradle-standards/SKILL.md) | Gradle configuration |

| [java-testing](../java-testing/SKILL.md) | Testing database code |

More from this repository10

🎯

mcp-configuration🎯Skill

Configures and manages MCP (Model Context Protocol) server settings across multiple IDEs for seamless integration and development workflow.

🎯

rest-api🎯Skill

Standardizes REST API development in Java Spring by providing authentication, OpenAPI documentation, and RFC-37 service guidelines.

🎯

doc-sync🎯Skill

doc-sync skill from bitsoex/bitso-java

🎯

git-hooks🎯Skill

Manages and standardizes Git hooks across repositories, ensuring consistent code quality checks and team-wide hook compliance automatically.

🎯

sonarqube-integration🎯Skill

Integrates SonarQube with MCP to enable natural language querying of Java code quality issues, analysis, and quality gate checks.

🎯

gradle-standards🎯Skill

Centralizes and standardizes Gradle build configurations for Java projects, managing dependencies, version catalogs, and multi-module setups efficiently.

🎯

structured-logging🎯Skill

Implements RFC-34 structured logging standards for Java services, enabling JSON-formatted logs with required fields and contextual metadata.

🎯

java-coverage🎯Skill

Configures and generates JaCoCo code coverage reports for Java/Gradle projects, enabling comprehensive testing analysis and quality metrics.

🎯

gradle-9🎯Skill

Upgrades Gradle projects from version 8.x to 9.x, ensuring plugin compatibility and supporting Java 25 migration.

🎯

spring-boot-3-5🎯Skill

Upgrades Java Spring Boot projects to version 3.5.9, ensuring comprehensive dependency updates and compatibility with latest Spring ecosystem standards.