jOOQ/jOOQ
jOOQ is the best way to write SQL in Java observed · 2026-08-28
Health v2 · maintenance only
94/100
- Activity 99
- Release rhythm 84
- Longevity 100
Flags: no_license
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 0.0
- age_days: 5617
- days_rel: 29
- days_push: 7
- n_releases_24m: 81
Adoption not part of the score
6777 stars · 1217 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
jOOQ is a Java library that models SQL as a type-safe internal DSL, with a source code generator that reverse-engineers your database schema into Java classes. It provides fluent query building, dialect abstraction across 30+ RDBMS, DAOs, active records, SQL parsing/translation, and reactive support via R2DBC.
Use cases
- write type-safe SQL queries in Java
- generate Java classes from database schema
- replace JDBC boilerplate for database access
- translate SQL between different database dialects
- build dynamic SQL queries with a fluent API
- map query results to POJOs and DAOs
- migrate from Hibernate/JPA to a SQL-centric approach
When to choose
- you want SQL-first development where the database schema drives your Java code
- you need compile-time safety for SQL queries against your schema
- you must support multiple SQL dialects from one codebase
- you find ORMs like Hibernate too opaque and want explicit SQL control
When to avoid
- you want a pure object-relational mapping with entity persistence and change tracking
- your project is not on the JVM
- you need a fully free license for commercial databases like Oracle or SQL Server (commercial editions required)
- you prefer schema-less or NoSQL data access
Facets
library · maturity stable
orm database database-driver parser databases backend developer-tools web-development jvm sql-builder type-safe-sql code-generation jdbc dsl sql-dialect-abstraction active-records reactive r2dbc multi-tenancy
10 sources
- readme: https://github.com/jOOQ/jOOQ · fetched 2026-08-28 · 718fb32f7ae1
- homepage: https://www.jooq.org · fetched 2026-08-29 · 37c73d0fdcc4
- site_page: https://www.jooq.org/doc/3.21/manual/getting-started/use-cases · fetched 2026-08-29 · c8a69632a31c
- site_page: https://www.jooq.org/doc/3.21/manual/getting-started/use-cases/jooq-as-a-sql-builder-with-code-generation · fetched 2026-08-29 · 18a3aeb3d967
- site_page: https://www.jooq.org/doc/3.21/manual/getting-started/tutorials/jooq-in-7-steps · fetched 2026-08-29 · 1996d9dee5cc
- site_page: https://www.jooq.org/download · fetched 2026-08-29 · 33fe07910619
- site_page: https://www.jooq.org/doc/3.21/manual/sql-execution/execute-listeners · fetched 2026-08-29 · cf2c6c7eca23
- site_page: https://www.jooq.org/doc/3.21/manual/code-generation · fetched 2026-08-29 · 9adf56c5cf47
- site_page: https://www.jooq.org/javadoc/latest/org/jooq/ExecuteListener.html · fetched 2026-08-29 · e6d7a5e3833d
- site_page: https://www.jooq.org/faq · fetched 2026-08-29 · d237f8493427
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| jOOQ/jOOQ | main | 94 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem