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

Open Source JDBC Driver

We wrote our own MongoDb JDBC driver which scans the database collections and discovers the schema. This driver is written on top of the native MongoDb java driver. Database connectivity works over native 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.

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

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