Generate ER Diagrams from Live MySQL and PostgreSQL Schemas
Generate interactive ER diagrams from PostgreSQL and MySQL connections. Inspect relationships and structure instantly.
Runs inside Data Explorer, no external plugin.
ER diagram summary
- - Auto-generated from live schema metadata
- - Crow's foot notation with junction table detection
- - Interactive exploration with drag, pan, zoom, and highlighting
Auto-Generated Schema View
No manual modeling. Open a connection and generate a diagram instantly.
- Automatically detects tables, primary keys, foreign keys, and relationships
- Crow's foot notation with automatic many-to-many junction detection
- View dependency visualization with dashed relationship lines
- Supports self-hosted and managed deployments (AWS, Azure, GCP, Neon, DigitalOcean)
Interactive ER diagram with crow's foot notation — auto-generated from a live database schema.
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 to highlight related objects
- Related tables highlighted while non-related objects are de-emphasized
- Trace dependencies visually without switching to raw DDL
Navigation
- Drag tables to reposition them
- Pan and zoom smoothly across the diagram
- Reset view to return to initial state
Intelligent Force-Directed Layout
Complex schemas remain readable. A D3-powered force-directed graph engine arranges tables automatically, and you can tune the layout to fit your schema.
Link Distance
Controls spacing between connected tables. Increase to spread tables apart.
Charge Strength
Controls repulsion between tables. More negative values push tables further apart.
Collision Radius
Minimum distance between tables to prevent overlap.
Zoom Controls
Zoom in and out with controls, mouse wheel, or reset to fit all tables.
Adjust link distance, charge strength, and collision radius to optimize layout for dense schemas.
Standard Crow's Foot Notation
Relationships are displayed using industry-standard crow's foot notation, so diagrams are immediately readable by any database professional.
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. Automatically detected when a table has exactly two foreign keys forming a composite primary key.
Example: Films and actors via film_actor table.
View Dependencies
Dashed lines show which tables a view depends on, making it easy to trace data lineage.
Example: A summary view referencing multiple base tables.
Junction table detection. Tables with exactly two foreign keys that form a composite primary key are automatically identified as junction tables and rendered with many-to-many relationship lines.
Generate Your ER Diagram
Connect your database and visualize its schema in seconds.
Read the ER Diagrams documentation