jOOQ
jooq.org
- Free plan
- Self-hosted
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.
Plans
Every plan and priceOpen Source Edition
Express Edition
Professional Edition
Enterprise Edition
Free plan · 30-day trial
Getting started
- Open the jOOQ website
- Choose the Open Source, Express, Professional, or Enterprise edition
- Select the Java, Kotlin, or Scala development environment
- Use the CLI or integrate jOOQ into your self-hosted project
- Generate classes from database metadata
- 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.
| Plan | Price and terms | What it includes |
|---|---|---|
| Open Source Edition | Free, free with unlimited use | Latest 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 year | Ongoing 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 year | Ongoing 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 year | Broad 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.