Mysql(Prisma) Provider

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

Installation Guide

npx servercn-cli@latest add pr mysql-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 = "mysql"
  url      = env("DATABASE_URL")
}
 
model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  password  String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

Usage

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