Where does the diagram come from?
The diagram is read directly from the connected database's metadata (information_schema and equivalents). There is no manual modeling step and no exported SQL file to keep in sync.
ER Diagram Tool for Live MySQL and PostgreSQL Schemas
- Read from the live schema
- Select to trace relationships
- Laid out automatically
- PNG and SVG export
Runs inside Data Explorer, no external plugin. Have a SQLite file? The free SQLite viewer draws its diagram in your browser.
An ER diagram shows tables, columns, and the foreign-key relationships between them, so the structure of a schema can be read at a glance instead of inferred from DDL or data. ER diagrams are most useful when you need to understand a database you did not design — before a migration, during onboarding, or while reviewing dependencies for a feature change.
The ER diagram tool in DBConvert Streams reads a live MySQL or PostgreSQL connection and renders the schema directly. Tables, primary keys, foreign keys, and view dependencies are read automatically, each foreign key is marked N at the referencing column and 1 at the key it references, and tables joined by keys are laid out in layers so the diagram stays readable as the schema grows.
A selected table with its related tables, joining columns and relationship lines highlighted, read from a live schema.
Schema View, Read from the Live Database
No manual modeling. Open a connection and the schema is already drawn.
- Tables with their columns and types, primary keys and foreign keys, read from the connection
- Every foreign key drawn once, from the referencing column to the key it references
- View dependencies shown on demand, so they do not bury the tables
- Several PostgreSQL schemas framed separately, with foreign keys drawn across them
- Supports self-hosted and managed deployments (AWS, Azure, GCP, Supabase, Neon, DigitalOcean)
Truly Interactive — Not a Static Diagram
Designed for real exploration, not static exports. Navigate complex schemas visually and follow relationships instantly.
Selection and Highlighting
- Click a table: its related tables, joining columns and relationship lines stand out, the rest fades
- Open the diagram from any table and it is centred and selected
- Trace dependencies visually without switching to raw DDL
Navigation
- Pan with the wheel or trackpad, zoom with Ctrl+scroll or a pinch
- Drag tables to reposition them
- Fit the whole schema to the view in one click
Laid Out for Real Schemas
No settings to tune. Tables joined by foreign keys are arranged in layers, left to right, and the tables joined to nothing are packed beside them instead of stretching the diagram into one column.
Layered by relationships
Tables that reference each other sit in successive layers, so a chain of foreign keys reads in one direction.
Unrelated tables packed
Tables joined to nothing are placed in rows in name order, where they can be found by reading along.
Schemas kept together
With several schemas, each schema's tables stay in a frame of their own.
Auto layout
Drag tables where you want them; one click lays the diagram out again.
Relationships That Read Without a Legend
Every foreign key carries N at the referencing column and 1 at the key it references, so the direction of a relationship is clear without knowing an ER notation.
One-to-Many
The most common relationship. One record in the parent table relates to multiple records in the child table.
Example: One customer has many orders.
Many-to-Many
Two tables related through a junction table, which is drawn between them with N on both of its keys.
Example: Films and actors via film_actor table.
View Dependencies
Dashed lines show which tables a view reads. They appear when you select the view, or for every view at once.
Example: A summary view referencing multiple base tables.
Many-to-many, as it is stored. The diagram draws the junction table that holds the relationship, with N on both of its keys, instead of a line that skips it and hides the columns in between.
FAQ
Technical questions
Is the diagram editable?
The diagram represents the live schema, so the data model itself is read-only. The view is interactive — drag tables, pan, zoom, and select a table to isolate its relationships — but you cannot create or drop tables from the diagram.
Does the diagram update when the schema changes?
The diagram reflects the schema at the moment it was opened. Reopen the diagram against the same connection to pick up new tables, columns, or relationships.
Can I export the diagram?
Yes. The whole diagram — not only the part on screen — exports as PNG or SVG for documentation, design reviews, or sharing with people who do not have access to the source database.
See Your Schema as an ER Diagram
Connect a MySQL or PostgreSQL database and read its structure in seconds.
Read the ER Diagrams documentation