Drizzle

Overview

Adds Drizzle ORM with PostgreSQL. Schema lives in TypeScript under db/schema/, with a shared client in lib/db.ts.

Prerequisites

None. Mutually exclusive with Prisma — choose one ORM per project.

Installation

npx ds-start init my-app --drizzle

With Better Auth:

npx ds-start init my-app --drizzle --auth

What It Adds

• db/schema/ — Database schema files (TypeScript)
• db/schema/events.ts — Starter events table
• drizzle.config.ts — Drizzle Kit configuration
• lib/db.ts — Shared Drizzle client instance for server-side usage

Environment Variables

First-run Setup

# Set your DATABASE_URL in .env.schema
bun run env:check
bun run db:push

Usage

Database client

Import db from @/lib/db in Server Components, Route Handlers, or Server Actions — never instantiate the Drizzle client directly.

Adding tables

1. Create a new file in db/schema/ (e.g., db/schema/posts.ts).
2. Define your table using pgTable() from drizzle-orm/pg-core.
3. Re-export from db/schema/index.ts.
4. Run bun run db:generate to generate a migration.
5. Run bun run db:push (dev) or bun run db:migrate (prod) to apply.

Scripts