# Ecto vs Kysely

**Leader by vioscaleAI score:** Kysely

| Attribute | Ecto | Kysely |
|---|---|---|
| **vioscaleAI score** | 52.3 (39% (low)) | 73.6 (78% (high)) |
| activity.commits_last_30d | 10 | 59 |
| adoption.dependent_repos | 12,249 | 1,155 |
| adoption.github_stars | 6,497 | 14,269 |
| adoption.package_downloads_weekly | - | 20,754,444 |
| content.faq | `[{"answer":"A library that enables type-safe database queries and schema mapping for Elixir, supporting multiple database backends including PostgreSQL, MySQL, and SQLite with language-integrated querying. It is indexed under ORM & Database Tools.","source":"https://hexdocs.pm/ecto","question":"What is Ecto?","confidence":0.6},{"answer":"Ecto is open source, so it can be self-hosted and used at no licence cost. It is released under the Apache-2.0 licence. Pricing changes often, so verify at source before relying on it.","source":"https://hexdocs.pm/ecto","question":"Is Ecto free to use?","confidence":0.6},{"answer":"We have confirmed 6 integrations for Ecto, including PostgreSQL, MySQL, MSSQL, SQLite3, ClickHouse and ETS. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://hexdocs.pm/ecto","question":"What does Ecto integrate with?","confidence":0.6},{"answer":"Yes. Ecto is published under the Apache-2.0 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/elixir-ecto/ecto","question":"Is Ecto open source?","confidence":0.95}]` | `[{"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 | `{"self_hosted":true}` | `{"cloud":true,"self_hosted":true}` |
| description.long | Provides a way for Elixir applications to interact with SQL databases using Elixir code instead of raw SQL, with support for defining data structures, managing schema evolution through migrations, and handling relationships between data entities. | 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":"Elixir","relations":true,"migrations":true,"schema_first":true,"type_safe_queries":true}` | `{"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 | 5 | 21 |
| integrations.list | `[{"name":"PostgreSQL"},{"name":"MySQL"},{"name":"MSSQL"},{"name":"SQLite3"},{"name":"ClickHouse"},{"name":"ETS"}]` | `[{"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 | Elixir | TypeScript |
| license.spdx | Apache-2.0 | MIT |
| platform.support | - | `{"web":true}` |
| pricing | `{"type":"open_source","freeTier":true,"sourceUrl":"https://hexdocs.pm/ecto","retrievedAt":"2026-10-13T13:45:33.228Z"}` | `{"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 | open_source | open_source |
| pricing.price_level | free | free |
| pricing.transparent | - | yes |
| release.cadence_days | - | 10 |
| release.history | `[{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v3.4.5","date":"2020-07-28T19:18:20Z","type":"stable","version":"v3.4.5"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v2.2.0-rc.1","date":"2017-08-18T13:36:53Z","type":"prerelease","version":"v2.2.0-rc.1"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v2.0.1","date":"2016-06-21T13:18:18Z","type":"stable","version":"v2.0.1"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v2.0.0","date":"2016-06-21T13:18:36Z","type":"stable","version":"v2.0.0"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.8","date":"2016-06-21T13:19:18Z","type":"stable","version":"v1.1.8"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.7","date":"2016-06-21T13:19:35Z","type":"stable","version":"v1.1.7"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.6","date":"2016-06-21T13:19:58Z","type":"stable","version":"v1.1.6"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.5","date":"2016-04-19T10:08:50Z","type":"stable","version":"v1.1.5"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.4","date":"2016-04-19T10:08:36Z","type":"stable","version":"v1.1.4"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.3","date":"2016-02-22T10:46:14Z","type":"stable","version":"v1.1.3"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.2","date":"2016-02-22T10:46:01Z","type":"stable","version":"v1.1.2"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.1","date":"2015-12-23T15:32:10Z","type":"stable","version":"v1.1.1"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.1.0","date":"2015-12-23T15:31:55Z","type":"stable","version":"v1.1.0"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.7","date":"2015-12-23T15:34:06Z","type":"stable","version":"v1.0.7"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.6","date":"2015-12-23T15:33:53Z","type":"stable","version":"v1.0.6"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.5","date":"2015-12-23T15:33:36Z","type":"stable","version":"v1.0.5"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.4","date":"2015-12-23T15:33:16Z","type":"stable","version":"v1.0.4"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.3","date":"2015-12-23T15:32:50Z","type":"stable","version":"v1.0.3"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.2","date":"2015-09-07T13:16:29Z","type":"stable","version":"v1.0.2"},{"url":"https://github.com/elixir-ecto/ecto/releases/tag/v1.0.1","date":"2015-08-30T09:10:09Z","type":"stable","version":"v1.0.1"}]` | `[{"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"}]` |
| reliability.status_page | yes | - |
| security.scorecard | 5.6 | 7.2 |
| security.vulnerabilities | `{"count":2,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=hex&package_name=ecto&per_page=100","last_12m":0,"max_severity":"CRITICAL"}` | `{"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 | Ecto | Kysely |
|---|:--:|:--:|
| **Core** |  |  |
| Type-safe queries | ✓ | ✓ |
| Schema migrations | ✓ | ✓ |
| Relations / joins API | ✓ | ✓ |
| Languages | Elixir | 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-16T02:22:39.704Z. "-" = undocumented, not absent.*