Automated Schema Introspection
Live ER Diagram & Database Schema Visualizer
Understand complex database structures in seconds. SQLite Studio introspects your tables, columns, and foreign key relations to render interactive, draggable entity-relationship diagrams right alongside your query editor.
Primary & Foreign Keys
Instantly recognize primary keys (🔑) and foreign keys (🔗) with color-coded badges and column type markers.
Curved Relation Connectors
Smooth SVG cubic bezier lines link foreign keys to target parent tables, complete with directional arrowheads.
Click-to-Query
Click "Query Table" on any card in the diagram to insert SELECT * FROM table LIMIT 100 directly into your editor.
Try Creating a Table and Querying It
SQLite 3 WASM
Interactive SQL Editor3 tables available
Press "Run Query" or Ctrl+Enter
Executing query...
Experience the Live ER Diagram
Open the full dual split-screen IDE, switch to the Schema tab, and interact with the ERP relational diagram.
Open ER Diagram in Studio IDE