# jOOQ vs Kysely

**Leader by vioscaleAI score:** Kysely

| Attribute | jOOQ | Kysely |
|---|---|---|
| **vioscaleAI score** | 57.9 (39% (low)) | 73.6 (78% (high)) |
| activity.commits_last_30d | 27 | 59 |
| adoption.dependent_repos | 4,667 | 1,155 |
| adoption.github_stars | 6,792 | 14,269 |
| adoption.package_downloads_weekly | - | 20,754,444 |
| content.faq | `[{"answer":"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","question":"What is jOOQ?","confidence":0.6},{"answer":"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","question":"Is jOOQ free?","confidence":0.6},{"answer":"jOOQ is available worldwide. The vendor is headquartered in Switzerland.","source":"https://www.jooq.org","question":"Where is jOOQ available?","confidence":0.75}]` | `[{"answer":"A JavaScript and TypeScript SQL query builder that provides compile-time type safety and database schema validation. It works across multiple runtimes (Node, Deno, Bun, Cloudflare Workers, browsers) with zero runtime dependencies and emphasizes composable, type-safe queries over higher-level abstractions. It is indexed under ORM & Database Tools.","source":"https://kysely.dev","question":"What is Kysely?","confidence":0.6},{"answer":"Kysely is open source, so it can be self-hosted and used at no licence cost. It is released under the MIT licence. Pricing changes often, so verify at source before relying on it.","source":"https://kysely.dev","question":"Is Kysely free to use?","confidence":0.6},{"answer":"Kysely supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://kysely.dev","question":"What platforms does Kysely support?","confidence":0.6},{"answer":"Yes. Kysely can be deployed cloud / SaaS and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://kysely.dev","question":"Can Kysely be self-hosted?","confidence":0.6},{"answer":"We have confirmed 20 integrations for Kysely, including Supabase, Cursor, Windsurf, GitHub Copilot, ChatGPT, Claude, AirTrail and AWS Blocks, plus 12 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://kysely.dev","question":"What does Kysely integrate with?","confidence":0.6},{"answer":"Yes. Kysely is published under the MIT licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/kysely-org/kysely","question":"Is Kysely open source?","confidence":0.99}]` |
| deployment.options | - | `{"cloud":true,"self_hosted":true}` |
| description.long | 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. | A JavaScript and TypeScript SQL query builder that provides compile-time type safety and database schema validation. It works across multiple runtimes (Node, Deno, Bun, Cloudflare Workers, browsers) with zero runtime dependencies and emphasizes composable, type-safe queries over higher-level abstractions. |
| features.capabilities | `{"raw_sql":true,"multi_db":true,"languages":"Java","relations":true,"migrations":true,"studio_gui":false,"schema_first":true,"type_safe_queries":true,"connection_pooling":false}` | `{"raw_sql":true,"multi_db":true,"languages":"TypeScript, JavaScript (Node, Deno, Bun, Cloudflare Workers, browsers)","relations":true,"migrations":true,"studio_gui":false,"schema_first":true,"type_safe_queries":true,"connection_pooling":false}` |
| integrations.count | - | 21 |
| integrations.list | - | `[{"name":"Supabase"},{"name":"Cursor"},{"name":"Windsurf"},{"name":"GitHub Copilot"},{"name":"ChatGPT"},{"name":"Claude"},{"name":"Claude Code"},{"name":"AirTrail"},{"name":"AWS Blocks"},{"name":"Conar"},{"name":"EmbedPDF"},{"name":"Hot Updater"},{"name":"inlang"},{"name":"Notesnook"},{"name":"OpenClaw"},{"name":"Reflect"},{"name":"Sink"},{"name":"Stacks"},{"name":"StudioCMS"},{"name":"Tunarr"},{"name":"ZenStack"},{"name":"PostgreSQL","category":"database"},{"name":"MySQL","category":"database"},{"name":"SQLite","category":"database"},{"name":"Microsoft SQL Server","category":"database"}]` |
| language.primary | Java | TypeScript |
| license.spdx | - | MIT |
| market.availability | `{"hqCountry":"CH","primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | - |
| platform.support | - | `{"web":true}` |
| pricing | `{"type":"hybrid","plans":[{"free":true,"name":"Open Source Edition","summary":"Free","features":["MySQL","PostgreSQL","SQLite","HSQLDB","ClickHouse (latest versions)"],"components":[{"kind":"fixed","amount":0}],"description":"Support for open source databases","contactSales":false},{"free":false,"name":"Professional Edition","summary":"99 € annually","features":["All open source databases","Oracle","SQL Server 2012+","MS Access","3 incidents per year support"],"components":[{"kind":"fixed","amount":99,"currency":"EUR"}],"description":"Adds Oracle, SQL Server, and MS Access support with basic support","contactSales":false},{"free":false,"name":"Enterprise Edition","summary":"399 € annually","features":["All open source databases","Multiple commercial databases","10 incidents per year support"],"components":[{"kind":"fixed","amount":399,"currency":"EUR"}],"description":"Support for multiple commercial databases with premium support","contactSales":false},{"free":false,"name":"Enterprise Edition (All Databases)","summary":"799 € annually","features":["All databases including Aurora, Azure, Databricks, Teradata, Sybase"],"components":[{"kind":"fixed","amount":799,"currency":"EUR"}],"description":"Complete support for all commercial databases","contactSales":false}],"summary":"Free open source edition; commercial plans from 99 € annually with volume discounts and custom options available","currency":"EUR","freeTier":true,"sourceUrl":"https://www.jooq.org","retrievedAt":"2026-10-13T13:57:12.211Z","startingPrice":{"amount":99,"currency":"EUR"}}` | `{"type":"open_source","summary":"Completely free and open source (MIT license)","freeTier":true,"sourceUrl":"https://kysely.dev","retrievedAt":"2026-08-14T08:37:15.404Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | freemium | open_source |
| pricing.price_level | high | free |
| pricing.starting_price | `{"amount":99,"currency":"EUR"}` | - |
| pricing.transparent | yes | yes |
| release.cadence_days | - | 10 |
| release.history | `[{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.9","date":"2026-09-25T07:58:44Z","type":"stable","version":"version-3.21.9"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.20","date":"2026-09-25T07:59:13Z","type":"stable","version":"version-3.20.20"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.39","date":"2026-09-25T07:59:38Z","type":"stable","version":"version-3.19.39"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.8","date":"2026-09-04T15:23:17Z","type":"stable","version":"version-3.21.8"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.19","date":"2026-09-04T15:23:52Z","type":"stable","version":"version-3.20.19"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.38","date":"2026-09-04T15:24:22Z","type":"stable","version":"version-3.19.38"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.7","date":"2026-08-04T13:24:23Z","type":"stable","version":"version-3.21.7"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.18","date":"2026-08-04T13:25:01Z","type":"stable","version":"version-3.20.18"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.37","date":"2026-08-04T13:25:34Z","type":"stable","version":"version-3.19.37"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.6","date":"2026-06-15T15:29:34Z","type":"stable","version":"version-3.21.6"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.17","date":"2026-06-15T15:29:58Z","type":"stable","version":"version-3.20.17"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.36","date":"2026-06-15T15:30:40Z","type":"stable","version":"version-3.19.36"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.5","date":"2026-06-04T13:27:30Z","type":"stable","version":"version-3.21.5"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.16","date":"2026-06-04T13:28:44Z","type":"stable","version":"version-3.20.16"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.35","date":"2026-06-04T13:29:14Z","type":"stable","version":"version-3.19.35"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.4","date":"2026-05-12T13:26:03Z","type":"stable","version":"version-3.21.4"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.15","date":"2026-05-12T13:26:29Z","type":"stable","version":"version-3.20.15"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.19.34","date":"2026-05-12T13:26:57Z","type":"stable","version":"version-3.19.34"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.21.3","date":"2026-05-05T11:06:10Z","type":"stable","version":"version-3.21.3"},{"url":"https://github.com/jOOQ/jOOQ/releases/tag/version-3.20.14","date":"2026-05-05T11:06:40Z","type":"stable","version":"version-3.20.14"}]` | `[{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.6","date":"2026-09-16T01:06:58Z","type":"stable","version":"v0.29.6"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.30.0-beta.2","date":"2026-09-14T01:34:36Z","type":"prerelease","version":"v0.30.0-beta.2"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.5","date":"2026-08-10T01:06:13Z","type":"stable","version":"v0.29.5"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.30.0-beta.1","date":"2026-07-26T17:34:07Z","type":"prerelease","version":"v0.30.0-beta.1"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.30.0-beta.0","date":"2026-07-25T12:45:33Z","type":"prerelease","version":"v0.30.0-beta.0"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.4","date":"2026-07-17T17:42:04Z","type":"stable","version":"v0.29.4"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.3","date":"2026-07-05T23:18:21Z","type":"stable","version":"v0.29.3"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.2","date":"2026-05-16T15:52:03Z","type":"stable","version":"v0.29.2"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.1","date":"2026-05-16T00:01:27Z","type":"stable","version":"v0.29.1"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.0","date":"2026-05-08T23:54:19Z","type":"stable","version":"v0.29.0"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.17","date":"2026-05-03T01:10:50Z","type":"stable","version":"v0.28.17"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.29.0-rc.0","date":"2026-04-24T20:13:08Z","type":"prerelease","version":"v0.29.0-rc.0"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.16","date":"2026-04-10T18:07:40Z","type":"stable","version":"v0.28.16"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.15","date":"2026-03-31T01:49:35Z","type":"stable","version":"v0.28.15"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.14","date":"2026-03-20T11:28:01Z","type":"stable","version":"v0.28.14"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.13","date":"2026-03-18T22:12:57Z","type":"stable","version":"v0.28.13"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.12","date":"2026-03-14T09:13:30Z","type":"stable","version":"v0.28.12"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.11","date":"2026-01-31T18:58:27Z","type":"stable","version":"v0.28.11"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.10","date":"2026-01-18T07:13:52Z","type":"stable","version":"v0.28.10"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.9","date":"2025-12-13T17:48:32Z","type":"stable","version":"v0.28.9"}]` |
| security.scorecard | 5.5 | 7.2 |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=maven&package_name=org.jooq%3Ajooq&per_page=100","last_12m":0,"max_severity":null}` | `{"count":4,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=kysely&per_page=100","last_12m":4,"max_severity":"HIGH"}` |

## Capabilities (ORM & Database Tools)

| Capability | jOOQ | Kysely |
|---|:--:|:--:|
| **Core** |  |  |
| Type-safe queries | ✓ | ✓ |
| Schema migrations | ✓ | ✓ |
| Relations / joins API | ✓ | ✓ |
| Languages | Java | TypeScript, JavaScript (Node, Deno, Bun, Cloudflare Workers, browsers) |
| **Modelling** |  |  |
| Schema-first modelling | ✓ | ✓ |
| **Flexibility** |  |  |
| Raw SQL escape hatch | ✓ | ✓ |
| **Portability** |  |  |
| Multiple database backends | ✓ | ✓ |
| **Ops** |  |  |
| Connection pooling | ✗ | ✗ |
| **DX** |  |  |
| Data browser / studio | ✗ | ✗ |

*Source: vioscaleAI. Generated 2026-10-16T20:15:16.309Z. "-" = undocumented, not absent.*