ER Diagram tool for MySQL
and SQL Server, PostgreSQL, MariaDB and SQLite
Key features for MySQL
Connect to your MySQL database and visualize existing database structures.
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
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.
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.
Database modeling allows all your team members or clients to understand the relationships among tables in your MySQL structures in an effective manner.
Database modeling activities helps you create your MySQL databases visually, the work is faster, you can avoid typos and make changes quickly.
You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.