
What you can do
with Moon Modeler?

Create ER diagram for databases
In your entity relationship diagrams (ER diagram - see wikipedia) you can define database objects like tables, keys, indexes and relations graphically and visualize JSON in the diagrams for MariaDB, PostgreSQL and SQLite. All your definition can be stored and managed in projects and you can easily export ER diagram to PDF and generate SQL code for your projects.
Design nested structures
Visually design MongoDB or Mongoose schema, specify collections and embeddable sub-documents, draw references among collections and define MongoDB collection and field specifics. Create nested structures in MongoDB ER diagram or in other databases.


Keep your ER diagrams
well documented
Arrange objects in entity relationship diagrams, colorize items, change the view to show metadata, sample data or descriptions. Add notes in HTML format or include pictures. Export ER diagrams to printable PDF format. Schema design features now available for GraphQL modeling.
Reverse engineer existing structures
Connect to existing MongoDB, MariaDB or PostgreSQL and reverse engineer database structures with nested documents or json. Easily visualize databases and convert the metadata to ER diagrams.


Preview and generate scripts
Generate validation and creation scripts together with other options. See code preview - formatted and with syntax highlighting.
Add custom code to BEFORE and AFTER sections and save code for the whole ER diagram or just a single collection.
Trial version expires 14 days after installation.
Key benefits
ER diagram is worth a thousand words.
Blueprint to your own product: An ER 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: It allows all your team members or clients to understand the relations among collections and documents in an effective manner.
Faster development: Draw data models and generate code. Avoid typos, make changes quickly.
Looking for a free
ER diagram tool?
Use Moon Modeler. The freeware version allows you to save projects with 10 objects at max.