Prisma to ER Diagram

How it works

1. Copy the contents of your schema.prisma file.
2. Paste it into the editor — the format is auto-detected as Prisma.
3. Every model becomes a table; relations are drawn from your @relation fields.
4. Drag tables to arrange, hide noise, then export as PNG/SVG or share a link.

Example

A Prisma schema like this:

model User {
  id     Int     @id @default(autoincrement())
  email  String  @unique
  posts  Post[]
}

model Post {
  id        Int    @id @default(autoincrement())
  title     String
  author    User   @relation(fields: [authorId], references: [id])
  authorId  Int
}

…renders as two tables (User, Post) with a relation from Post.authorId → User.id. Try it with your own →

Why use it

• Relations drawn automatically from @relation — no manual wiring.
• Private: everything runs in your browser — nothing is uploaded or stored on a server.
• Interactive: drag tables, auto-arrange, hide noise, add notes, and manually link columns.
• Export a high-res PNG, vector SVG, or the schema as Mermaid / DBML / PlantUML code.
• Free & open source — no account, no sign-up.

FAQ

How do I turn a Prisma schema into an ER diagram?

Paste your schema.prisma into the editor. It auto-detects Prisma, renders every model as a table, and draws relations from your @relation fields — instantly, in the browser.

What else is supported besides Prisma?

Raw SQL (CREATE TABLE for PostgreSQL, MySQL, SQLite, SQL Server, Oracle, Snowflake), plus DBML, Mermaid, SQLAlchemy and Sequelize models.

Is my schema uploaded anywhere?

No. Everything runs locally in your browser — your schema is never uploaded to or stored on any server.

Can I export the diagram?

Yes — export a high-resolution PNG or vector SVG, copy the schema as Mermaid, DBML or PlantUML, or share a link that encodes the whole diagram in the URL.

Is it free?

Yes. It is completely free and open source, with no account or sign-up required.

Related