DbSchema can reverse engineer the validation rules from each MongoDB collection and represent it as diagrams. Creating new collections will also implement the validation rules in the database. DbSchema can also visually build MongoDB queries, explore data from the database, generate test data, and create reports.
Download 15 Days Free Trial Purchase
MongoDB is using validation rules to ensure a certain structure of a collection. DbSchema can reverse engineer the validation rules and show them as diagrams. Creating new collections in DbSchema will also implements the validation rules in the database. Collections from the local or admin databases, where the validation is not supported, are also represented as diagrams, using the structure we guess by scanning a limited number of documents.
Comments on collections or fields can be added directly in the diagram. The comments will be saved in the collection validation rule and to the model file.
Next HTML5 or PDF documentation can be generated, where the collection and field comments can be read as mouse-over tooltips.
Read More
DbSchema can reverse engineer a Model by reading the validation rule for each database collection. The validation model is saved to the file. The MongoDB model can be also designed from scratch.
Database Data Explorer from multiple MongoDB collections simultaneously. This works using virtual foreign keys.
In the image below the country_id in the countries collection is a unique identifier of each country. The same field is used in the cities collection. We created virtual foreign keys between these two fields by drag and drop of one field over the other field.
Below the diagram, we started a Relational Data Explorer.
Where we explore data from the collection 'countries'. Next to it is the cities collection. Navigating in the first collection
will show the matching records in the child collections. Like this, we can explore data from multiple collections simultaneously.
Right-clicking the collection header we can set filters.
Read more
There is no need to learn the MongoDB query language.
Using the Visual Query Builder for MongoDB you can create native queries for MongoDB, with projections, filters, or aggregate functions.
Read more
DbSchema includes a Query Editor capable to execute native MongoDB queries.
The editor features text auto-completion, syntax highlight, execute scripts, and more.
Read more
Developers may need to check queries against a large volume of test data.
The Data Generator can use reverse regular expressions, pre-configured patterns, or values from files.
Read more
DbSchema can compare the database model with other databases or other model files and show the differences.
Read More
In many situations, you may need to execute different tasks, like generate HTML5 documentation or reverse engineer the database structure without visual interaction.
This can be done using Groovy or JS scripts, with full access to DbSchema API.
Read More
Fields that unique identifies a document in a collection (like ObjectId) can be used in other documents to refer to that document.
In DbSchema you can create virtual foreign keys to show this.
Later they can be used in the Relational Data Explorer to visualize data from multiple collections simultaneously.
Read More
Build master-detail reports with charts, images, buttons.
They can be executed as stand-alone report server.
Read More
DbSchema can load import in the MongoDB database from various formats, such as CSV, XML, TXT, etc.
Read More
