MongoDB

Connect to MongoDB databases with QueryBox

QueryBox supports MongoDB through a native driver plugin. Execute MongoDB shell-style queries and manage collections with a familiar interface.

Connection Methods

Basic

Configure your MongoDB connection using individual parameters:

host · string · required

MongoDB server hostname or IP address

Default: 127.0.0.1

port · number

MongoDB server port

Default: 27017

user · string

Database username

password · string

Database password

database · string

Database name to connect to

Placeholder: mydb

auth_source · string

Authentication database

Default: admin

tls · string

Enable TLS/SSL encryption

Options: false, true

Default: false

URI

Provide a complete MongoDB connection URI:

uri · string · required

Full MongoDB connection URI

Format: mongodb://user:pass@host:port/database

Example URI

mongodb://admin:password@localhost:27017/mydb?authSource=admin

Connection String Examples

Local Development

mongodb://127.0.0.1:27017/mydb

With Authentication

mongodb://user:password@localhost:27017/mydb?authSource=admin

MongoDB Atlas

mongodb+srv://username:[e-mail]/mydb?retryWrites=true&w=majority

Replica Set

mongodb://host1:27017,host2:27017,host3:27017/mydb?replicaSet=rs0

With TLS

mongodb://user:pass@localhost:27017/mydb?tls=true&authSource=admin

Supported Query Syntax

QueryBox supports MongoDB shell-style queries:

Collection Queries

// Find documents
db.users.find({})
db.users.find({"status": "active"})
db.users.findOne({"name": "Alice"})

// Insert documents
db.users.insertOne({"name": "Bob", "age": 25})
db.users.insertMany([{"name": "Charlie"}, {"name": "Diana"}])

// Update documents
db.users.updateOne({"name": "Bob"}, {"$set": {"age": 26}})
db.users.updateMany({"status": "inactive"}, {"$set": {"archived": true}})
db.users.replaceOne({"_id": ObjectId("...")}, {"name": "New Name"})

// Delete documents
db.users.deleteOne({"name": "Bob"})
db.users.deleteMany({"status": "archived"})

// Aggregation
db.orders.aggregate([{"$group": {"_id": "$status", "count": {"$sum": 1}}}])

// Count documents
db.users.countDocuments({"status": "active"})
db.users.estimatedDocumentCount()

// Distinct values
db.users.distinct("status")
db.users.distinct("city", {"country": "USA"})

// Create index
db.users.createIndex({"email": 1})

// Drop collection
db.users.drop()

Database Operations

// Create database (implicitly created when you create a collection)
db.createCollection("new_collection")

// Drop database
db.dropDatabase()

// List collections
db.listCollections()
db.getCollectionNames()

Raw Commands

// Execute raw database commands
{"ping": 1}
{"dbStats": 1}
{"collStats": "users"}

Supported Features

CRUD Operations

Find, insert, update, delete documents

Aggregation

Complex data aggregation pipelines

Database Browser

Browse databases and collections

Index Management

Create and manage indexes

Capabilities

• Query Execution: MongoDB shell-style query syntax
• CRUD Operations: Full support for find, insert, update, delete
• Aggregation Framework: Execute aggregation pipelines
• Collection Management: Create and drop collections
• Database Management: Create and drop databases
• Index Operations: Create indexes on collections
• Connection Tree: Browse databases and collections hierarchically
• Document Results: View results as structured documents
• TLS Support: Secure connections with embedded root certificates

Result Types

MongoDB queries return different result formats:

• Document Results: Find, aggregate, and raw command queries
• Key-Value Results: Insert, update, delete operations showing counts and IDs

Database Structure

The MongoDB plugin displays:

1. Databases: All accessible databases
2. Collections: All collections within each database
3. Actions: Quick find and drop operations

Notes

QueryBox uses extended JSON format for BSON types like ObjectID, ensuring proper serialization.

You can execute multiple operations by running them sequentially. Each operation returns its own result.

Drop operations (dropDatabase, drop collection) are permanent and cannot be undone.

Extended JSON Support

QueryBox supports MongoDB Extended JSON for special BSON types:

// ObjectId
{"_id": {"$oid": "507f1f77bcf86cd799439011"}}

// Date
{"createdAt": {"$date": "2023-01-01T00:00:00Z"}}

// NumberLong
{"count": {"$numberLong": "1234567890"}}

Plugin Information

• Version: 0.1.0
• License: Apache-2.0
• Author: MongoDB Inc.
• Tags: nosql, document