Luna Modeler is a data modeling and database design tool for relational databases
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 Oracle, SQL Server, MariaDB, MySQL and PostgreSQL)
- secure SSL/TLS connections to cloud based solution like Postgres/Supabase 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
Video – overview of key features
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:
Oracle Database 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
Supported database platforms
Luna Modeler contains support for the following database systems:
If you work with noSQL databases like MongoDB, try Moon Modeler – data modeling tool for noSQL
