MongoDB schema design

Quick start guide for MongoDB schema design in Moon Modeler.

The following text explains how to design a new database structure for MongoDB.
This article is divided into the following sections:

  1. New project
  2. MongoDB schema design – collections
  3. MongoDB schema design – documents
  4. Embedded documents vs References
  5. Code generation

1. New Project

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

Import GraphQL from file

Importing a GraphQL schema from a file

Moon Modeler is a data modeling tool and one of its most used features is the modeling and visualization of existing GraphQL schemas. In this section we will look at the ability to import a GraphQL schema from a file.

In the demonstration we will use the StarWars schema. If you want to try the procedure, save the file from the page: https://github.com/graphql/swapi-graphql/blob/master/schema.graphqlRead the rest

Import GraphQL from URL

Importing a GraphQL schema from URL

In Moon Modeler you can

  • model new GraphQL schema diagrams,
  • import an existing schema defined in JSON format,
  • and also import GraphQL schema from online sources.

In this section, you will learn how to import a GraphQL schema from an online source and how to modify the visualization. The StarLink schema, available at https://api.spacex.land/graphql/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

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

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, lock dimensions 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
Optional display of estimated size Yes Yes
Optional display of relationship captions Yes Yes
Autolayouts Yes Yes
Zoom Yes Yes
Subdiagrams
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
Reporting
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 (RE) Yes Yes
Secure SSH connection & reverse engineering Yes
Secure SSL/TLS connection & reverse engineering Yes
MongoDB Atlas, Cosmos DB, Heroku PostgresYes
Import from SQLite files Yes Yes
Import from GraphQL files or URL Yes Yes
Pricing
List price99 USD149 USD

Buy a license now

Quick links

Free Trial Buy Now!

Blog categories