MongoDB Features

Layouts

The validation schema is represented graphically, using layouts (diagrams). Edit collections validation rule by double-clicking the collection header. Creating a new collection will create the corresponding validation rule in the database. The validation rule will be also saved in the DbSchema model file.

Visual Query Editor

The visual query builder for MongoDB features filters, projections, and aggregation. The generated queries are shown on the right side of the query builder.

HTML Documentation

Double-clicking collection or fields you can add comments. DbSchema can export the MongoDB diagrams as interactive HTML5 or PDF documentation. The collection and field comments can be read as mouse-over tooltips.

Data Generator

You can test your application and MongoDB queries against test data generated using the data generator. The data generator can use pre-configured patterns or reverse regular expressions.

Compare Virtual Schema

The DbSchema model contains its own local image of the database structure. Connecting to other MongoDB database, you can compare the actual model from DbSchema with the connected database.

Query Editor

Visual Query Editor can compose native MongoDB queries. It can use the keyword 'db' for the current connected database, or directly the database name if you need to access multiple databases.

1
2
3
4

use sampleDb
db.employees.find()
db.employees.find({"firstName": {"$regex": "^AL", "$options": "i"}})
db.employees.find({"firstName": {"$regex": "(?i)^AL"}})

1

sampleDb.employees.find()

1

sampledb.getCollection('employees').find();

Further commands available in in the Query Editor are:

• USE mydatabase
• CREATE DATABASE sampledb
• SHOW DATABASES
• SHOW COLLECTIONS
• SHOW USERS
• SHOW PROFILES

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

USE sampledb;

db.getCollection('employees').insert( {
firstName:'John',
lastName:'Smith',
age:28,
hobbies:[
  {
     name:'Swimm'
  },
  {
     name:'Jogging'
  }
]
});

Map-Reduce Jobs

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

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