DiagrammingERDData

Entity Relationship Diagrams (ERD)

Design database schemas visually: tables, columns, primary keys, foreign keys, and relationships. Export SQL and a PDF data dictionary for documentation.

🧱
Table‑style entities
Entities render as professional table cards with fields and PK/FK markers.
🧭
Crow’s Foot toggle
Switch notation between Crow’s Foot and Chen as you model.
📄
SQL + PDF exports
Export PostgreSQL DDL and a PDF data dictionary for handoffs.
Best for
  • Database schema design
  • FK relationship mapping
  • Architecture & data platform docs
  • Sharing with engineers and DBAs
Pro tips
  • Define PK fields first, then mark FK fields and reference PKs.
  • Use Auto‑Layout to quickly space out tables, then fine‑tune manually.
  • Export PDF for stakeholders; export SQL for implementation.
  • Use Import SQL to reverse‑engineer from DDL (best-effort).

About this tool

Create ERD diagrams with entities, fields, PK/FK constraints, and relationships. Export SQL and documentation.

What it does

  • Design database schemas visually with entities and relationships.
  • Export PostgreSQL DDL and share diagrams for review.

How to use

  • Click Create ERD.
  • Add entities and fields (PK/FK).
  • Export SQL or SVG when ready.

FAQ

Can I export SQL?
Yes. Export generates PostgreSQL DDL (best-effort).
Can I import SQL?
If supported on the editor, import can parse basic CREATE TABLE statements (best-effort).
Does it support PK/FK?
Yes. You can mark fields as PK/FK and link relationships.