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
• generation of ALTER statements for MariaDB, MySQL and SQLite
• database schema conversion

See features matrix and compare editions

Videos

Overview of key features

Videos

Watch more videos and learn how to update a project, how to generate synchronization scripts and more.

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
• generate ATLER scripts for MariaDB, MySQL and SQLite
• 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