View as Json

PostgreSQL(Drizzle) Provider

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

Installation Guide

npx servercn-cli@latest add pr pg-drizzle

Basic Implementation

1. Env Configuration

src/configs/env.ts
import dotenv from "dotenv-flow";
dotenv.config();
import { z } from "zod";
 
export const envSchema = z.object({
  NODE_ENV: z
    .enum(["development", "test", "production"])
    .default("development")
    
  DATABASE_URL: z.url()
});
 
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;

2. 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;

Usage

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

File & Folder Structure

......

Installation

npx servercn-cli@latest add pr pg-drizzle