Luna Modeler logo
Luna Modeler

ER Diagram tool for MySQL

and SQL Server, PostgreSQL, MariaDB and SQLite

MySQL ER diagram - made in Luna Modeler

Key features for MySQL

Draw ER diagrams

Enjoy drawing entity-relationship diagrams for MySQL and create your databases easily and visually.

Reverse engineer

Connect to your MySQL database and visualize existing database structures.

Create documentation

Share your pixel-perfect diagrams in high-quality printable PDF format.

Generate scripts

Save your time and generate, preview and save SQL scripts for your MySQL databases.

ER diagram tool for MySQL - Luna Modeler

Create ER diagrams for MySQL

Define database objects like tables, keys, indexes and relations graphically. Manage your database structures in projects, export diagram to PDF and generate SQL code for your projects.

Quick start guide for MySQL

Quick and comfortable database modeling for MySQL

Draw new objects with predefined settings. Change column positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are saved immediately and in case you need to revert your changes, use the UNDO functionality. You can also easily switch between dark and light theme.

MySQL database diagram made in Luna modeler - ER diagram tool for MySQL
MySQL database design - notes in ERD

Keep your database designs
well documented

During your database modeling activities you can arrange MySQL objects in diagrams, colorize items, change the view to show metadata, sample data or descriptions. Add notes in HTML format, connect objects using lines with custom end point graphics or include pictures to your database models. You can also export diagrams to high-quality, vector format, PDF files.export diagrams to high-quality PDF files.

Preview and generate SQL scripts

Generate SQL scripts together with other options. When you database modeling for MySQL is finished, 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 MySQL database modeling project or for just a single MySQL table or relationship.

Generated SQL script for MySQL
MySQL connection details

Visualize existing structures

Connect to an existing MySQL, MariaDB or PostgreSQL database platform and reverse engineer database structures. SSH/SSL/TLS connections to MySQL databases are supported in the Professional Edition.


Luna Modeler

Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Download Luna Modeler

Key benefits – ER diagram tool for MySQL

Blueprint to your own product

A diagram can give you a clear model of your database 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

Database modeling allows all your team members or clients to understand the relationships among tables in your MySQL structures in an effective manner.

Higher productivity

Database modeling activities helps you create your MySQL databases visually, the work is faster, you can avoid typos and make changes quickly.


Luna Modeler

You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.

Basic Edition

Go to purchase page

Professional Edition

Go to purchase page

Basic Edition – EDU

Request EDU License