What problem does it solve?
Drizzle ORM eliminates the mismatch between TypeScript types and database schemas by providing compile-time, SQL-like query building that stays aligned with your schema definitions.
Core Features & Use Cases
- Type-safe schema + inference: Define tables and columns in TypeScript and get strongly typed insert/select models.
- SQL-like query builder with guardrails: Compose filters, joins, aggregation, pagination, and transactions using an API that maps directly to SQL concepts.
- Practical migrations and performance patterns: Use Drizzle Kit for generating/migrating schema changes and follow best practices for indexing, limiting, and optimizing queries in production.
Use case: You are building an invoicing backend and need to store customers and invoices with reliable migrations, safe query composition (including joins and filters), and consistent TypeScript types across your API routes and server actions.
Quick Start
Use the drizzle-orm skill to implement a pgTable schema and run your first typed insert, select, where-filter, update, and delete for a PostgreSQL database connection.
