🗄️

SQLite Explorer

Diagram (ERD)

Visualize tables and their relationships as an interactive diagram.

The Diagram view

The sidebar's Data | Diagram switcher opens the database's Entity-Relationship Diagram: one card per table, its columns with key and type badges, and an edge for every foreign-key relationship. Click a node to jump back to that table's Data tab in the explorer; the left sidebar stays available for direct navigation. Diagrams are generated from the open database's schema and never leave your machine.

The diagram is rendered by the open-source sqlite-erd package. You can also deep-link to /visualize — with no database open it shows a short explanation instead of an empty canvas.

Views and virtual tables are listed in the sidebar but do not render as diagram cards — the diagram engine parses CREATE TABLE andCREATE INDEX statements only.

Pan, zoom and arrange

Drag the canvas to pan, scroll or pinch to zoom, and drag node cards to arrange them — the layout is fully interactive. Ctrl/⌘ + scroll zooms in place, and the on-canvas controls (bottom-left) fit the view, zoom in or out, and lock interactive mode.