SQLite to ER Diagram

How it works

1. In the sqlite3 shell run .schema (or .schema --indent) and copy the output.
2. Paste it into the editor — SQLite is parsed automatically.
3. Tables render with columns; REFERENCES become relations.
4. Arrange, hide tables, then export PNG/SVG or share a link.

Example

A SQLite schema like this:

CREATE TABLE customers (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  email TEXT NOT NULL UNIQUE
);

CREATE TABLE orders (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  customer_id INTEGER NOT NULL REFERENCES customers(id)
);

…renders two tables with a relation from orders.customer_id → customers.id. Try it with your own →

Why use it

• 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 diagram a SQLite database?

Open it with sqlite3 mydb.db, run .schema, and paste the output here. The diagram is generated instantly.

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