About Luna Modeler

Luna Modeler is a data modeling and database design tool for relational databases – SQL Server, PostgreSQL, MariaDB, MySQL and SQLite.

Key features

• visual creation of ER diagrams for relational databases
• support for database specifics (like composite types in PostgreSQL etc.)
• easy-to-use user interface
• various display modes and diagram options
• forward engineering & code generation
• reverse engineering (for SQL Server, MariaDB, MySQL and PostgreSQL)
• secure SSL/TLS connections to cloud based solution like Heroku Postgres etc.
• import from files (SQLite)
• interactive HTML reports generation and export to PDF
• project and ER diagram update
• database schema conversion

See features matrix and compare editions

Videos

Overview of key features

How to visualize existing PostgreSQL databases

How to update ER diagrams in Luna Modeler

Quick start guides

Read the following pages for more information and instructions.
Quick start guides are available for:

SQL Server PostgreSQL MariaDB MySQL SQLite

Editions

Luna Modeler is available in two editions, Basic and Professional. The Professional edition includes all the features of the Basic edition plus

• the ability to create SSH/SSL/TLS connections to databases
• work with multiple diagrams within a single project
• generate interactive HTML reports
• update projects
• compare a project with an existing database and generate detailed HTML reports
• easily open Luna Modeler in a new window (run multiple instances of the application)
• convert database schema from one platform to another

Compare editions