Loading the canvas…

How to use ER Diagram Maker

Type columns one per line — “user_id int FK users.id” — and export the schema as SQL when you are done.

  1. Start from the store or blog schema, or a blank page.
  2. Add tables and list columns as name, type and PK / FK markers.
  3. Drag from the blue + to link tables; pick the cardinality.
  4. Export SQL, an image or a PDF.

Questions

What SQL does it export?

Standard CREATE TABLE statements with NOT NULL, PRIMARY KEY and FOREIGN KEY … REFERENCES clauses from your columns.

How do I write a foreign key?

Add “FK table.column” after the type, for example: author_id int FK authors.id.

Is anything uploaded?

No. The editor, your photos and every export run in your browser. An unfinished project is kept for recovery on this device only, and “Save project” downloads a file you control.

Ratings & reviews

No ratings yet. Signed-in users can rate this app.