Prisma to ERD

Generate Entity Relationship Diagrams from your Prisma schema files

Prisma Schema

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

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

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  posts     Post[]
  profile   Profile?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Profile {
  id     Int     @id @default(autoincrement())
  bio    String?
  userId Int     @unique
  user   User    @relation(fields: [userId], references: [id])
}

model Post {
  id        Int      @id @default(autoincrement())
  title     String
  content   String?
  published Boolean  @default(false)
  authorId  Int
  author    User     @relation(fields: [authorId], references: [id])
  categories PostCategory[]
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Category {
  id    Int    @id @default(autoincrement())
  name  String @unique
  posts PostCategory[]
}

model PostCategory {
  postId     Int
  categoryId Int
  post       Post     @relation(fields: [postId], references: [id])
  category   Category @relation(fields: [categoryId], references: [id])

@@id([postId, categoryId])
}

Auto Relationships

Automatically detects and visualizes model relationships

Schema Validation

Validates Prisma schema syntax and highlights issues

Multiple Formats

Export diagrams as SVG, PNG, or PDF

Need Custom Database Tools?

We build advanced database design tools and schema management systems for development teams.

Website Development

Custom websites and web applications

Software Development

Desktop and enterprise software solutions

UI/UX Design

Beautiful and intuitive user interfaces

SEO Services

Improve your search engine rankings

How It Works

Paste Schema

Add your Prisma schema code

Parse Models

Automatically extract models and fields

Generate ERD

Create visual relationship diagram

Export

Download in your preferred format