Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

jOOQ

jooq.org

  • Free plan
  • Self-hosted
7.2 Club score Visit jooq.org

What jOOQ is

jOOQ generates Java code from database metadata and provides a fluent API for building type-safe SQL queries. Its SQL DSL embeds SQL in Java, using the compiler and generics to check column types, row value expressions, and syntax. Generated classes can help surface schema changes at compile time. Generated Active Records support create, read, update, and delete operations, as well as optimistic locking, foreign-key navigation, and POJO mapping. The code generator can create callable methods for database routines, and stored functions can be embedded in type-safe SQL. jOOQ can transform SQL expressions for a target database, while supported dialects and versions depend on the edition. Its Open Source Edition lists ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB. jOOQ also supports runtime schema and table overrides, row-level security, and custom query lifecycle behavior through its SPI. It is self-hosted and supports Java, Kotlin, and Scala. The free Open Source Edition has unlimited use; paid editions start at €99 per year, excluding VAT. Commercial licenses apply per developer workstation, while build, test, and production server licenses are included.

Who it suits

jOOQ suits Java developers who want generated database code and compile-time checks for SQL queries. Its editions address open-source database users as well as teams seeking commercial database support or premium support.

Good to know, and what to watch

  • Generates Java classes from database metadata.
  • Checks SQL types and syntax through Java's compiler.
  • Generated records support CRUD and optimistic locking.
  • Supports Java, Kotlin, and Scala.
  • Open Source Edition has unlimited use.
  • Commercial licenses are required per developer workstation.
  • Supported dialects and versions vary by edition.
  • Commercial prices exclude VAT.

Open Source Edition

Free

Express Edition

€99/yr

Professional Edition

€399/yr

Enterprise Edition

€799/yr

Free plan · 30-day trial

Getting started

  1. Open the jOOQ website
  2. Choose the Open Source, Express, Professional, or Enterprise edition
  3. Select the Java, Kotlin, or Scala development environment
  4. Use the CLI or integrate jOOQ into your self-hosted project
  5. Generate classes from database metadata
  6. Build queries with the fluent SQL DSL

Limits to check

The free Open Source Edition lists the supported open-source databases and latest versions for those databases. Commercial database support and additional dialect coverage depend on paid editions, and commercial licenses apply per developer workstation.

The Club's review

jOOQ generates Java classes from database metadata and provides a fluent, type-checked way to write SQL inside application code. It is best suited to Java teams that want schema and query errors caught by the compiler. The main decision is whether its edition supports your database and whether per-workstation licensing fits your development setup.

Overview

jOOQ keeps SQL close to the database while adding Java's compiler and generics to query construction. Its generator turns tables and other metadata into Java classes, so schema changes can produce compile-time feedback instead of surfacing only during execution. That is a strong fit for applications where database structure and code must evolve together.

The product is self-hosted and supports Java, Kotlin, and Scala, although Java is its primary environment. Commercial licenses apply to each developer workstation using jOOQ code; licenses for build, test, and production servers are included. The licensing FAQ says no license server is required and jOOQ does not call home.

Key features

Type-safe SQL and code generation

The embedded SQL DSL expresses queries in Java and uses the type system to check column types, row-value expressions, and SQL syntax. Generated classes give application code named, schema-aware objects and can expose mismatches when the database changes. A command-line interface is available for integrating generation into development workflows.

Records and database operations

Generated Active Records cover create, read, update, and delete operations, with optimistic locking, foreign-key navigation, and POJO mapping. This is useful when teams want generated persistence objects without giving up direct SQL authoring.

Dialects, routines, and runtime control

jOOQ can transform SQL expressions into equivalents for a target database, but dialect and version coverage depends on the edition. The Open Source Edition lists ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB. The generator can create callable methods for stored routines, while stored functions can be embedded in type-safe SQL.

Runtime schema and table overrides support multi-tenancy and row-level security. Its service-provider interface allows custom logging, transaction management, event triggers, and SQL transformation. Integrations listed for the product include Spring, Hibernate, Liquibase, R2DBC, and Reactive Streams.

Pricing

jOOQ uses a freemium model, with a 30-day trial and paid editions from €99 per year.

PlanPrice and termsWhat it includes
Open Source EditionFree, free with unlimited useLatest versions of listed open-source databases under the Apache Software License 2.0.
Express Edition$99 a year, billed at 99 € excluding VAT per floating developer workstation and yearOngoing maintenance and support, plus listed databases including Oracle Express Edition, SQL Server Express Edition, and Microsoft Access.
Professional Edition$399 a year, billed at 399 € excluding VAT per floating developer workstation and yearOngoing maintenance and support for listed commercial databases including Oracle and SQL Server.
Enterprise Edition$799 a year, billed at 799 € excluding VAT per floating developer workstation and yearBroad enterprise database support and premium support.

The free edition is the practical choice for projects staying within its open-source database list. Express suits smaller teams needing basic commercial-database coverage; Professional is the more appropriate tier for mainstream Oracle or SQL Server development; Enterprise targets broad database requirements and premium support. Because licensing is per floating developer workstation, larger developer groups should budget by workstation rather than by deployed server.

