jOOQ

A type-safe DSL for constructing SQL queries in Java

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-08-14verify at live pricing ↗Independently observed

from €99/moSubscriptionFree tier30-day trial

From €99/developer workstation/year. Free open source edition. 30-day free trials. Monthly and unlimited pricing available.

Open Source

Free

Unlimited use for open source database support

Support for ClickHouse, Derby, DuckDB, Firebird, H2, HSQLDB, MariaDB, MySQL, PostgreSQL, SQLite, Trino, YugabyteDB

Professional

€99/developer workstation/year

annual

For small to medium companies supporting Oracle, SQL Server, MS Access

Ongoing maintenance and support
Oracle Express Edition 18c+
SQL Server Express Edition 2012+
Microsoft Access 2013+

Professional Plus

€399/developer workstation/year

annual

Advanced features with versioned RDBMS and Java support

Advanced jOOQ features
Versioned RDBMS support
Versioned Java support
Premium support

Enterprise

€799/developer workstation/year

annual

Premium support for large companies with extensive enterprise database support

Premium support
Amazon Redshift, Aurora, Azure SQL, CockroachDB, BigQuery, Databricks, DB2, Exasol, HANA, Informix, Snowflake, Spanner, Sybase, Teradata, Vertica

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 56 / 100

low · 39%

Signal contributions to the composite score
Signal	Score	Weight	Contribution	Evidence
Capabilities	75	0.10	7.4	✓
Development activity	46	0.12	5.5	✓
Dependent projects	61	0.08	4.9	✓
Price level	80	0.04	3.2	✓
Security score	55	0.05	2.9	✓
Stars	72	0.03	2.4	✓
Pricing transparency	45	0.05	2.4	✓
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-09-10. 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,785	highsource · 2026-09-10 · 90%
Dependent reposadoption.dependent_repos	4,667	highsource · 2026-09-10 · 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: No · Studio gui: No	mediumsource · 2026-09-10 · 60%

Language

Attribute	Value	Evidence
Primarylanguage.primary	Java	highsource · 2026-09-10 · 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-09-10 · 60%
Price levelpricing.price_level	low	mediumsource · 2026-09-10 · 60%
Transparentpricing.transparent	No	mediumsource · 2026-09-10 · 60%
Modelpricing.model	freemium	mediumsource · 2026-09-10 · 60%

Release

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

Security

Attribute	Value	Evidence
Scorecardsecurity.scorecard	5.5	highsource · 2026-09-10 · 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-09-10 · 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 and you can correct the facts, add the sources we should be reading, and see how AI assistants are describing jOOQ. Free, and it does not change the score.

Correct anything wrong, with evidence
Point our crawler at the pages that matter
See which AI systems are reading this profile

Claim jOOQ

Not the owner? How vendor profiles work