NoSQL MongoDB

Note: MongoDB extension is available in Lite, Enterprise, and Ultimate editions only.

Browsing Mongo collections

You can view/edit the Mongo collections content as standard relational tables (grid/plain text presentations) or as JSON documents. The presentation can be switched in the Results Viewer toolbar. In the grid, DBeaver will try to unify all documents in some particular collection (as they have the same structure/the same set of properties).

Executing JS

JS statements can be executed in the SQL editor as usual. Mongo scripting reference The following example creates a user in the current database.

db.createUser(
  {
    user: "testuser",
    pwd: "test",
    roles: []
  }
)

This example returns all documents in the collection, 'test_col':

db.test_col.find().toArray()

Note: The script will be executed in the current database. You can not set an explicit database name in your query. The current database can be changed on the SQL Editor toolbar or in the Database Navigator.

Executing SQL

You can use standard SQL statements (SELECT, INSERT, UPDATE, DELETE) to manipulate the Mongo data.

SELECT * FROM test_col
WHERE propName.subProp='value';

UPDATE FROM test_col
SET propsName.val1=123
WHERE propName.subProp='value'

Nested JSON properties can be divided by dot.