Drizzle ORM
TypeScript ORM that feels like SQL. Lightweight, fast migrations, great with AI.
In plain English
Like a translator between you and a foreign-language filing cabinet. You say 'find all customers in New York' in your language, and it translates that into the database's language to get the answer.
Real-world example
You're building an e-commerce store. Instead of writing raw database commands to find 'all orders over $50 from the last 30 days', you write it in TypeScript and Drizzle translates it — and warns you if you make a typo.
Where this fits in your project
This sits between your app code and your database. It turns TypeScript into SQL queries.
When to use this
When you want to write database queries in TypeScript that look and feel like SQL. Lightweight, fast, and works great with AI code generation.
The situation
You have a Postgres, MySQL, or SQLite database and you want type-safe queries without the overhead of a heavy ORM.
Good for
- + TypeScript projects
- + Serverless apps (lightweight)
- + Teams that know SQL
Not ideal for
- - Beginners who don't understand SQL at all
- - Projects that need Prisma's migration GUI
Getting started
Install with `npm install drizzle-orm`, define your schema in TypeScript, run `drizzle-kit push`.