jOOQ

Plans and prices

Every plan, in full

On the record

Code generation

The code generator creates Java classes from database metadata so Java code can be checked against schema changes at compile time.jooq.org · read 8 Oct 2026

CRUD and records

Generated Active Records support create, read, update, delete, optimistic locking, foreign key navigation, and POJO mapping.jooq.org · read 8 Oct 2026

Database support

The Open Source Edition lists ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB.jooq.org · read 8 Oct 2026

Integrations

The licensing page lists dependencies or integrations including Spring, Hibernate, Liquibase, R2DBC, and Reactive Streams.jooq.org · read 8 Oct 2026

Licensing and limits

Commercial licenses are required per developer workstation using jOOQ code, while build, test, and production server licenses are included.jooq.org · read 8 Oct 2026

Multi-tenancy

jOOQ supports runtime database schema and table overrides and row-level security.jooq.org · read 8 Oct 2026

Purpose

jOOQ generates Java code from a database and lets developers build type safe SQL queries through a fluent API.jooq.org · read 8 Oct 2026

Query lifecycle

Its SPI allows custom behavior for logging, transaction management, event triggers, and SQL transformation.jooq.org · read 8 Oct 2026

Security and privacy

The licensing FAQ states jOOQ does not require a license server and does not call home.jooq.org · read 8 Oct 2026

SQL dialects

jOOQ can transform SQL expressions into equivalents supported by a target database, and its edition determines the supported dialects and versions.jooq.org · read 8 Oct 2026

SQL DSL

jOOQ embeds SQL as an internal domain specific language in Java and uses Java's compiler and generics for column type, row value expression, and SQL syntax checks.jooq.org · read 8 Oct 2026

Stored procedures

The code generator can generate callable methods for routines, and stored functions can be embedded in SQL statements in a type safe manner.jooq.org · read 8 Oct 2026

Support

Free community support is offered through GitHub, Stack Overflow, user groups, and Reddit; paying customers also get included email support.jooq.org · read 8 Oct 2026

Who it is for

The maker describes jOOQ editions for open source database users, power users needing advanced features and versioned support, smaller companies needing basic commercial database support, and large companies seeking premium support.jooq.org · read 8 Oct 2026

Alternatives to jOOQ

S SQLDelightAndroidiPhone & iPad+6 SC Swagger CodegenWebWindows+4 N NxWebWindows+3 Q quicktypeWebWindows+3 A APIMaticWebLinux+3 F FernWebWindows+4 P PHPMakerWebWindows+2 SM Symfony MakerBundleWindowsMac+3

Every alternative, ranked