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

Luna Modeler is an easy-to-use data modeling and database design tool for many popular databases. The software allows database developers to design database structures and generate SQL scripts for SQL Server, PostgreSQL, MariaDB, MySQL and SQLite. You can also use Luna Modeler to visualize existing databases, enhance entity-relationship diagrams, and generate interactive documentation with database diagrams.

Draw ER diagrams for relational databases
Use Luna Modeler for database design, data modeling and drawing entity relationship diagrams. Quickly define database objects such as tables, columns, keys, indexes, and draw relationships visually in your data models.

Edit objects in your ER diagram quickly and easily
You can edit individual properties of your database design very quickly in the panel on the right side. Larger forms help you easily view more details, where you can use elements that can be easily expanded or collapsed. Use Luna Modeler to accelerate your data modelling tasks.

Generate SQL scripts
Preview and generate SQL scripts for your database designs and diagrams. You can preview and save SQL scripts for whole your database design or for just a single database table or relationship.

Connect to existing databases and generate ER diagrams
Establish connections to existing SQL Server, MariaDB, MySQL, SQLite or PostgreSQL databases, run reverse engineering and create database diagrams automatically. In the Professional Edition of you can establish SSH/SSL/TLS connections to all supported database systems.

Compare & update your database diagrams
Compare your database design to the structure that exists 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.

Create documentation
When designing a database, you can arrange objects into sub-diagrams, add HTML notes etc. A dark or light theme is just a matter of your preference. At any stage of the design process, you can easily generate an interactive HTML report to create useful documentation.

Key benefits of Luna Modeler
data modeling and database design tool
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: Luna Modeler helps team members understand relationships between tables and other objects in database diagrams in an efficient way.

Faster development: Draw database diagrams and generate code. Avoid typos, make changes quickly.

Increased Productivity: Luna Modeler data modeling tool helps increase your productivity by enabling rapid database design and automating repetitive tasks such as generating SQL scripts, creating database diagrams from existing databases, and generating interactive reports.

Cost-Effective Solution: The data modeling tool is a cost-effective solution because it helps to reduce the development time and effort required to create the database. This ensures that the project is completed within budget and on time.

Version 7.5 available
Search and find on diagram
Windows authentication for SQL Server (Windows)
Compression column (PostgreSQL)
Project repair
Fixes for known issues

ONLY for V.I.P/Platinum Members