SQLite ER Diagram - Visualize Database Relationships

Generate entity-relationship diagrams from SQLite databases. See tables, columns, and foreign key relationships visually.

Load Database

Load a database to generate ER diagram

Security: Only process files from sources you trust. All processing happens locally in your browser.

Each table appears as a box with columns listed. Lines connect tables that have foreign key relationships.

We read SQLite's pragma foreign_key_list for each table. Tables must be created with FOREIGN KEY constraints.

Yes. Drag tables to rearrange the layout. The diagram auto-positions initially but you can customize it.

No. The diagram is generated locally using SQL.js. Your data stays in your browser.

Yes. Export as PNG image or SVG for vector graphics. Great for documentation.

All tables are shown. Tables without relationships appear unconnected but are still displayed.

Yes. Column names are shown with their declared types. Primary keys are highlighted.

Yes. Use mouse wheel or pinch to zoom in/out. Drag to pan around large diagrams.

Standard SQLite files: .sqlite, .db, .sqlite3, .db3

Works well with up to ~50 tables. Very large schemas may be slow to render.