Tag
Orm tools
9 reviewed tools: 9 free or open source.
Order: free and open source first, then hosted products with a real free tier, then paid-led; catalog order inside each group, with quiet or archived repos last. Not a score, and no tool pays for its place.
9 tools
- PrismaType-safe database access with killer DX
Free / OSS · Freemium · 47.7k GitHub stars
VerdictThe DX is addictive; just watch your query patterns.
CatchAbstraction costs. Complex queries sometimes require raw SQL, and the generated client adds bundle size. Performance-sensitive applications need careful query optimization.
- Drizzle ORMTypeScript ORM that feels like SQL
Free / OSS · Apache-2.0 · 36.1k GitHub stars
VerdictSQL-first type safety for the abstraction-allergic.
CatchLess magic means more typing. Relation handling requires more manual work than Prisma. The ecosystem is smaller.
- SQLModelSQL + Pydantic in one elegant package
Free / OSS · OSS/MIT · 18.4k GitHub stars
VerdictOne model for database and API—elegant when it fits.
CatchRelatively young library, so edge cases exist. Complex SQLAlchemy patterns may need direct SQLAlchemy access.
- sqlcMIT type-safe code gen from SQL
Free / OSS · OSS/MIT · 18.4k GitHub stars
VerdictMIT SQL codegen. Free forever; not an ORM.
CatchCodegen from SQL - not Prisma/Drizzle ORM, not a database. Schema migrations are still yours (golang-migrate, Atlas, etc.). Language support depth varies.
- KyselyMIT type-safe TypeScript SQL query builder
Free / OSS · OSS/MIT · 14.3k GitHub stars
VerdictMIT typed SQL builder. Free forever when you want SQL back without losing TS.
CatchYou own the Database interface (or codegen it). No schema designer, no magic relations like Prisma.
- SeaORMApache-2.0 async ORM for Rust web services
Free / OSS · Apache-2.0 · 9.9k GitHub stars
VerdictThe most approachable async ORM in Rust — mind the TLS feature flags.
CatchDefault features do not enable TLS; you have to pick a TLS backend through SQLx features, which trips people up. The 2.0 release changed APIs, so older tutorials may not compile. Diesel is the main alternative if you prefer compile-time query checking over a dynamic query builder.
- TypeORMMIT TypeScript ORM with Active Record and Data Mapper
Free / OSS · OSS/MIT · 36.7k GitHub stars
VerdictStill a solid pick for NestJS-style apps — newer projects often prefer Drizzle.
CatchDecorators and reflection metadata feel heavy next to schema-first tools like Drizzle or Prisma, and type safety for complex queries is weaker. Maintenance went through quiet years before the 1.x releases, so some old issues linger. Lazy relations and migrations need discipline.
- dj-stripeMIT Stripe data synced into Django models
Free / OSS · OSS/MIT · 1.8k GitHub stars
VerdictUse it when a Django app needs to reason about Stripe state locally.
CatchStripe only, and Django only. Model and Stripe API-version upgrades can require migrations and care. Releases are a few a year.
- DjangoBSD-3-Clause batteries-included Python web framework: ORM, migrations, admin, auth
Free / OSS · BSD-3-Clause · 91.5k GitHub stars
VerdictStill the fastest route from models to a working app with an admin.
CatchIt is monolith-shaped and opinionated. Async views work, but much of the ORM still runs through sync adapters. For a JSON API you add Django REST Framework or Django Ninja, or pick FastAPI from the start.
FAQ
- What is the top free pick among Orm tools?
- Prisma leads the Stack Gems list for Orm tools. Verdict: The DX is addictive; just watch your query patterns.
- How many Orm tools does Stack Gems review?
- 9: 9 free or open source. Each review has a verdict and an honest Catch; no tool pays for its spot.
- Which Orm tools can I self-host for free?
- Drizzle ORM, SQLModel, sqlc, Kysely, SeaORM, TypeORM, dj-stripe and Django.
- Which Orm tools have the most GitHub stars?
- Django (91.5k), Prisma (47.7k), TypeORM (36.7k), per GitHub on 2026-10-21. Stars measure attention, not fit; read the Catch.
- What is the catch with Prisma?
- Abstraction costs. Complex queries sometimes require raw SQL, and the generated client adds bundle size.