DbSchema for MongoDb Diagram Designer and Query Tool

Schema Reverse Engineer

DbSchema is reading random documents from database and builds out of it a virtual schema. The schema is represented as diagrams. The schema and the layouts are saved as project file, so you can connect to another database and compare the schemes.

Diagrams for MongoDb

The reversed engineer schema is displayed in DbSchema as here:

This collection was generated by executing from the DbSchema query editor the following:

local.products.insert({
        "name":"Product",
        "properties":
        {
                "id":
                {
                        "type":"number",
                        "description":"Product identifier",
                        "required":true
                },
                "name":
                {
                        "description":"Name of the product",
                        "type":"string",
                        "required":true
                },
                "price":
                {
                        "type":"number",
                        "minimum":0,
                        "required":true
                },
                "tags":
                {
                        "type":"array",
                        "items":
                        {
                                "type":"string"
                        }
                }
        }
})                    

Visual Query Builder

Visually compose MongoDb queries. The query can make use of sub-documents, as well as filters ( where clause ), group by, etc.

PDF/HTML5 Documentation

Generate HTML5 interactive documentation including the vector diagram image. Moving the mouse over collections or fields you can read the schema comments.

Write Map-Reduce Jobs

Here a sample map-reduce job:

                        local.words.insertOne({word: 'sample'});
                        local.words.insertOne({word: 'day'});
                        local.words.insertOne({word: 'plane'});

                        var m =function map() {
                         emit(this.word, {count: 5})
                        }
                        var r=function reduce(key, values) {
                                var count = 5
                                for (var i = 0; i < values.length; i++)
                                    count += values[i].count
                                return {count: count}
                            }
                        local.words.mapReduce(m, r );

                        or

                        local.words.mapReduce(
                            "function map() { \r\n" +
                            " emit(this.word, {count: 1}) \r\n" +
                            "}",
                            " function reduce(key, values) { \r\n" +
                            "    var count = 0 \r\n" +
                            "    for (var i = 0; i < values.length; i++) \r\n" +
                            "        count += values[i].count \r\n" +
                            "    return {count: count} \r\n" +
                            "}"
                            // , "mrresult"
                        )

Open Source JDBC Driver

We open source our own MongoDb JDBC driver. The driver features:

• Can execute native queries like db.sample.find()
• The driver is build to support all queries as MongoDb Shell
• The connection URL is the same as the MongoDb Java URI
• Adding expand=true in the URL will create a column for each key in the result document key. By default will return only an document which can be read using resultSet.getObject(1)

Download Driver Binaries BitBucket Repository

Connect to Atlas Could

DbSchema can connect to the database using native Java URI. In the connection dialog 'Use JDBC URL' tab you can enter directly a custom URI. Similar connect to MongoDb Atlas Cloud using the URI provided by the Cloud panel. We wrote our own implementation of the JDBC driver for this, on top of MongoDb Java driver.

Relational Data Browse

Use it to simultaneous explore data from multiple collections, based on virtual foreign keys. Virtual Foreign keys can be created in layout by drag and drop of one field ( referring ) over other field ( referred ). They are similar with foreign keys in relational databases, but will be created only in DbSchema. Like for example a field 'ClientObjectId' will refer to 'ObjectId' in 'Clients' collection.

Data can be filtered. Native MongoDb are generated automatically.

If one collection contains ObjectId's referring other collections they are discovered and shown as virtual relations in the diagram. In Relational Data Browse you can cascade from one collection into the referred and view the related documents.

Query Editor

Execute native MongoDb queries against the database.

Collections from different databases can be queried by using db or directly the database name. Sample :

Few query samples:

                    local.persons.find()
                    or
                    use local
                    db.persons.find()
                    

The Query Editor is using Java Script on top of the MongoDb Java Driver.

Compare and Deploy Schema on Multiple Databases

DbSchema reverse engineer the schema in its own internal image, independent from the database. This image will be saved to project file and can be open even without connecting to the database. This will contain also all schema comments, layouts, etc.

After staring one project, you may connect to another database and press 'Refresh Schema from Database'. This will show a dialog where you will see the database differences.

Random Data Generator

Configurable using predefined reverse regular expressions, integer and date generators, groovy generators for JSON objects. From any collection menu you will find the option to start the generator.

Data Loader

For loading data from files into the database.