Prisma MySQL Starter

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

Prisma Official Docs

Installation Guide

npx servercn-cli init prisma-mysql-starter

What This Starter Solves

Setting up Prisma with MySQL repeatedly involves:

• Database connection setup
• Prisma client initialization
• Schema definition and migrations
• Environment configuration
• Query logging and debugging

Environment Configuration

Database credentials are loaded via environment variables.

NODE_ENV='development'
PORT='9000'
LOG_LEVEL='info'
CORS_ORIGIN='http://localhost:3000'
ENABLE_SWAGGER='true'
 
DATABASE_URL='mysql://root:password@localhost:3306/db-name'

The server fails fast if required database variables are missing.

Defining Schemas

Schemas are defined using Prisma's declarative schema language.

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}
 
generator client {
  provider = "prisma-client-js"
}
 
model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  password  String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

Schemas are:

• Explicit
• Version‑controlled
• Fully typed across queries

Database Client Setup

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;

No repositories or hidden layers — you interact directly with Prisma Client.

Migrations Workflow

MySQL supports full Prisma migrations, unlike MongoDB's push-only workflow.

Create and apply a migration

npm run db:migrate

Deploy migrations in production

npm run db:deploy

Push schema without migration (prototyping)

npm run db:push

Prisma Studio

Browse and inspect your MySQL data visually in the browser.

npm run db:studio

Recommended Extensions

For the best experience working with Prisma schemas, install the official Prisma extension for VS Code.

{
  "recommendations": [
    "Prisma.prisma"
  ]
}

The extension provides:

• Syntax highlighting for .prisma files
• Auto-formatting on save
• IntelliSense and field autocomplete
• Jump to definition for models and enums

VS Code will automatically prompt anyone who clones the project to install it.