DbSchema can reverse engineer a virtual schema from MongoDB and represent it as diagrams, can edit native queries visually, explore data from the database, generate random data, and create reports.
Download 15 Days Free Trial PurchaseDbSchema can create a model from the database structure by reading sample documents from each collection. The MongoDB model is represented as diagrams and will be saved as a model file. This gives you the flexibility of designing MongoDB databases visually.
Comments on collections or fields can be added directly in the diagram. The comments will be saved 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 sample documents from each MongoDB collection. This is done using the open-source JDBC driver. The model is saved to the model 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 responsive web reports which can be deployed on a stand-alone Tomcat server.
The reports can use multiple master-details sections.
You can also build small applications with input fields and buttons to access and edit the data from the database.
Read More
DbSchema can load import in the MongoDB database from various formats, such as CSV, XML, TXT, etc.
Read More