MongoDB schema design

Quick start guide for MongoDB schema design in Moon Modeler.

How to get started with MongoDB schema design?

The following text explains how to design a new database structure for MongoDB.

1. Create a new Project

To create a new project in Moon Modeler click the New item on the toolbar.… Read the rest

MongoDB indexes

MongoDB indexes

When you create a new index for MongoDB collection in Moon Modeler, the Index Assistant window will appear.

index assistant for mongodb indexes

Indexes can be defined easily. Just select the fields, either from the drop down element:

mongodb index creation

or by typing the field name directly. The auto-completion feature is available for you.

fields in mongodb index

Click the Add button to insert the field to the index.… Read the rest

Reverse engineering

Reverse engineering means retrieving information about the database structure. It is about finding out what objects exist in the database, such as tables, columns, views, procedures, etc., and what relationships exist between these objects. Based on this information, it is possible to draw an ER diagram in which the relationships can be clearly displayed.… Read the rest

Database connections

Moon Modeler allows you to visualize existing relational and noSQL databases. You can connect to your locally running or cloud database, for example solutions running in MongoDB Atlas, Cosmos DB, AWS Amazon DocumentDB or Heroku Postgres. To manage your database connections, click the Connections button on the main toolbar.… Read the rest

Import & Visualization of existing SQLite databases

Connection to SQLite database is not classic, so you will not find the option of this database in the connections section. To visualize an existing SQLite database structure, go to the Projects section and import SQLite from a file.

Import file - SQLite

Select the database file. In this example, we will load the chinook.db… Read the rest

Visualization of existing MySQL databases

All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MySQL and enter the connection details.

When you are finished, click the Save Connection button.

Database connections

Your new MySQL connection will appear in the list of all database connections.… Read the rest

Visualization of existing MariaDB databases

All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select MariaDB and enter the connection details.

When you are finished, click the Save Connection button.

Database connection

Your new MariaDB connection will appear in the list of all database connections.… Read the rest

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

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. It can also be used for solutions like Cosmos DB, AWS Amazon DocumentDB or Heroku Postgres and others. The software belongs to the data modeling and schema design tools category and can be used to model hierarchical database structures.… Read the rest

PostgreSQL database design - visualization

Visualization of existing PostgreSQL databases

All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select PostgreSQL and enter the connection details.

When you are finished, click the Save Connection button.

Database connections

Your new PostgreSQL connection will appear in the list of all database connections.… Read the rest

Quick links

Free Trial Buy Now!

Blog categories