Tools / Drizzle / Drizzle vs Prisma
SQL-first TypeScript ORM with a migrations toolkit and Studio
Drizzle is a TypeScript ORM that treats SQL as the primary interface: you declare your schema in TypeScript, then build queries with a typed query builder or write raw SQL where you want it. It supports PostgreSQL (plus hosted variants like Neon, Supabase, Vercel Postgres, PlanetScale Postgres, and AWS Data API), MySQL, and SQLite, and is designed to work in serverless and edge environments. The project includes Drizzle Kit, a CLI for generating, pushing, and pulling migrations, and Drizzle Studio, a browser-based UI for browsing your database. Schema features cover indexes, constraints, sequences, views, row-level security, generated columns, and custom types. On the query side you get joins, transactions, batch APIs, read replicas, caching hooks, and a `sql` template operator for raw fragments. Drizzle integrates with validation libraries (zod, valibot, typebox, arktype, effect-schema) for schema-derived validation, and ships an ESLint plugin and a GraphQL extension. The docs site includes guides, tutorials, a gotchas page, and published benchmarks. The project is open source on GitHub (35k+ stars per the homepage) and is backed by PlanetScale. A v1.0 beta with a new alternation engine is available for testing.
The TypeScript ORM.
Prisma started as a type-safe ORM for TypeScript and has grown into a platform that pairs that ORM with managed Postgres and app hosting. You define your data model in a `contract.prisma` file, which acts as the shared contract for the ORM, migrations, and data layer. The pitch is that your coding agent can drive the whole loop — build, deploy, debug, redeploy — through one CLI (`npx prisma deploy`), instead of you wiring together a database from one vendor, an ORM from another, and hosting from a third. App and database deploy co-located on the same host, and each feature branch can get its own preview database tied to its preview deployment. The ORM itself is free; paid tiers cover the managed database and hosting, with spend limits on every paid tier.