MongoDB Atlas ER Diagram Designer | DbSchema

Mongodb • 15-Dec-2020
by DbSchema Team

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

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

Follow the steps below to create the cluster.

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 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 the preferred programming language and click 'Connect cluster' to copy the connection URL.

How to get the MongoDb Atlas Java URL

Download and install DbSchema

DbSchema Database Designer

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 diagrams will be visible.

Database Diagrams for MongoDb Atlas

DbSchema ER Diagrams & Team Collaboration

Visual Desktop Software
DbSchema ER Diagram Try DbSchema
Visual Design & Modeling
Visual Design & Schema Diagram

✓ Create and manage your database schema visually through a user-friendly graphical interface.

✓ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

✓ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

✓ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

✓ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

✓ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

✓ Generate HTML5 documentation that provides an interactive view of your database schema.

✓ Include comments for columns, use tags for better organization, and create visually reports.