Visual Database Design Tool for PostgreSQL
and Oracle, SQL Server, MySQL, MariaDB, SQLite
Luna Modeler is a powerful desktop application designed specifically for visual database modeling with full support for PostgreSQL-specific features.
Learn more about Luna Modeler
Ideal for developers, data engineers, architects, and educators who work with PostgreSQL and need an intuitive, user-friendly visual tool to manage database structures and data models.
Download Luna Modeler
Frequently Asked Questions on Database Design for PostgreSQL
A visual data modeling tool like Luna Modeler allows you to easily design ER diagrams using an intuitive interface. You can define tables, composites, relationships, and PostgreSQL-specific objects like enums, domains, sequences and other objects with just a few clicks. Luna Modeler is more than a simple drawing application and so it works with object dependencies and supports SQL script generation.
Yes, Luna Modeler lets you connect to a live PostgreSQL instance and automatically create an ER diagram based on the existing schema. This is helpful for documentation and redesign.
You can export your entire diagram as PostgreSQL specific SQL script with a single click. Luna Modeler allows you to include pre/post SQL blocks and write templates for custom scripts as well.
In Luna Modeler you can create a conceptual, logical or physical data model. The logical data model can be converted to a physical model for PostgreSQL, SQL Server or other platforms. For more accurate database modeling, start with the physical model for the selected database system.
Yes, it’s available for Windows, macOS, and Linux. Supported database platforms include: PostgreSQL, Oracle Database, SQL Server, MySQL, MariaDB and SQLite.
A 14-day trial lets you explore all professional features with minimal limitations.
Key Features of Luna Modeler
Database Design Tool for PostgreSQL
Visual ER Diagrams for PostgreSQL
You can create PostgreSQL data models visually, outline tables, composites, and enums, draw relationships, and detail the specifics of PostgreSQL tables and columns.
PostgreSQL Data Model and Schema Management
You can create new objects with predefined settings, assign schema to database objects, divide diagrams to sub-diagrams.
Luna Modeler also allows you to update projects from databases, convert diagrams from other database platforms and more.
Reverse Engineering
Connect to an existing PostgreSQL database and auto-generate a complete ER diagram. SSH/SSL/TLS connections are supported in the Professional Edition.
SQL Script Generation
Generate SQL scripts for your database designs by clicking a button on the main toolbar to see the code preview.
Export Diagrams & Database Documentation
Export ER diagrams to PDF, PNG, or generate interactive HTML reports in various themes and styles.
Download
Luna Modeler
Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.