PostgreSQL(Drizzle) Provider

This provider sets up PostgreSQL connectivity with Drizzle ORM for Express projects, including environment validation, a database client, and a logger.

Features

Type-safe environment validation with Zod
Ready-to-use Drizzle client for PostgreSQL
Pino logger configured for dev and production

Installation Guide

npx servercn-cli add pr pg-drizzle

File Structure

MVC

src/configs/env.ts
src/configs/db.ts
src/utils/logger.ts

Feature

src/shared/configs/env.ts
src/db/db.ts
src/shared/utils/logger.ts

Environment Configuration

src/configs/env.ts

import "dotenv-flow/config";
import { z } from "zod";
 
export const envSchema = z.object({
  NODE_ENV: z
    .enum(["development", "test", "production"])
    .default("development"),
  PORT: z.string().regex(/^\d+$/, "PORT must be a number").transform(Number),
  DATABASE_URL: z.url(),
  CORS_ORIGIN: z.url(),
  LOG_LEVEL: z
    .enum(["fatal", "error", "warn", "info", "debug", "trace"])
    .default("info")
});
 
export type Env = z.infer<typeof envSchema>;
 
const result = envSchema.safeParse(process.env);
 
if (!result.success) {
  console.error("❌ Invalid environment configuration");
  console.error(z.prettifyError(result.error));
  process.exit(1);
}
 
export const env: Readonly<Env> = Object.freeze(result.data);
 
export default env;

Database Client

src/configs/db.ts

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

Logger

src/utils/logger.ts

import pino from "pino";
import env from "../configs/env";
 
export const logger = pino({
  level: env.LOG_LEVEL,
  transport:
    env.NODE_ENV !== "production"
      ? {
          target: "pino-pretty",
          options: {
            colorize: true,
            translateTime: "yyyy-mm-dd HH:MM:ss",
            ignore: "pid,hostname"
          }
        }
      : undefined
});

Usage

import db from "./configs/db";
 
// Example insert call:
// await db.insert(usersTable).values(user);

Example .env

NODE_ENV=development
PORT=8000
DATABASE_URL=postgresql://username:password@localhost:5432/mydb?schema=public
CORS_ORIGIN=http://localhost:3000
LOG_LEVEL=info