Drizzle PostgreSQL Starter

The Drizzle PostgreSQL Starter is a database foundation provided by servercn for projects that use PostgreSQL with Drizzle ORM.

Drizzle Official Docs

Installation Guide

npx servercn-cli init drizzle-pg-starter

What This Starter Solves

Setting up Drizzle with PostgreSQL repeatedly involves:

Database connection management
Schema organization
Migration configuration
Environment-based credentials
Type safety across queries

Environment Configuration

Database credentials are loaded via environment variables.

NODE_ENV='development'
PORT='9000'
LOG_LEVEL='info'
 
DATABASE_URL=postgresql://root:password@localhost:3306/db-name

The server fails fast if required database variables are missing.

Defining Schemas

Schemas are written using Drizzle's SQL-first, type-safe API.

src/drizzle/schema.ts

import { PgTable, serial, varchar } from "drizzle-orm/pg-core";
 
export const usersTable = PgTable("users", {
  id: serial().primaryKey(),
  name: varchar({ length: 255 }).notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
  password: varchar("password", { length: 255 }).notNull()
});

Schemas are:

Explicit
Version‑controlled
Fully typed across queries

Database Client Setup

src/configs/db.ts

import { drizzle } from "drizzle-orm/node-postgres";
import env from "./env";
 
const db = drizzle(env.DATABASE_URL!);
 
export default db;

No repositories or hidden layers — you interact directly with Drizzle.

Migrations Workflow

Generate migrations

npm run db:generate

Apply migrations

npm run db:migrate

Migrations are SQL‑first and fully auditable.

Database Studio

npm run db:studio

Summary

The Drizzle PostgreSQL Starter gives you a clean, production-ready database foundation using PostgreSQL + Drizzle ORM.

It prioritizes clarity, type safety, and long-term maintainability — without taking control away from you.