jOOQ generates type-safe Java code from your database schema and provides a fluent API for composing SQL in Java. It targets teams that prefer SQL-centric data access with compile-time checking instead of stringly-typed queries or heavy ORM mapping.
The Open Source Edition supports popular open-source databases under the Apache License 2.0; commercial editions list annual euro pricing per workstation rather than monthly USD plans.
API access
Homepage and download pages describe code generation, fluent SQL builders, and JDBC integration APIs.
Is jOOQ right for you?
A good fit for
Java teams with complex SQL who want generated records, dialect support, and optional commercial support for enterprise databases.
Before you choose
Oracle, SQL Server, and premium support require paid commercial licenses billed annually in euros on the download page.
SQL-centric Java access
jOOQ.org pitches generated schema classes and fluent SQL composition so Java applications stay aligned with relational databases without sacrificing expressiveness.
What it can do
Features & capabilities
Unknown is different from unavailable. Each fact carries its own evidence.
Capability
Value
Evidence
Checked
Type-safe SQL
Homepage states jOOQ generates Java code from your database and builds type safe SQL queries through a fluent API.
Facts sourced
2026-10-04
Database-first
Marketing copy emphasizes a database-first approach where schema drives generated classes and compiler-checked SQL.
Facts sourced
2026-10-04
Editions
Download page contrasts a free open-source edition with commercial tiers priced per floating developer workstation and year in euros.
Facts sourced
2026-10-04
Understand the total cost
jOOQ pricing & plans
Free
Free
The Open Source Edition supports popular open-source databases under the Apache License 2.0; commercial editions list annual euro pricing per workstation rather than monthly USD plans.
Access
The Open Source Edition supports popular open-source databases under the Apache License 2.0; commercial editions list annual euro pricing per workstation rather than monthly USD plans.
jOOQ generates type-safe Java code from your database schema and provides a fluent API for composing SQL in Java. It targets teams that prefer SQL-centric data access with compile-time checking instead of stringly-typed queries or heavy ORM mapping.
Does jOOQ have a free plan?
The Open Source Edition supports popular open-source databases under the Apache License 2.0; commercial editions list annual euro pricing per workstation rather than monthly USD plans.. This record lists ongoing free access; check the plan limits before starting.
How much does jOOQ cost?
No paid monthly price is listed; this record treats the product as free to start. See the plan cards for entitlements, billing commitments and seat minimums.
Can I use jOOQ through an API?
Homepage and download pages describe code generation, fluent SQL builders, and JDBC integration APIs.. API access and subscription access may have different terms; consult the linked sources.
What should I check before choosing it?
Oracle, SQL Server, and premium support require paid commercial licenses billed annually in euros on the download page.
Price history
No retained pricing changes yet. A current price alone does not establish a historical trend.