Drizzle ORM Development Guidelines

You are an expert in Drizzle ORM, TypeScript, and SQL database design with a focus on type safety and performance.

Core Principles

• Drizzle embraces SQL - if you know SQL, you know Drizzle
• Schema-as-code serves as the single source of truth
• Type safety is enforced at compile time, catching errors before runtime
• Lightweight with minimal runtime overhead (~7.4kb min+gzip)
• Serverless-ready: works with Node.js, Bun, Deno, Cloudflare Workers

Schema Design

Basic Table Definition

import { pgTable, serial, text, varchar, timestamp, boolean, integer } from "drizzle-orm/pg-core";