DbSchema represents the MongoDB validation rules and collection structure as diagrams. The newly created collections will get the validation rules implemented in the database. Visual tools like visual query builder, relational data editor, or data generator make DbSchema is a day-by-day tool for database administrators, project managers, and developers.
Download 15 Days Free Trial PurchaseMongoDB is using validation rules to ensure a given structure of a collection. DbSchema can reverse engineer the validation rules and show them as diagrams. Creating new collections in DbSchema will also implement the validation rules in the database. DbSchema is drawing as diagrams the collections without validation rules by scanning the collection structure for several documents and guessing the fields out of that.
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
The MongoDB collection structure including the validation rules are reverse engineer into the DbSchema Model. The model is saved to the file. Advantages:
Database Data Explorer from multiple MongoDB collections simultaneously, based on virtual relations.
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 relation (similar with foreign keys in SQL databases) between these two fields by drag and drop of one field over the other field.
Below the diagram, we started a Relational Data Editor.
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.
This is a MongoDB client.
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 relations to show this.
Later they can be used in the Relational Data Editor 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