# Kysely vs sqlc

**Leader by vioscaleAI score:** Kysely

| Attribute | Kysely | sqlc |
|---|---|---|
| **vioscaleAI score** | 73.6 (78% (high)) | 52.5 (42% (low)) |
| activity.commits_last_30d | 59 | 42 |
| adoption.dependent_repos | 1,155 | 4 |
| adoption.github_stars | 14,269 | 18,376 |
| adoption.package_downloads_weekly | 20,754,444 | - |
| content.faq | `[{"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}]` | `[{"answer":"An open-source code generator that produces type-safe application code from raw SQL queries, supporting PostgreSQL, MySQL, SQLite, and ClickHouse databases. It is indexed under ORM & Database Tools.","source":"https://docs.sqlc.dev","question":"What is sqlc?","confidence":0.6},{"answer":"sqlc 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://docs.sqlc.dev","question":"Is sqlc free to use?","confidence":0.6},{"answer":"sqlc supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://docs.sqlc.dev","question":"What platforms does sqlc support?","confidence":0.6},{"answer":"Yes. sqlc can be deployed self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://docs.sqlc.dev","question":"Can sqlc be self-hosted?","confidence":0.6},{"answer":"Yes. sqlc 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/sqlc-dev/sqlc","question":"Is sqlc open source?","confidence":0.95}]` |
| deployment.options | `{"cloud":true,"self_hosted":true}` | `{"cloud":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. | A command-line tool that reads SQL queries and generates type-safe code in multiple programming languages, eliminating manual database access code while maintaining type safety across database interactions. |
| features.capabilities | `{"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}` | `{"raw_sql":true,"multi_db":true,"languages":"Go; community support for Python","migrations":true,"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"},{"name":"PostgreSQL","category":"database"},{"name":"MySQL","category":"database"},{"name":"SQLite","category":"database"},{"name":"Microsoft SQL Server","category":"database"}]` | - |
| language.primary | TypeScript | Go |
| license.spdx | MIT | MIT |
| platform.support | `{"web":true}` | `{"cli":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.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"}]` | `[{"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.2 | 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=homebrew&package_name=sqlc&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: vioscaleAI. Generated 2026-10-16T17:47:13.201Z. "-" = undocumented, not absent.*