MongoDB ER diagram graphics

Settings for MongoDB ER diagram graphics can be defined on two levels in Moon Modeler. On a project level and on a selected object level.

Project graphics

Click the MongoDB ER diagram area to make sure no object is selected. Then change the colors in section Graphics. Alternatively, edit Project properties and specify settings on tab Graphics of the modal form.… Read the rest

NoSQL data modeling

Data modeling is the process of visually creating a graphical representation of a system or database. In the case of relational databases, we can mention the creation of entity-relational diagrams in which entities, attributes and relationships between entities are displayed. (Read more information about ER diagrams).

Advantages of data modeling

  • Fewer design and development errors
  • Easy and fast design, especially in the early stages of development
  • Better communication between team members
  • Time saving
  • Lower development costs
  • and many others

MongoDB schema design and noSQL database modeling

But what is the advantage of data modeling when we talk about noSQL databases?… Read the rest

Compare editions

Moon Modeler is available in two editions, Basic and Professional.

Moon Modeler FeaturesBasicProfessional
Supported platforms
MongoDBYes Yes
Mongoose Yes Yes
PostgreSQL Yes Yes
MariaDB Yes Yes
MySQL Yes Yes
SQLite Yes Yes
GraphQL Yes Yes
Data modeling
ER diagrams and visual schema design Yes Yes
Support for platform specific objects Yes Yes
Visualization of nested/embedded objects Yes Yes
Automatic creation of foreign keys Yes Yes
Default values for a project Yes Yes
Custom data types for a project Yes Yes
User interface
Dark and light theme Yes Yes
Custom colors for items on ER diagrams Yes Yes
Undo Yes Yes
Find an object Yes Yes
Objects filtering Yes Yes
Automatic object resizing Yes Yes
Multiple objects alignment and resizing Yes Yes
Multiple line modes Yes Yes
Multiple display modes Yes Yes
Optional display of embedded objects on diagram Yes Yes
Optional display of database/schema name Yes Yes
Autolayouts Yes Yes
Zoom Yes Yes
Subdiagrams for objects in a subject area Yes
Subdiagram creation for schema/database Yes
Code generating
Generating project script Yes Yes
Generating subdiagram script Yes
Settings for output formatting (relational databases) Yes Yes
Order items (relational databases) Yes Yes
Export to PDF Yes Yes
Export subdiagram to PDF Yes
Interactive HTML reports Yes
Multiple styles for HTML reports Yes
Visualization of existing structures
Basic database connections & reverse engineering Yes Yes
Secure SSH connection & reverse engineering Yes
Secure SSL/TLS connection & reverse engineering Yes
Import from SQLite files Yes Yes
Import from GraphQL files Yes Yes
List price99 USD149 USD

Buy a license now

Database reporting

Creation of HTML reports for your data models

Note: The database reporting and HTML report creation is available only in the Professional edition of Moon Modeler

Key benefits of the generated HTML reports

  • HTML and SVG format – high quality format of the graphics and lines.
  • Interactive diagrams – click on any item in the diagram to open the detail.
Read the rest

Moon Modeler user interface

  1. Projects
  2. Connections
  3. Panels
  4. Settings & Themes
  5. Display modes – Metadata, Sample data or Description
  6. Line modes – Basic or Detailed

1. Projects

Saved projects are displayed on the Projects page. From this window, you can create new projects, open projects from a file or from a URL, import SQLite database structures or GraphQL schema.… Read the rest

About Moon Modeler – a data modeling tool for relational and noSQL databases

Moon Modeler is a data modeling tool for MongoDB, PostgreSQL, MariaDB, MySQL, SQLite, Mongoose and GraphQL. The software belongs to the data modeling and schema design tools category and can be used to model hierarchical database structures. Embedded documents can be displayed inside MongoDB collections, JSON structures in MariaDB, MySQL, PostgreSQL or SQLite entity relationship diagrams (ERD). … Read the rest

Mongoose schema design

Quick start guide for Mongoose schema design in Moon Modeler.

  1. New project
  2. Mongoose schema design – schemata
  3. Mongoose schema design – nested types
  4. Embedded documents, schema and references
  5. Code generation

1. New project

To create a new project, click the New item on toolbar and select Mongoose project type.

Mongoose project

Later you can edit the project and choose colors for background, lines and footer.… Read the rest

Generating MongoDB schema validation scripts

To generate a MongoDB schema validation script from your project, click the Script icon on the main toolbar. A preview of the script will appear in the modal form.

Click the Save Scripts button and select a location to save the files.

Script generation

The Overwrite existing files option allows you to ignore existing scripts and overwrite them without displaying a warning.… Read the rest