is a modern database design tool
for relational databases like SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Version 6.1 released!
What you can do
with Luna Modeler?
Create ER diagrams for relational databases
Draw database designs for popular databases like SQL Server, PostgreSQL, MariaDB, MySQL or SQLite. Define database objects such as tables, keys, indexes, and draw relationships graphically in your entity relationship diagrams.
Edit properties quickly
There is a right side panel where you can modify individual properties very quickly. If you need to define, for example, an SQL script, open the selected object in a larger, separate form.
Compare a project with your database and generate a report or update the project
You can now compare your project to the structure that is in the database and easily update your project. See what objects no longer exist in the database, what objects have been added to the database, and what objects are different. In version 6 you can also generate a detailed HTML report.
Keep your database designs well documented
When designing a database, you can organize objects into sub-diagrams, colorize items, add notes in HTML format, connect objects using lines with custom end point graphics. Dark or light theme in the UI is just a matter of your preference.
Preview and generate scripts
Generate SQL scripts for your database designs. 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 database design or for just a single table or relationship.
Reverse engineer existing structures
Connect to existing SQL Server, MariaDB, MySQL or PostgreSQL databases and reverse engineer database structures. In the Professional Edition of the data modeling tool you can establish SSH/SSL/TLS connections to all supported database systems.
A picture is worth a thousand words.
Blueprint to your own product: A diagram can give you a clear model of your data structure and help you recognize errors. It's like a blueprint to your house. You know what you are building, how to connect the pieces and you have the necessary documentation.
Efficient communication: It allows all your team members or clients to understand the relationships among tables and other objects in an effective manner.
Faster development: Draw data models and generate code. Avoid typos, make changes quickly.
Trial/Early Access version expires 14 days after installation.
File size: 77MB
Tested on: Windows 10 Pro
File size: 101MB
Tested on: Ubuntu 20.04
File size: 103MB
Tested on: MacBook Air & Mac M1
Perpertual license with 12 months free updates included.
User-based licensing model. One license key can be used on Windows, Linux and MacOS.