drizzle-orm

Type-safe SQL in TypeScript uses schema inference to automatically derive query result types from table definitions, eliminating manual type annotations. Drizzle ORM generates types directly from your schema, so inserts, selects, and updates are type-checked at compile time.

Define your schema in TypeScript, generate SQL migrations using drizzle-kit, then apply them to your PostgreSQL database. This approach combines version-controlled schema changes with type safety, ensuring your database structure and application types stay synchronized.

Yes, drizzle-orm supports type-safe relational queries through a fluent API that handles joins and nested data fetching. Query results are automatically typed based on your table relations and selected fields, catching errors at build time.

Drizzle-kit handles migration generation and application as part of the drizzle ecosystem, so you don't need a separate tool. It integrates directly with your schema definitions to create and track schema changes.

Set DATABASE_URL in your environment, create a database connection instance, define your schema, then use drizzle-orm in your API routes or server actions. Templates for database connection and schema setup are provided to accelerate initial configuration.

ORMs abstract SQL, which can reduce control over query optimization and performance tuning for complex queries. Drizzle mitigates this by exposing raw SQL when needed, but complex analytics or legacy schemas may benefit from direct SQL access.