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.
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
Entity relationship diagram describes the structure of the database. The entity relationship diagram shows entities (tables in relational databases) and relationships between tables that exist in the database. For a good database design, it is very important to have an entity relationship diagram.
In an entity relationship diagram, the basic elements are:
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, or Heroku Postgres. To manage your database connections, click the Connections button on the main toolbar.
Creating a new database connection
Click the button Create a new connection to open a modal form.… Read the rest
Looking for a free ER diagram tool? There are many on the market and Moon Modeler is one of them. This free ER diagram tool can be used to visually define smaller database structures for relational database systems such as MariaDB, MySQL, PostgreSQL, SQLite, and NoSQL databases such as MongoDB, or object-document mappers such as Mongoose.… Read the rest
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.
Select the database file. In this example, we will load the chinook.db… Read the rest
To generate SQL script from your project click the Script icon on the main toolbar. New modal opens. Click Save Scripts and select a location where the files should be stored. Option Overwrite existing files allows you to ignore existing scripts and overwrite them without getting a warning.