DbSchema Database Designer

DbSchema | Design MongoDB Atlas Using Diagrams

Publish on DbSchema Blog >>>

In this article you will learn how to connect to MongoDB Atlas and design the database visually, using diagrams.

You may create a Free MongoDB Atlas database by logging in logging in the Cloud Console.
There you can create your own cloud database.

You have to parse the steps below to get the cluster created.

How to Create a MongoDb Atlas Cloud Database

Create the cluster.

This can be a shared cluster, for free.

Create the database user

You will use this user to connect to the database.
Here I have created a user ‘dprutean’.

Create user in MongoDb Atlas

Enable Network Access.

The database it is not accessible from outside unless you enable network access. You can simply add the
‘Currently connected IP’ to the allowed hosts.

How to configure MongoDb Atlas Network

In the console dashboard we can see now our created cluster.

MongoDb Atlas Console Dashboard

Load Sample Data

Sample data can be loaded by clicking the collection link in the dashboard. There you can choose to load the sample data.

Get the Connection URL

Choose ‘Java’ as preferred programming language and click ‘Connect cluster’ to and copy the connection URL.

How to get the MongoDb Atlas Java URL

Download and install DbSchema

DbSchema is a free database designer available at DbSchema.com.

Choose to start a new project connected to the database. The Connection Dialog will show up.
Choose ‘Manual URL configuration’ and paste the JDBC URL here.

DbSchema Connection Dialog to MongoDb Atlas

MongoDB Diagrams

You will be asked to select the databases to work with. Select all databases, and in the next step the layouts (diagrams)
will be visible.

Database Diagrams for MongoDb Atlas

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams, by double-clicking them. Changes will be saved to the design model and, if DbSchema is connected to the database also into the database. More.

Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected. Choose 'Edit Manually' into the JDBC URL combo to enter a custom URL. More.

Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys. Double-click cells to edit the data. More.

Query Builder alt >

Query Builder

Create SQL Queries featuring JOINS, GROUP BY, ORDER BY just using the mouse. More.

SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries. The editor is autocompletion-enabled. More.

Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model. More.

Dark Theme alt >

Dark Theme

Configurable styles & dark theme. More.

Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.

DbSchema can be downloaded for free. No registration is required.