Document and NoSQL
MongoDB
MongoDB uses a document-first workbench with collection builders, aggregation helpers, explain dashboards, diagnostics, and guarded document edits.
Prerequisites
- Install the current DataPad++ desktop pre-release on Windows, macOS, or Linux.
- Have the endpoint, database file, or cloud account details for a MongoDB datastore you are authorized to use. Start with least-privileged, read-only access.
- Keep an independent backup before enabling edits, administration, restore, or transfer execution.
Connect and run a safe query
- 1
Create the connection
Open Library, choose Create connection, and select MongoDB and a supported Connection method tab.
- 2
Test and save
Complete the applicable fields and enable Read-only connection. Test connection when available; new local files and pending secondary credential changes must be saved first. Review runtime limitations and warnings.
MongoDB connection setup. The MongoDB connection dialog with supported method tabs and illustrative, non-secret settings. Expand optional sections and review runtime limitations before saving. Open full size - 3
Open the native explorer
Use Save Connection, or Create Database and Save Connection for a new local file, then open the MongoDB Explorer where supported.
- 4
Select a scope
Select the database / container scope that should be attached to the new tab.
- 5
Run a bounded read
Open a query tab, paste the bounded read-only sample below, and choose Run or press Ctrl/Cmd+Enter.
MongoDB native workflow. A representative MongoDB explorer and bounded read-only workflow. Replace the example objects with names from your datastore. Open full size - 6
Inspect the result
Inspect Results, Messages, History, and Details; dock the panel on the bottom or right as needed.
- 7
Export when needed
Export only the required rows after reviewing format, destination, and redaction options.
- 8
Open diagnostics or transfers
Open Diagnostics or Transfers from the drawer/status bar and treat disabled reasons as capability boundaries, not transient errors.
Connection fields
| Field | Required | Purpose | Safe example |
|---|---|---|---|
| Name | Yes | A clear profile name, without credentials. | MongoDB development |
| Connection method | Yes | Choose a supported tab. The fields below apply only to the selected method and deployment. | Connection fields / Connection string |
| Environment | No | Attach the intended variable and safety context. | Local development |
| Read-only connection | No | Enable for initial exploration. This does not make pre-release software safe for production workloads. | Enabled |
| Host / Port | No | Endpoint for a fields-based connection. Follow the selected deployment and runtime limitations; MongoDB SRV does not use an explicit port. | localhost / engine default |
| Database / default scope | No | Initial scope for browsing, where supported. | catalog |
| Complete connection string | Yes | Required in Connection string mode only. Saved unchanged as one vault secret with Save Connection. Blank keeps an existing stored value. | Paste your complete provider string; do not share it |
| Username | No | Authentication identity for the selected method. | catalog_reader |
| Password | No | Required only when the chosen authentication needs it. Save Connection stores changes; blank preserves an existing value, and Reveal… explicitly discloses it. | Stored in the desktop OS vault |
| Deployment | No | General. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | mongodb / mongodb+srv |
| Authentication database | No | Authentication. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Authentication mechanism | No | Authentication. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Application name | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Replica set | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Use TLS | No | TLS & certificates. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Query timeout (ms) | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Connect timeout (ms) | No | Advanced. Time allowed to establish a socket. Zero disables this timeout. | Driver default |
| Server selection timeout (ms) | No | Advanced. Time allowed to find a suitable server. | Driver default |
| Direct connection | No | Advanced. Use only with a single standard MongoDB host, not SRV discovery. | Driver default |
| Retry eligible reads | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Retry eligible writes | No | Advanced. Driver-managed retryable writes only; requires server support. | Driver default |
| Read preference | No | Advanced. Secondary reads may return older data. | primary / primaryPreferred / secondary / secondaryPreferred / nearest |
| Minimum pool size | No | Advanced. Optional, depending on the method and server. Review runtime limitations before overriding the driver default. | Driver default |
| Maximum pool size | No | Advanced. Zero means no pool-size limit. | Driver default |
| Maximum idle time (ms) | No | Advanced. Zero means no idle-time limit. | Driver default |
| CA certificate file | No | TLS & certificates. PEM file path. Environment variables may be used. | Driver default |
| Client certificate and key file | No | TLS & certificates. PEM file path, not the certificate contents. For an encrypted key, use a complete connection string. | Driver default |
Run the sample query
MongoDB read-only example
db.products.find({ active: true }, { name: 1, category: 1 }).sort({ name: 1 }).limit(25)Explore and inspect
- Browse databases, collections, views, GridFS buckets/files, indexes, validation rules, schema previews, users, roles, statistics, and collection actions.
- Inspect expandable document rows, raw JSON/BSON views, field side panels, efficiency mode for large nested documents, and local document search.
- Document insert, replace, delete, and field set/unset/rename/type-change edits require collection and document identity plus environment guardrails.
Diagnose, administer, and transfer
- Review explain dashboards, profiler data, current operations, replica posture, shard posture, index usage, database statistics, and performance payloads.
- Review index management, validation views, GridFS tools, schema previews, document insert/upload workflows, users, roles, and guarded bulk-write previews.
- On supported self-managed MongoDB servers, create, edit and delete database users and custom roles through confirmed native commands. Assign multiple roles, edit privileges and advanced authentication options; built-in roles stay read-only. Browser preview is plan-only, and Atlas security requires its control plane.
- Import — Live. MongoDB preserves native BSON values through Extended JSON or BSON document streams. Formats: Canonical Extended JSON (native), BSON sequence (native), NDJSON (portable), CSV (portable-lossy). Destinations: local file.
- Export — Live. MongoDB preserves native BSON values through Extended JSON or BSON document streams. Formats: Canonical Extended JSON (native), BSON sequence (native), NDJSON (portable), CSV (portable-lossy). Destinations: local file.
- Backup — Unavailable. This datastore has no supported in-process or server API for a full native backup artifact. Formats: Native managed backup (native). Destinations: cloud uri, server path. Full MongoDB backup and restore require excluded vendor tooling or storage-backend access.
- Restore — Unavailable. This datastore has no supported in-process or server API for a full native backup artifact. Formats: Native managed backup (native). Destinations: cloud uri, server path. Full MongoDB backup and restore require excluded vendor tooling or storage-backend access.
Capabilities and availability
| Capability | Status | Notes |
|---|---|---|
| Native explorer | Available | Browse databases, collections, views, GridFS buckets/files, indexes, validation rules, schema previews, users, roles, statistics, and collection actions. |
| Read queries | Available | Use find builder, raw command JSON, aggregation work, and sandboxed mongosh-style JavaScript with CRUD, bulk, transaction, index, collection, command, BSON, and output APIs. |
| Inline editing | Guarded | Requires key evidence, a writable profile, and environment confirmation. |
| Diagnostics / administration | Guarded | Review index management, validation views, GridFS tools, schema previews, document insert/upload workflows, users, roles, and guarded bulk-write previews. |
| Import / export / transfer | Guarded | Availability follows the authoritative runtime transfer manifest and shows a disabled reason when execution is not implemented. |
Safety and limitations
Troubleshooting
| Symptom | Resolution |
|---|---|
| Test connection fails or times out | Verify endpoint, port, TLS mode, proxy settings, service health, firewall rules, and network access. Keep the profile unsaved until the test explains the failure. |
| Explorer branches are empty or disabled | Confirm the selected database / container, refresh the branch, and grant the minimum metadata permissions described in the connection warning. |
| Run, edit, admin, or transfer is disabled | Read the visible disabled reason. Select a compatible target, turn off read-only only when authorized, or use the documented preview/export fallback. |
| The sample query fails or returns different columns | Replace the example names with objects from your MongoDB datastore, confirm the selected database / container, and keep the query bounded while you validate the result. |