Database modeling tool for PostgreSQL
Key features for PostgreSQL
Create ER diagrams for PostgreSQL
Database modeling features include a visual definition of basic and nested PostgreSQL database structures. Visually design PostgreSQL data models, specify tables, composites, JSON objects, enums, draw relationships among tables and define PostgreSQL table and column specifics.
Quick and comfortable database modeling for PostgreSQL
Create new objects with predefined settings. Change field positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are propagated and saved immediately and in case you need to revert changes, use UNDO. A dark or light theme in UI is only a matter of your preference.
Keep your database designs
During your database modeling activities you can arrange PostgreSQL objects in diagrams, colorize items, change the view to show metadata, sample data or descriptions. Add notes in HTML format, connect objects using lines with custom end point graphics or include pictures to your database models. You can also export diagrams to high-quality, vector format, PDF files.
Preview and generate scripts
Generate SQL scripts together with other options. When you database modeling for PostgreSQL is finished, click a button on the main toolbar and immediately see code preview.
You can also add custom code to BEFORE and AFTER sections and save scripts for whole your PostgreSQL database modeling project or for just a single PostgreSQL table or relationship.
Reverse engineer existing structures
Connect to an existing PostgreSQL, MariaDB or MongoDB database platform and reverse engineer database structures with nested documents or JSON. SSH connections are for PostgreSQL are on our roadmap.
Trial version expires 14 days after installation.
Key benefits - PostgreSQL database modeling
The following 3 points represent the main benefits for users interested in PostgreSQL database modeling.