# Dapper vs Knex.js

**Leader by Vioscale score:** Knex.js

| Attribute | Dapper | Knex.js |
|---|---|---|
| **Vioscale score** | 52.1 (38% (low)) | 66.2 (71% (medium)) |
| activity.commits_last_30d | 6 | 0 |
| adoption.dependent_repos | 477 | 94,868 |
| adoption.github_stars | 18,373 | 20,342 |
| adoption.package_downloads_weekly | - | 5,289,407 |
| description.long | A micro-ORM for .NET that extends ADO.NET connections to execute SQL queries and stored procedures, supporting both synchronous and asynchronous operations with features for object mapping, dynamic SQL building, and multi-result set processing. | An open-source Node.js package supporting nine SQL databases including PostgreSQL, MySQL, SQLite, and Oracle. Provides type-safe query building with TypeScript support, schema migrations, transaction handling with savepoints, connection pooling, and both promise and callback-based interfaces. |
| features.capabilities | `{"raw_sql":true,"multi_db":true,"languages":"C# / .NET (all TFMs)","relations":true}` | `{"raw_sql":true,"multi_db":true,"languages":"JavaScript, TypeScript","relations":true,"migrations":true,"studio_gui":false,"schema_first":true,"type_safe_queries":true,"connection_pooling":true}` |
| language.primary | C# | JavaScript |
| license.spdx | - | MIT |
| pricing | - | `{"type":"open_source","sourceUrl":"https://knexjs.org","retrievedAt":"2026-08-14T08:34:17.530Z"}` |
| pricing.model | - | open_source |
| pricing.price_level | - | free |
| release.cadence_days | 26 | 28 |
| release.history | `[{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.79","date":"2026-05-16T20:40:41Z","type":"stable","version":"2.1.79"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.72","date":"2026-03-06T07:16:11Z","type":"stable","version":"2.1.72"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.66","date":"2025-02-06T12:26:12Z","type":"stable","version":"2.1.66"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.44","date":"2024-04-12T12:42:44Z","type":"stable","version":"2.1.44"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.42","date":"2024-04-12T10:23:44Z","type":"stable","version":"2.1.42"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.37","date":"2024-03-14T15:17:02Z","type":"stable","version":"2.1.37"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.35","date":"2024-03-06T15:08:18Z","type":"stable","version":"2.1.35"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.28","date":"2024-01-02T16:13:39Z","type":"stable","version":"2.1.28"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.24","date":"2023-11-23T09:30:26Z","type":"stable","version":"2.1.24"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.21","date":"2023-11-11T09:07:29Z","type":"stable","version":"2.1.21"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.15","date":"2023-10-19T12:52:19Z","type":"stable","version":"2.1.15"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.11","date":"2023-10-13T06:26:06Z","type":"stable","version":"2.1.11"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.4","date":"2023-09-13T20:52:44Z","type":"stable","version":"2.1.4"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.1.1","date":"2023-09-12T15:17:35Z","type":"stable","version":"2.1.1"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.0.151","date":"2023-08-18T09:51:46Z","type":"stable","version":"2.0.151"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.0.143","date":"2023-06-20T12:43:19Z","type":"stable","version":"2.0.143"},{"url":"https://github.com/DapperLib/Dapper/releases/tag/2.0.138","date":"2023-06-09T15:32:01Z","type":"stable","version":"2.0.138"}]` | `[{"url":"https://github.com/knex/knex/releases/tag/3.3.0","date":"2026-06-26T14:55:58Z","type":"stable","version":"3.3.0"},{"url":"https://github.com/knex/knex/releases/tag/3.2.10","date":"2026-05-02T12:14:38Z","type":"stable","version":"3.2.10"},{"url":"https://github.com/knex/knex/releases/tag/3.2.9","date":"2026-04-03T20:25:30Z","type":"stable","version":"3.2.9"},{"url":"https://github.com/knex/knex/releases/tag/3.2.8","date":"2026-03-30T18:29:09Z","type":"stable","version":"3.2.8"},{"url":"https://github.com/knex/knex/releases/tag/3.2.7","date":"2026-03-30T18:28:52Z","type":"stable","version":"3.2.7"},{"url":"https://github.com/knex/knex/releases/tag/3.2.6","date":"2026-03-25T02:06:50Z","type":"stable","version":"3.2.6"},{"url":"https://github.com/knex/knex/releases/tag/3.2.3","date":"2026-03-22T22:38:07Z","type":"stable","version":"3.2.3"},{"url":"https://github.com/knex/knex/releases/tag/3.2.1","date":"2026-03-22T21:08:27Z","type":"stable","version":"3.2.1"},{"url":"https://github.com/knex/knex/releases/tag/3.2.0","date":"2026-03-22T17:37:15Z","type":"stable","version":"3.2.0"},{"url":"https://github.com/knex/knex/releases/tag/3.1.0","date":"2023-12-07T23:17:57Z","type":"stable","version":"3.1.0"},{"url":"https://github.com/knex/knex/releases/tag/3.0.1","date":"2023-10-06T12:23:40Z","type":"stable","version":"3.0.1"},{"url":"https://github.com/knex/knex/releases/tag/3.0.0","date":"2023-10-06T06:56:38Z","type":"stable","version":"3.0.0"},{"url":"https://github.com/knex/knex/releases/tag/2.5.1","date":"2023-07-12T21:26:26Z","type":"stable","version":"2.5.1"},{"url":"https://github.com/knex/knex/releases/tag/2.5.0","date":"2023-07-08T21:04:46Z","type":"stable","version":"2.5.0"},{"url":"https://github.com/knex/knex/releases/tag/2.4.2","date":"2023-03-29T11:15:20Z","type":"stable","version":"2.4.2"},{"url":"https://github.com/knex/knex/releases/tag/2.4.1","date":"2023-03-29T11:11:39Z","type":"stable","version":"2.4.1"},{"url":"https://github.com/knex/knex/releases/tag/2.4.0","date":"2023-01-06T15:45:16Z","type":"stable","version":"2.4.0"},{"url":"https://github.com/knex/knex/releases/tag/2.3.0","date":"2022-09-01T21:17:24Z","type":"stable","version":"2.3.0"},{"url":"https://github.com/knex/knex/releases/tag/2.2.0","date":"2022-07-18T21:26:26Z","type":"stable","version":"2.2.0"},{"url":"https://github.com/knex/knex/releases/tag/2.1.0","date":"2022-05-26T09:04:03Z","type":"stable","version":"2.1.0"}]` |
| reliability.status_page | yes | - |
| security.scorecard | - | 5.7 |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=nuget&package_name=dapper&per_page=100","last_12m":0,"max_severity":null}` | `{"count":2,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=knex&per_page=100","last_12m":0,"max_severity":"CRITICAL"}` |

## Capabilities (ORM & Database Tools)

| Capability | Dapper | Knex.js |
|---|:--:|:--:|
| **Core** |  |  |
| Type-safe queries | - | ✓ |
| Schema migrations | - | ✓ |
| Relations / joins API | ✓ | ✓ |
| Languages | C# / .NET (all TFMs) | JavaScript, TypeScript |
| **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:34:18.230Z. "-" = undocumented, not absent.*