Overview
DBeaver EE supports MongoDB schema browser, data viewer, SQL and JavaScript queries execution.
Also it supports various administrative tools (like server sessions manager).
DBeaver uses MongoDB Java driver 3.8.0 to operate with server. It supports MongoDB servers from 2.x to 4.x.
Connecting to MongoDB Server
You can connect directly to a server or use SSH tunneling or SOCKS proxy.
Browsing Mongo collections
You can view/edit MongoDB collections content as standard relational tables (grid/plain text presentations) or as JSON documents. Presentation can be switched in the Results Viewer toolbar.In grid DBeaver will try to unify all documents in some particular collection (as they have the same structure/the same set of properties).
Executing JavaScript
JS statements can be executed in SQL editor as usual. Mongo scripting reference Following example creates a user in the current database.db.createUser(
{
user: "testuser",
pwd: "test",
roles: []
}
)
{
user: "testuser",
pwd: "test",
roles: []
}
)
db.test_col.find().toArray()
Note: script will be executed in the current database.
You can not set explicit database name in your query.
Current database can be changed in SQL Editor toolbar or in Database Navigator.
Executing SQL
You can use standard SQL statements (SELECT, INSERT, UPDATE, DELETE) to manipulate Mongo data.SELECT * FROM test_col
WHERE propName.subProp='value';
UPDATE FROM test_col
SET propsName.val1=123
WHERE propName.subProp='value'
WHERE propName.subProp='value';
UPDATE FROM test_col
SET propsName.val1=123
WHERE propName.subProp='value'