Mongodb (Prisma)

This provider sets up MongoDB connectivity with Prisma for Express projects, including environment validation, a Prisma client configuration, and a starter schema.

Installation Guide

npx servercn-cli@latest add pr mongodb-prisma

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. Prisma Client

src/configs/prisma.ts

import { PrismaClient } from "@prisma/client";
import env from "./env";
 
const prisma = new PrismaClient({
  log: env.NODE_ENV === "development" ? ["query", "warn", "error"] : ["error"]
});
 
export default prisma;

3. Prisma Schema

src/prisma/schema.prisma

generator client {
  provider = "prisma-client-js"
}
 
datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}
 
model User {
  id       String @id @default(auto()) @map("_id") @db.ObjectId
  email    String @unique
  name     String?
  password String
}

Usage

import prisma from "./configs/prisma";
 
const users = await prisma.user.findMany();

Example .env

NODE_ENV=development
 
DATABASE_URL=mongodb://localhost:27017/app