Best forA schema-first ORM with generated types and migrations.
Trade-offA generated client and its own schema language sit between you and SQL; complex queries often drop back to raw SQL.
Used by 37 makers' products for this
For database access & ORMs, the alternatives to TypeORM that makers' products we track chose most are Prisma (37), Drizzle ORM (12) and SQLAlchemy (1). 5 of the 5 are open source or self-hostable (Prisma, Drizzle ORM, SQLAlchemy and 2 more) and 5 have a free tier.
Not a ranking: each option is described by the situation it fits, with its trade-off.
How many makers' products we track use each for database access & ORMs.
| Option | Kind | Makers' products | Free tier | Open source | |
|---|---|---|---|---|---|
| Schema-first ORM | 0 | Yes | Yes | ||
| Schema-first ORM | 37 | Yes | Yes | ||
| SQL-shaped ORM | 12 | Yes | Yes | ||
| SQL-shaped ORM | 1 | Yes | Yes | ||
| Query builder | 0 | Yes | Yes | ||
| Schema-first ORM | 0 | Yes | Yes |
Schema-first ORM, SQL-shaped query builder, or the platform's own SDK. A schema-first ORM generates types and migrations from one schema file and hides the SQL; a SQL-shaped ORM or query builder keeps queries close to SQL with full types and a smaller runtime; a backend platform (Supabase, Convex, Firebase) comes with its own client, and adding an ORM on top is often unnecessary.
TypeORM (Schema-first ORM): Class-and-decorator entities in TypeScript, especially in NestJS apps. Trade-off: Type safety on queries is weaker than Drizzle, Kysely or Prisma.
Best forA schema-first ORM with generated types and migrations.
Trade-offA generated client and its own schema language sit between you and SQL; complex queries often drop back to raw SQL.
Used by 37 makers' products for this
Best forA thin, SQL-like TypeScript ORM that runs well on serverless and edge runtimes.
Trade-offCloser to SQL means you need to know SQL, and there are fewer guides and integrations than for Prisma.
Used by 12 makers' products for this
Best forPython backends (FastAPI, Flask, scripts) that want an ORM or a SQL toolkit over any relational database.
Trade-offA large API with two styles (ORM and Core); migrations come from a separate tool, Alembic.
Used by 1 maker's product for this
Best forA type-safe SQL query builder for TypeScript, with no schema file or code generation step of its own.
Trade-offA query builder rather than a full ORM — migrations are basic and relations are joins you write.
No maker product tracked for this yet
Best forModels, associations and migrations in plain JavaScript Node.js apps, especially existing Express codebases.
Trade-offBuilt before TypeScript was common, so typing is added on and query results are weakly typed; the next major version has been in alpha for years.
No maker product tracked for this yet
It depends on what you need it for; we don't rank them. The one makers' products we track chose most for database access & ORMs is Prisma (37 makers' products). You want one schema file that generates types, migrations and a readable query API: Prisma. You deploy to serverless or edge functions and want queries that read like SQL, fully typed: Drizzle ORM. You already write SQL comfortably and only want types around it, no schema layer: Kysely.
Yes. For database access & ORMs, Prisma, Drizzle ORM, SQLAlchemy, Kysely and Sequelize have a free tier a small product can start on.
Yes. For database access & ORMs: Prisma, Drizzle ORM, SQLAlchemy, Kysely and Sequelize.