Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience real numbers from our own analytics — open to see them
–Visitors
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · counted by iTechGuides's own first-party analytics, bots removed, every figure rounded down · how we count

jOOQ

Freemium#23 of 33 in Code GeneratorsDatabase Query Builders

jOOQ: A focused code generator for typed SQL, schema mapping, and database-driven Java or Kotlin development. Ranked #23 of 33 in Code Generators by our editors (7.0/10); pricing: Free plan · 30-day trial; best for java and Kotlin database code generation.

7.0/10Editor score
Visit jOOQ
jOOQ7.0 Visit jOOQ

At a glance

  • Editor score
    7.0 / 10
  • Pricing
    Free plan · 30-day trial
  • Best for
    Java and Kotlin database code generation
  • Free plan
    Yes
  • Paid from
    €99/device/yr
  • Founded
    2013 · St. Gallen, Switzerland
  • Facts checked
    20 Sep 2026
jOOQ screenshot

  • Where it wins

    • Generates Java classes from database metadata and schema objects
    • Provides a type-safe fluent SQL API with Active Record support
    • Runs through Maven, Gradle, Ant, or a standalone command line

  • Where it doesn't

    • Paid editions start at €99 per floating developer workstation annually
    • Open-source licensing applies to supported open-source databases
    • Commercial edition differences are not detailed beyond support and maintenance

Our verdict on jOOQ

jOOQ is a Java-based SQL framework and database code generator for developers building applications with relational databases. It models SQL as a fluent, type-safe API and generates Java classes from database metadata, including tables and other schema objects. The published feature set also covers stored procedures and functions, schema and table mapping, SQL dialect transformation, and Active Record support for generated tables. jOOQ can be used with Java, Kotlin, and Scala applications, making it a fit for teams that want database structure represented directly in application code.

Its strongest fit is a workflow centered on generated database code rather than a general-purpose application scaffolding tool. Code generation can run through Maven, Gradle, or Ant, or from a standalone command line, so teams can place it in existing build processes. The type-safe fluent SQL API and dialect transformation are useful for projects that need structured query construction across supported database environments. These capabilities make jOOQ particularly relevant when schema metadata, SQL expressiveness, and compile-time types are central requirements.

Pricing follows a freemium model. The Open Source Edition is free, permits unlimited use, and is licensed under Apache Software License 2.0 for supported open-source databases. Commercial editions are listed at €99 annually per floating developer workstation for Express, €399 for Professional, and €799 for Enterprise; each lists ongoing maintenance and support. Commercial editions include 30-day free trials. Choose jOOQ when type-safe SQL and database metadata generation are priorities; consider another tool if you need a broader application generator or clearer published distinctions between commercial tiers.

Your product? Our editors can test jOOQ in depth and publish a review, labelled as paid · from $99/mo →

jOOQ pricing

Plans Free plan · 30-day trialFreemium A usable free plan; paid tiers unlock the limits above. Prices checked 20 Sep 2026.
See plans on jooq.org

All 4 jOOQ plans and prices →

jOOQ fact sheet

Free planYes
Paid from€99/device/yr
Project scaffoldingNot verified
Custom templatesNot verified
Schema-to-code generationYes
CLI availableYes
IDE pluginsNot verified
Supported languagesJava, Kotlin, Scala
Free trial30 days
SupportEmail, Docs
Built forSmall business, Mid-market, Enterprise (editorial estimate)
PricingFree plan · 30-day trial (source)
Websitejooq.org
Facts checked20 Sep 2026

Alternatives to jOOQ

See all jOOQ alternatives →

Also Ranked In

jOOQ is ranked in 2 of our directories.

Used jOOQ? Be the first to review it

The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used jOOQ for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.

Write a reviewTwo minutes · verified accounts only · read by an editor before it appears

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Your rating

0 characters · at least 80, up to 3,000

Posted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

Featured on iTechGuides — jOOQ 7.0/10

jOOQ is listed in our Code Generators directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/jooq/"><img src="https://www.itechguides.com/best/badge/jooq.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Guides on code generators

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.

Last updated · How we research and update