erd-editor

Design a database schema visually, import one you already have from SQL DDL, GraphQL SDL, DBML or AML, export DDL, and generate code from the result — in the browser or Google Drive, in VS Code, IntelliJ or Obsidian, or embedded in your own page as a custom element. One editor and one document format across all of them. To try it in an IDE, create an empty file with a .erd.json extension and open it. In Obsidian, run Create new diagram from the command palette. In Google Drive, choose New → More → ERD Editor. - Visual schema design — tables, columns, memos, and four relationship cardinalities (zero-one, zero-N, one-only, one-N) - SQL DDL import — point it at a .sql dump and get a diagram; the parser skips what it does not recognize, so an awkward dump imports partially rather than failing outright - GraphQL SDL import — point it at a schema from any tool that emits SDL and get a diagram. Object types become tables, scalars map to the diagram's own dialect, and the fields that point at another type become the relationships between them - DBML import — read a .dbml file written for dbdiagram.io or dbdocs.io, or emitted by sql2dbml or prisma-dbml-generator. Tables, columns, indexes, enums and every Ref spelling arrive; the elements the diagram has no place for are skipped rather than refused - AML import — read an .aml file written for Azimutt, in either the v2 or the legacy v1 spelling. Entities, attributes, indexes, enums and every relation arrow arrive; a check, a struct type and a view are skipped rather than refused - SQL DDL export — Databricks, MariaDB, MSSQL, MySQL, Oracle, PostgreSQL, Snowflake, SQLite - Code generation — TypeScript, GraphQL, C#, Java, JPA, Kotlin, Scala, Go, SQLAlchemy, TypeORM, Sequelize, Drizzle, DBML, AML - Visualization — a force-directed view of how the tables actually relate - Export — .erd.json, .sql, .png - Quick search, undo / redo, keyboard shortcuts, and a theme builder - Real-time collaboration (experimental) — peer-to-peer, end-to-end encrypted, with no backend holding your schema. Live on erd-editor.io; embedders get the same action stream through the element's getSharedStore() erd-editor is the open-source project dineug/erd-editor (https://github.com/dineug/erd-editor) by dineug, released under MIT. Ion packages it unmodified from commit 6bf15dfc5460, adding only a manifest, an icon and a storage compatibility script.

Written by dineug, published to Oikou by Ben Grande.

• ★ 1,718 stars on GitHub
• Licence: MIT
• Upstream version v3.9.2
• Built from commit 6bf15dfc5460

View the repository on GitHub

Not rated. Nobody has said who this app is suitable for, so Personal Clouds and the Oikou app treat it as 18+.

Internet

It asks to reach these hosts, and no others:

• fonts.googleapis.com
• fonts.gstatic.com
• www.googleapis.com
• accounts.google.com
• oauth2.googleapis.com
• lh3.googleusercontent.com
• sentry.io

Personal Cloud tools

• Keep a database of its own on your Personal Cloud ion.db

Notifications

It does not send push notifications.

Storage

Up to 16 MB on your Personal Cloud.

Sign in to add this web app to a Personal Cloud of yours. It runs there, on your own computer, and you open it from there; nothing is installed on your phone.

Sign in to add