Prisma schema visualizer

Paste your Prisma schema and instantly see an entity-relationship diagram. Visualize models, scalar fields, types, and relations — all in your browser.

Prisma schema

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

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

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

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

model CategoryOnPost {
  post       Post     @relation(fields: [postId], references: [id])
  postId     Int
  category   Category @relation(fields: [categoryId], references: [id])
  categoryId Int
  assignedAt DateTime @default(now())

@@id([postId, categoryId])
}

ER diagram

Paste a Prisma schema above to generate a diagram.

What is a Prisma schema?

A Prisma schema (schema.prisma) is the single source of truth for your database structure in a Prisma project. It defines models that map to database tables, fields that map to columns, and relations between models using the @relation directive. This tool reads that schema and renders it as a visual entity-relationship diagram.

Unlike raw SQL DDL, the Prisma schema includes relation fields that exist only at the ORM level. This visualizer filters those out and shows only the scalar fields that correspond to actual database columns, giving you a clear picture of what the underlying database looks like.

When to use a Prisma schema visualizer

Onboarding to a Prisma codebase — understand the data model without reading every migration
Reviewing schema changes in a pull request — paste the new schema and see the shape at a glance
Adding documentation to your project README or design doc with an up-to-date diagram
Planning new models and relations before writing the actual schema code
Communicating the database structure to teammates who aren't familiar with Prisma syntax

From schema diagrams to live dashboards

Understanding your schema is step one. Basedash goes further — connect your database and describe the chart or metric you need in plain English. Basedash writes the SQL, runs it against your real data, and renders the visualization automatically. It works with PostgreSQL, MySQL, BigQuery, Snowflake, and 750+ other data sources.

FAQ

What parts of a Prisma schema does this parse?

Is my schema stored or sent to a server?

How are relations detected?

Why don't relation fields appear in the diagram?

Can I export the diagram?

Does it handle multi-file Prisma schemas?

Related tools

Skip the SQL — let AI build your charts

Connect your data and describe what you want to see. Basedash handles the query, visualization, and dashboard.

Start free Book a demo