# Kysely vs sqlc

**Leader by Vioscale score:** Kysely

| Attribute | Kysely | sqlc |
|---|---|---|
| **Vioscale score** | 70.3 (79% (high)) | 50.9 (43% (low)) |
| activity.commits_last_30d | 25 | 39 |
| adoption.dependent_repos | 1,155 | 1 |
| adoption.github_stars | 14,168 | 18,202 |
| adoption.package_downloads_weekly | 14,615,271 | - |
| deployment.options | `{"cloud":true,"self_hosted":true}` | `{"self_hosted":true}` |
| description.long | 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. | An open-source code generator that produces type-safe application code from raw SQL queries, supporting PostgreSQL, MySQL, SQLite, and ClickHouse databases. |
| features.capabilities | `{"raw_sql":true,"multi_db":true,"languages":"TypeScript, JavaScript (Node, Deno, Bun, Cloudflare Workers, browsers)","relations":true,"migrations":false,"studio_gui":false,"schema_first":true,"type_safe_queries":true,"connection_pooling":false}` | `{"raw_sql":true,"multi_db":true,"languages":"Go; community support for Python","studio_gui":false,"schema_first":true,"type_safe_queries":true}` |
| 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"}]` | - |
| language.primary | TypeScript | Go |
| license.spdx | MIT | MIT |
| platform.support | `{"cli":true,"web":true}` | `{"cli":true,"web":true}` |
| pricing | `{"type":"open_source","summary":"Completely free and open source (MIT license)","freeTier":true,"sourceUrl":"https://kysely.dev","retrievedAt":"2026-08-14T08:37:15.404Z"}` | `{"type":"open_source","freeTier":true,"sourceUrl":"https://docs.sqlc.dev","retrievedAt":"2026-08-14T08:35:21.413Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | open_source |
| pricing.price_level | free | free |
| pricing.transparent | yes | - |
| release.cadence_days | 10 | 42 |
| release.history | `[{"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"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.8","date":"2025-10-09T21:47:50Z","type":"stable","version":"v0.28.8"},{"url":"https://github.com/kysely-org/kysely/releases/tag/v0.28.7","date":"2025-09-14T15:37:33Z","type":"stable","version":"v0.28.7"}]` | `[{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.31.1","date":"2026-04-22T14:55:41Z","type":"stable","version":"v1.31.1"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.31.0","date":"2026-04-20T04:27:44Z","type":"stable","version":"v1.31.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.30.0","date":"2025-09-01T23:13:58Z","type":"stable","version":"v1.30.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.29.0","date":"2025-04-17T05:53:43Z","type":"stable","version":"v1.29.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.28.0","date":"2025-01-20T18:47:07Z","type":"stable","version":"v1.28.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.27.0","date":"2024-08-05T20:23:19Z","type":"stable","version":"v1.27.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.26.0","date":"2024-03-28T20:48:51Z","type":"stable","version":"v1.26.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.25.0","date":"2024-01-04T00:26:38Z","type":"stable","version":"v1.25.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.24.0","date":"2023-11-22T18:11:09Z","type":"stable","version":"v1.24.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.23.0","date":"2023-10-24T19:48:04Z","type":"stable","version":"v1.23.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.22.0","date":"2023-09-26T17:58:05Z","type":"stable","version":"v1.22.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.21.0","date":"2023-09-06T18:51:07Z","type":"stable","version":"v1.21.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.20.0","date":"2023-07-31T19:52:12Z","type":"stable","version":"v1.20.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.19.1","date":"2023-07-13T18:45:42Z","type":"stable","version":"v1.19.1"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.19.0","date":"2023-07-06T18:12:19Z","type":"stable","version":"v1.19.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.18.0","date":"2023-04-27T17:51:02Z","type":"stable","version":"v1.18.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.17.2","date":"2023-02-22T18:02:56Z","type":"stable","version":"v1.17.2"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.17.1","date":"2023-02-22T17:18:03Z","type":"prerelease","version":"v1.17.1"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.17.0","date":"2023-02-14T07:14:20Z","type":"stable","version":"v1.17.0"},{"url":"https://github.com/sqlc-dev/sqlc/releases/tag/v1.16.0","date":"2022-11-09T04:41:15Z","type":"stable","version":"v1.16.0"}]` |
| security.scorecard | 7.3 | 4.5 |
| security.vulnerabilities | `{"count":4,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=kysely&per_page=100","last_12m":4,"max_severity":"HIGH"}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=go&package_name=github.com%2Fsqlc-dev%2Fsqlc&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (ORM & Database Tools)

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

*Source: Vioscale. Generated 2026-09-01T17:11:56.361Z. "-" = undocumented, not absent.*