# sqlc vs TypeORM

**Leader by vioscaleAI score:** TypeORM

| Attribute | sqlc | TypeORM |
|---|---|---|
| **vioscaleAI score** | 52.5 (42% (low)) | 64.5 (70% (medium)) |
| activity.commits_last_30d | 42 | 20 |
| adoption.dependent_repos | 4 | 2 |
| adoption.github_stars | 18,376 | 36,660 |
| adoption.package_downloads_weekly | - | 5,182,331 |
| content.faq | `[{"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}]` | `[{"answer":"TypeORM is an object-relational mapper that enables type-safe database interaction across multiple platforms and database systems. It offers both Data Mapper and Active Record patterns, with built-in support for TypeScript and comprehensive migration capabilities. It is indexed under ORM & Database Tools.","source":"https://typeorm.io","question":"What is TypeORM?","confidence":0.6},{"answer":"TypeORM 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://typeorm.io","question":"Is TypeORM free to use?","confidence":0.6},{"answer":"TypeORM supports the web, Windows, macOS, Linux, iOS, Android and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://typeorm.io","question":"What platforms does TypeORM support?","confidence":0.6},{"answer":"Yes. TypeORM can be deployed cloud / SaaS, hybrid, on-premise, air-gapped and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://typeorm.io","question":"Can TypeORM be self-hosted?","confidence":0.6},{"answer":"Yes. TypeORM 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/typeorm/typeorm","question":"Is TypeORM open source?","confidence":0.99}]` |
| deployment.options | `{"cloud":true,"self_hosted":true}` | `{"cloud":true,"hybrid":true,"on_prem":true,"air_gapped":true,"self_hosted":true}` |
| description.long | 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. | TypeORM is an object-relational mapper that enables type-safe database interaction across multiple platforms and database systems. It offers both Data Mapper and Active Record patterns, with built-in support for TypeScript and comprehensive migration capabilities. |
| features.capabilities | `{"raw_sql":true,"multi_db":true,"languages":"Go; community support for Python","migrations":true,"studio_gui":false,"schema_first":true,"type_safe_queries":true}` | `{"raw_sql":true,"multi_db":true,"languages":"TypeScript, JavaScript (ES2023)","relations":true,"migrations":true,"schema_first":true,"type_safe_queries":true,"connection_pooling":true}` |
| language.primary | Go | TypeScript |
| license.spdx | MIT | MIT |
| market.availability | - | `{"primaryMarkets":[],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true}` | `{"cli":true,"web":true}` |
| pricing | `{"type":"open_source","freeTier":true,"sourceUrl":"https://docs.sqlc.dev","retrievedAt":"2026-08-14T08:35:21.413Z"}` | `{"type":"open_source","freeTier":true,"sourceUrl":"https://typeorm.io","retrievedAt":"2026-10-13T22:34:01.200Z"}` |
| pricing.free_tier | yes | yes |
| pricing.model | open_source | open_source |
| pricing.price_level | free | free |
| pricing.transparent | - | yes |
| release.cadence_days | 42 | 35 |
| release.history | `[{"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"}]` | `[{"url":"https://github.com/typeorm/typeorm/releases/tag/1.1.2","date":"2026-10-08T07:21:48Z","type":"stable","version":"1.1.2"},{"url":"https://github.com/typeorm/typeorm/releases/tag/1.1.1","date":"2026-09-01T10:55:04Z","type":"stable","version":"1.1.1"},{"url":"https://github.com/typeorm/typeorm/releases/tag/1.1.0","date":"2026-07-13T19:07:27Z","type":"stable","version":"1.1.0"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.31","date":"2026-07-13T19:24:24Z","type":"stable","version":"0.3.31"},{"url":"https://github.com/typeorm/typeorm/releases/tag/1.0.0","date":"2026-05-19T11:14:09Z","type":"stable","version":"1.0.0"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.30","date":"2026-05-18T20:53:21Z","type":"stable","version":"0.3.30"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.29","date":"2026-05-08T13:12:25Z","type":"stable","version":"0.3.29"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.28","date":"2025-12-03T08:31:15Z","type":"stable","version":"0.3.28"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.27","date":"2025-09-19T09:47:59Z","type":"stable","version":"0.3.27"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.26","date":"2025-08-18T16:34:16Z","type":"stable","version":"0.3.26"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.25","date":"2025-06-19T16:09:18Z","type":"stable","version":"0.3.25"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.24","date":"2025-05-14T18:05:22Z","type":"stable","version":"0.3.24"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.23","date":"2025-05-07T10:04:52Z","type":"stable","version":"0.3.23"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.22","date":"2025-04-03T09:01:46Z","type":"stable","version":"0.3.22"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.21","date":"2025-03-03T08:10:24Z","type":"stable","version":"0.3.21"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.20","date":"2024-01-26T11:22:33Z","type":"stable","version":"0.3.20"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.19","date":"2024-01-03T14:44:45Z","type":"stable","version":"0.3.19"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.18","date":"2024-01-03T12:43:14Z","type":"stable","version":"0.3.18"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.17","date":"2023-06-20T19:48:38Z","type":"stable","version":"0.3.17"},{"url":"https://github.com/typeorm/typeorm/releases/tag/0.3.16","date":"2023-05-09T18:59:14Z","type":"stable","version":"0.3.16"}]` |
| reliability.status_page | - | yes |
| security.scorecard | 4.5 | 7.3 |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=homebrew&package_name=sqlc&per_page=100","last_12m":0,"max_severity":null}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=%40nativescript-community%2Ftypeorm&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (ORM & Database Tools)

| Capability | sqlc | TypeORM |
|---|:--:|:--:|
| **Core** |  |  |
| Type-safe queries | ✓ | ✓ |
| Schema migrations | ✓ | ✓ |
| Relations / joins API | - | ✓ |
| Languages | Go; community support for Python | TypeScript, JavaScript (ES2023) |
| **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-16T18:30:40.985Z. "-" = undocumented, not absent.*