Free users receive community support through GitHub, Stack Overflow, user groups, and Reddit. Paying customers receive included email support, with premium support reserved for Enterprise.

Platforms

jOOQ is self-hosted. It supports Java, Kotlin, and Scala and offers a CLI for code-generation workflows.

Who it's for

Choose jOOQ for Java-led applications where retaining SQL matters but compile-time checks for schema, types, and syntax are valuable. It also fits teams building multi-tenant systems, integrating with Spring or reactive stacks, or relying on generated routines and records. Open-source database users can start at no cost; teams on commercial databases need to match their database and required support level to a paid edition.

It is less suitable when your team does not use JVM languages, when your database is outside the chosen edition's dialect coverage, or when a per-developer workstation license is awkward for a large or highly variable development population.

Pros and cons

Pros

  • Compiler-backed SQL: Java's type system checks important query and expression errors before execution.
  • Schema-aware generation: Database metadata becomes Java classes that can reveal schema drift during compilation.
  • Broad workflow support: Active Records, routines, POJO mapping, multi-tenancy overrides, and lifecycle SPIs cover more than query writing.
  • Low-friction privacy model: No license server or call-home requirement is stated.

Cons

  • Edition-dependent dialects: Database and version support changes by edition, so a free deployment may not cover a commercial database.
  • Workstation-based commercial licensing: Each developer workstation using jOOQ requires a license, even though server licenses are included.
  • Java-centered approach: Kotlin and Scala are supported, but teams outside the JVM ecosystem gain little from the DSL.

Alternatives

APIMatic is a better fit when you need hosted API and SDK generation across programming languages, with a free plan capped at one API, ten endpoints, and one team member.

Nx suits teams managing broader multi-language or web monorepos, offering a free Hobby plan with 50,000 monthly credits, five contributors, and ten concurrent CI connections.

Stainless is aimed at API generator workflows, with its free tier limited to five generators, five seats, 25 endpoints, and 100 preview builds per month.

GraphQL Hive fits GraphQL schema operations, with a free Hobby plan allowing one million operations per month and seven-day usage retention.

quicktype is a free, Apache-2.0 open-source option for generating types from API data, with web and CLI access.

Fern targets API documentation and generation, with a free plan for ten team members, 1,000 pages, and monthly generation and AI-credit limits.

SQLDelight is a free open-source Kotlin SQL code-generation library with no paid tiers stated.

TypeSpec is a free, Microsoft-built, community-supported open-source project with a CLI and online playground.

Verdict

jOOQ is a strong choice for JVM teams that want SQL control combined with generated schema types and compiler-checked queries. Its main reason to choose it is the tight database-to-code workflow; its main reason to look elsewhere is edition-dependent database coverage and per-developer workstation licensing for commercial use.

The verdict

jOOQ connects database metadata to Java code and offers a fluent way to build checked SQL queries. Review edition-specific database support and workstation licensing before adopting a commercial plan.

Questions people ask

Is there a free plan?

Yes. The Open Source Edition costs nothing and is licensed under the Apache Software License 2.0.

What do paid plans cost?

Express is $99 a year, Professional is $399 a year, and Enterprise is $799 a year. The listed euro amounts are €99, €399, and €799 per floating developer workstation and year, excluding VAT.

Which languages does jOOQ support?

jOOQ supports Java, Kotlin, and Scala.

Which databases are listed for the Open Source Edition?

They include ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB.

Is a license server required?

No. The licensing FAQ says jOOQ does not require a license server and does not call home.

What support is included?

Free community support is available through GitHub, Stack Overflow, user groups, and Reddit. Paying customers also receive included email support.

What the maker publishes

Code generation
The code generator creates Java classes from database metadata so Java code can be checked against schema changes at compile time. source
CRUD and records
Generated Active Records support create, read, update, delete, optimistic locking, foreign key navigation, and POJO mapping. source
Database support
The Open Source Edition lists ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, and YugabyteDB. source
Founded
2013 source
Headquarters
St. Gallen, Switzerland source
Integrations
The licensing page lists dependencies or integrations including Spring, Hibernate, Liquibase, R2DBC, and Reactive Streams. source
Licensing and limits
Commercial licenses are required per developer workstation using jOOQ code, while build, test, and production server licenses are included. source
Multi-tenancy
jOOQ supports runtime database schema and table overrides and row-level security. source
Purpose
jOOQ generates Java code from a database and lets developers build type safe SQL queries through a fluent API. source
Query lifecycle
Its SPI allows custom behavior for logging, transaction management, event triggers, and SQL transformation. source
Security and privacy
The licensing FAQ states jOOQ does not require a license server and does not call home. source
SQL dialects
jOOQ can transform SQL expressions into equivalents supported by a target database, and its edition determines the supported dialects and versions. source
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. source
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. source
Support
Free community support is offered through GitHub, Stack Overflow, user groups, and Reddit; paying customers also get included email support. source
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. source

Checked against the maker's pages on 8 Oct 2026.