Explore data
Browse servers in the connection tree, read collections in Table, Tree and JSON views, and change documents safely.
Once a connection is open, everything starts from the connection tree on the left of the main window. Open a collection and it appears in a collection tab, where you read its documents page by page, switch between three views, and edit documents or single fields.
Oxys DB Studio is careful with your data: every write checks that the document still is what you saw, destructive actions ask first, and a read-only connection or a locked collection refuses writes in the application itself, not only in the buttons.
The examples in this section use a fictional acme_store database with products, customers and
orders collections.
| Page | What you will learn |
|---|---|
| The connection tree | Nodes, tooltips, search, context menus, colours, aliases and notes |
| The collection tab | Breadcrumb, query bar, Result toolbar, status bar, Count Documents |
| Table, Tree and JSON views | Switching views, columns, embedded fields, display options |
| Paging through results | Page size, navigation, refresh and stop |
| Edit documents and fields | Insert, view, edit, delete, in-place edits, field operations, safety rules |
| Copy and paste | Values, fields, documents, CSV and spreadsheet formats, pasting documents |
| GridFS files | Buckets, uploading, viewing, saving and removing files |
| Tabs and windows | Tab menu, split, undock, rename, colour, session restore |
New to the application? Start with Getting started.
- The connection treeBrowse servers, databases, collections, views, GridFS buckets and indexes, search them, and act on them from their context menus.
- The collection tabWhat each part of a collection tab does: breadcrumb, query bar, Result toolbar, sub-tabs and status bar.
- Table, Tree and JSON viewsRead the same page of documents as a table, a tree or JSON text, and adjust columns, embedded fields and display options.
- Page through resultsMove through a result page by page, change the page size, refresh, stop a slow query and count documents.
- Edit documents and fieldsInsert, view, edit and delete documents, change single values in place, and add, rename, convert or remove a field across many documents, safely.
- Copy and pasteCopy values, fields, paths and whole documents in several formats, paste documents into a collection, and copy collections between servers.
- Work with GridFS filesCreate GridFS buckets, upload files, search, view, rename, save and remove them, and edit their metadata.
- Tabs and windowsArrange your work: switch, rename, colour, duplicate and close tabs, split the work area, move tabs to their own windows, and get your session back after a restart.