Moon Modeler

ER Diagram tool for MySQL

and MongoDB, Mongoose, PostgreSQL, MariaDB, SQLite and GraphQL

MySQL ER diagram - made in Moon 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.

Create ER diagrams for MySQL

Define database objects like tables, keys, indexes and relations graphically and visualize JSON in entity relationship diagrams for MySQL. 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.

Database modeling tool for MongoDB - Moon Modeler.
MongoDB database modeling, erd with sample data

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
New - reverse engineering included in version for MacOS

Reverse engineer existing structures

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

Download

Moon Modeler

Supported platforms include MongoDB, PostgreSQL, MariaDB, MySQL, SQLite, Mongoose and GraphSQL.
Moon Modeler for MongoDB and other platforms is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Download Moon 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.

Purchase

Moon 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
$99,-

Go to purchase page

Basic Edition – EDU
$49,-

Request EDU License