Drizzle Schema Generator

Drizzle ORM is a TypeScript-first ORM for Node.js that gives you SQL-like syntax in TypeScript. Unlike Prisma, Drizzle generates no runtime client — it compiles your schema to raw SQL queries at build time. This means zero magic, full type safety, and excellent performance. It supports PostgreSQL, MySQL, and SQLite with a unified API.

pgTable() is the core function for defining a PostgreSQL table in Drizzle ORM. You pass the table name as the first argument and a column definition object as the second. Each column is typed using helpers like text(), integer(), boolean(), timestamp(), etc. from drizzle-orm/pg-core. The result is a typed table object you use in queries.

$inferSelect is a TypeScript utility type provided by Drizzle that infers the TypeScript type of a row returned from a SELECT query on your table. Use it to type function parameters, API responses, or state variables without manually writing an interface. There is also $inferInsert for insert row types (which respects optional/default columns).

Copy the generated schema into a file like schema.ts in your project. Import drizzle-orm/pg-core at the top. Then import your table in query files and use it with a Drizzle db instance: db.select().from(yourTable). Drizzle reads the column types and builds fully typed SQL — autocomplete works in VSCode and TypeScript will catch type mismatches at compile time.