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.
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 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.
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.
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.
Download
Luna Modeler
Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.
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.
Purchase
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.
