erd.tools
Free · No sign-up · Nothing installed

SQLite to ER Diagram

Paste sqlite3 mydb.db .schema output — inline REFERENCES, WITHOUT ROWID and type affinity handled.

SQL input — CREATE TABLE · DDL · dumpsqlite
sqliteSample: · ·
Diagram—

Your diagram renders here.

Parser coverage

What we parse in sqlite

  • Inline REFERENCES — SQLite's column-level foreign keys parsed wherever they appear
  • WITHOUT ROWID — recognized, no phantom rowid column
  • Type affinity — TEXT, INTEGER, BLOB, REAL, NUMERIC shown verbatim
  • PRIMARY KEY (a, b) — composite keys marked on both columns
From your database

Get just the schema

sqlite3 mydb.db .schema > schema.sql

Then paste schema.sql. No drivers, no GUI — works on any .db file you can open locally.

FAQ

Questions, answered

How do I get the schema out of a SQLite database?

Run sqlite3 mydb.db .schema and paste the output above.

Does it support WITHOUT ROWID tables?

Yes — they render like any other table, without a phantom rowid column.

More converters

Also available