Prisma Schema Gen

Generates complete Prisma schema files from natural language descriptions, including models, relationships, indexes, and validation.

What This Command Does

Generated Schema:

• Prisma models with fields
• Relationships (one-to-one, one-to-many, many-to-many)
• Indexes and unique constraints
• Default values and validators
• Database-specific configuration
• Example queries

Output: Complete schema.prisma file ready for migration

Time: 3-5 minutes

Usage

# Generate schema from description
/prisma-schema-gen "Blog with users, posts, and comments"

# Shortcut
/psg "E-commerce with products, orders, and customers"

# Specify database
/psg "Task management app" --database postgresql

# With specific relationships
/psg "Social network with users, posts, likes, and follows"

Example Output

Input:

/psg "Blog platform with users, posts, comments, and tags"

Generated schema.prisma:

// This is your Prisma schema file

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model User {
  id        String   @id @default(uuid())
  email     String   @unique
  name      String
  password  String
  bio       String?
  avatar    String?
…

Generated Files

Migrations

# After generating schema, run:
npx prisma migrate dev --name init

# This creates:
# - migrations/
#   └── 20250110000000_init/
#       └── migration.sql

Example Queries (TypeScript)

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

// Create user
async function createUser() {
  const user = await prisma.user.create({
    data: {
      email: '[email protected]',
      name: 'John Doe',
      password: 'hashed_password_here'
    }
  })
  return user
}

// Create post with tags
async function createPost() {
…

Common Patterns

1. E-commerce Schema

model Customer {
  id       String  @id @default(uuid())
  email    String  @unique
  name     String
  phone    String?
  orders   Order[]
  cart     Cart?
}

model Product {
  id          String      @id @default(uuid())
  name        String
  description String?
  price       Decimal     @db.Decimal(10, 2)
  stock       Int         @default(0)
  orderItems  OrderItem[]
  cartItems   CartItem[]
}
…

2. Social Network Schema

model User {
  id        String   @id @default(uuid())
  username  String   @unique
  email     String   @unique
  posts     Post[]
  likes     Like[]
  following Follow[] @relation("Following")
  followers Follow[] @relation("Followers")
}

model Post {
  id        String   @id @default(uuid())
  content   String
  authorId  String
  author    User     @relation(fields: [authorId], references: [id])
  likes     Like[]
  createdAt DateTime @default(now())
}
…

3. Multi-tenant SaaS Schema

model Organization {
  id      String   @id @default(uuid())
  name    String
  slug    String   @unique
  members Member[]
  projects Project[]
}

model User {
  id          String   @id @default(uuid())
  email       String   @unique
  memberships Member[]
}

model Member {
  id       String       @id @default(uuid())
  userId   String
  user     User         @relation(fields: [userId], references: [id])
…

Database Support

PostgreSQL:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

// PostgreSQL-specific types
model Example {
  jsonData Json
  textData String @db.Text
  amount   Decimal @db.Decimal(10, 2)
}

MySQL:

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

SQLite (Development):

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

MongoDB:

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

model User {
  id    String @id @default(auto()) @map("_id") @db.ObjectId
  email String @unique
}

Getting Started

1. Install Prisma:

npm install @prisma/client
npm install -D prisma

2. Initialize Prisma:

npx prisma init

3. Use generated schema:

• Replace prisma/schema.prisma with generated content
• Set DATABASE_URL in .env

4. Create migration:

npx prisma migrate dev --name init

5. Generate Prisma Client:

npx prisma generate

6. Use in code:

import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()

Related Commands

• /sql-query-builder - Generate SQL queries