jOOQ

Write database queries in Java with compile-time type checking and IDE autocompletion

Also known as: jooq

Available worldwide

What is jOOQ?

A code generator and embedded SQL library that provides a strongly-typed API for writing database queries in Java, preventing syntax errors and type mismatches at compile time.

Independently observed

jOOQ pricing

Plans, per-tier features and add-ons, dated and linked to live pricing. Pricing changes often; always verify at source before you rely on it.

Pricing as of 2026-10-13verify at live pricing ↗Independently observed

from €99HybridFree tier

Free open source edition; commercial plans from 99 € annually with volume discounts and custom options available

Open Source Edition

Free

Support for open source databases

MySQL
PostgreSQL
SQLite
HSQLDB
ClickHouse (latest versions)

Professional Edition

99 € annually

Adds Oracle, SQL Server, and MS Access support with basic support

All open source databases
Oracle
SQL Server 2012+
MS Access
3 incidents per year support

Enterprise Edition

399 € annually

Support for multiple commercial databases with premium support

All open source databases
Multiple commercial databases
10 incidents per year support

Enterprise Edition (All Databases)

799 € annually

Complete support for all commercial databases

All databases including Aurora, Azure, Databricks, Teradata, Sybase

What jOOQ does

The capabilities that matter for orm & database tools, normalised so it lines up with every alternative. “-” means we haven't confirmed it, not that it's missing.

Core

Type-safe queries: ✓
Schema migrations: ✓
Relations / joins API: ✓
Languages: Java

Modelling

Schema-first modelling: ✓

Flexibility

Raw SQL escape hatch: ✓

Portability

Multiple database backends: ✓

Ops

Connection pooling: ✗

Data browser / studio: ✗

Independently observed

Security & compliance

Known vulnerabilities: 0 (0 in the last 12 months) sourcea count reflects scale & disclosure, not quality

jOOQ FAQ

Common questions about jOOQ, answered from independent, dated evidence.

What is jOOQ?

jOOQ creates Java code based on your database structure, enabling developers to write SQL queries with compile-time type checking. It supports multiple database backends and abstracts SQL dialect differences while preserving direct control over SQL generation. It is indexed under ORM & Database Tools.

Source: https://www.jooq.org

Is jOOQ free?

jOOQ offers a free tier, so you can start without paying. Paid plans start at €99 per developer workstation per year. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.

Source: https://www.jooq.org

Where is jOOQ available?

jOOQ is available worldwide. The vendor is headquartered in Switzerland.

Source: https://www.jooq.org

jOOQ alternatives

Other orm & database tools we track, ranked by the same independent score.

All jOOQ alternatives, ranked →

Compare jOOQ

Side by side against other orm & database tools, attribute by attribute, with a source on every value.

Independent · unbought · dated

The vioscaleAI score: one lens on the evidence

Not user reviews and not a paid placement: a confidence-weighted blend of the independent signals below (adoption, activity, security posture, and more), which you can sort and re-weight yourself. Vendors can correct their listing but can never move their rank, and stars are weighted low as a vanity metric. It is one way to read the evidence for jOOQ, not the verdict.

Balanced composite 58 / 100

low · 39%

Signal contributions to the composite score
Signal	Score	Weight	Contribution	Evidence
Capabilities	81	0.10	8.0	✓
Development activity	46	0.12	5.5	✓
Pricing transparency	100	0.05	5.3	✓
Dependent projects	61	0.08	4.9	✓
Security score	55	0.05	2.9	✓
Stars	72	0.03	2.4	✓
Price level	25	0.04	1.0	✓
Reliability	0	0.05	0.0	-
Integrations	0	0.05	0.0	-
Release cadence	0	0.07	0.0	-
Security posture	0	0.09	0.0	-
Package downloads	0	0.17	0.0	-
Developer Q&A activity	0	0.08	0.0	-

Computed 2026-10-13. Re-weight it by intent, or see the full method.

All data & sourcesshow ↓

Every value we hold, with its source, retrieval date, and confidence. This is the evidence behind the score: don't trust it, verify it.

Activity

Attribute	Value	Evidence
Commits last 30dactivity.commits_last_30d	27	mediumsource · 2026-09-10 · 65%

Adoption

Attribute	Value	Evidence
Github starsadoption.github_stars	6,792	highsource · 2026-10-13 · 90%
Dependent reposadoption.dependent_repos	4,667	highsource · 2026-10-13 · 85%

Content

Attribute	Value	Evidence
Faqcontent.faq	3 items	mediumsource · 2026-09-10 · 65%

Features

Attribute	Value	Evidence
Capabilitiesfeatures.capabilities	Raw sql: Yes · Multi db: Yes · Languages: Java · Relations: Yes · Migrations: Yes · Studio gui: No	mediumsource · 2026-10-13 · 60%

Language

Attribute	Value	Evidence
Primarylanguage.primary	Java	highsource · 2026-10-13 · 90%

Market

Attribute	Value	Evidence
Availabilitymarket.availability	HqCountry: CH · PrimaryMarkets: … · AvailabilityScope: global · AvailableCountries: … · NotAvailableCountries: …	highsource · 2026-08-14 · 75%

Pricing

Attribute	Value	Evidence
Free tierpricing.free_tier	Yes	mediumsource · 2026-10-13 · 60%
Price levelpricing.price_level	high	mediumsource · 2026-10-13 · 60%
Transparentpricing.transparent	Yes	mediumsource · 2026-10-13 · 60%
Modelpricing.model	freemium	mediumsource · 2026-10-13 · 60%
Starting pricepricing.starting_price	Amount: 99 · Currency: EUR	mediumsource · 2026-10-13 · 60%

Release

Attribute	Value	Evidence
Historyrelease.history	20 items	mediumsource · 2026-10-13 · 70%

Security

Attribute	Value	Evidence
Scorecardsecurity.scorecard	5.5	highsource · 2026-10-13 · 90%
Vulnerabilitiessecurity.vulnerabilities	Count: 0 · Source: https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=org.jooq%3Ajooq&per_page=100 · Last 12m: 0	highsource · 2026-10-13 · 90%

Still deciding?

Is jOOQ the right choice for you?

Tell us the job, the constraints and what you weigh most, and we will rank jOOQ against the rest of the orm & database tools we index, using the same dated evidence weighted your way.

Free to run, no account needed to start. How the evaluation works

For the makers of jOOQ

Is this your product?

This profile was built from public sources without asking you. You can take the badge below and use it anywhere, and you can claim the profile to correct anything we got wrong. Both are free, and neither moves jOOQ up or down: nobody can buy rank here, including you.

Take the badge

Live, always current, and free to use on your own site. It shows jOOQ's independent score and links back to this profile.

HTML

<a href="https://www.vioscale.ai/software/jooq" target="_blank" rel="noopener">
  <img src="https://www.vioscale.ai/badge/software/jooq.svg" alt="jOOQ, verified on vioscaleAI" width="330" height="76" loading="lazy" />
</a>

Markdown, for a README →

Markdown

[![jOOQ, verified on vioscaleAI](https://www.vioscale.ai/badge/software/jooq.svg)](https://www.vioscale.ai/software/jooq)

Claim the profile

Verify you control the domain, then point us at the pages that state the facts about jOOQ and add your own description and media. Free, and it does not change the score.

Correct anything wrong, with evidence
Point our crawler at the pages that matter
Write your own description and add media

Claim jOOQ

Not the owner? How vendor profiles work