DbSchema for MongoDb Diagram Designer and Query Tool

  • DbSchema discovers the schema and shows it as visual diagrams.
  • Integrated visual query builder, query editor, relational data browse, random data generator, HTML5 documentation and more.
  • Schema and diagrams are saved as XML file and can be stored in GIT.
  • Visual interaction with MongoDb.

DbSchema can be evaluated 15 days for free.

Video Download & Evaluate Buy

DbSchema Database Tool
Video Presentation

Key features

Diagrams for MongoDb

DbSchema 'discovers' the MongoDb schema structure and shows it as tree and as diagrams. As example a collection may show like this:

MongoDb Diagram

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.

MongoDb Visual Query Builder

HTML 5 Documentation

Generate HTML5 interactive documentation including the vector diagram image.

HTML5 Documentation

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"
                        )

Connect using MongoDb URI

DbSchema can connect to MongoDb using the native Java URI. In the connection dialog Advanced tab you can directly enter a custom URI. DbSchema open source JDBC driver is written on top of MongoDb Java driver.

Connect to MongoDb Atlas Cloud

Connect to MongoDb Atlas Cloud by copy/paste of the URI provided in Atlas into DbSchema Advanced tab / Connect using custom URI.

Open Source JDBC Driver

We are using our own JDBC driver which discovers the schema structure by partially scanning the collections from the database. This driver is written on top of the native MongoDb java driver. Database connectivity works as described in MongoClientURI.

Relational Data Editor

Relational Data Editor may help you to explore database data only using the mouse.

Data Explorer for MongoDb

Data can be filtered. Native MongoDb are generated automatically.

Browse Filter

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.

Virtual Relations

Query Editor

Execute native MongoDb queries against the database.

MongoDb Query Editor

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.

One License for All Databases + MongoDB, All Operating Systems

DbSchema can connect via JDBC drivers to all SQL databases + MongoDB.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool

Free Trial

Download DbSchema and try it 15 days for free.

Technical Support

Registered and unregistered users may benefit from technical support.

1 Year Renewals Included

Purchase DbSchema and you will get 1 year free update with all new developed features and bug fixes.

Money Back Guarantee

Not happy with DbSchema ? 30 days after purchase you can claim your money back.

Navigation