Skip to content

DB Manager

The DB Manager gives direct access to CreativeHub's database records - the projects, their folders, and the commits and files that make up their history. It is the same tool as the Studio DB Manager, and it carries the same risk: what you change here is written straight to the database, with no undo.

Where to Find It

Open the user menu in the top-right corner, choose Admin Settings, then select DB Manager from the left-hand menu. The direct address is http://[serverIP]:5700/admin/dbmanager.

The collections

The column on the left lists the CreativeHub collections:

Collection Holds Columns shown
Commits One record per commit, with its message, author and whether it is still pending. ID, Message, Username, Project, Pending
Files One record per file changed by a commit. ID, File, Path, Commit, Operation, Size
Folders The project folder tree, including folders that have been deleted. ID, Name, Path, Parent, Deleted
Projects One record per project. ID, Name, Folder, Type, Deleted
Users The CreativeHub users. ID, Name

Pick a collection to list its records, and use the pager underneath to step through a large collection.

Following a record to the next collection

The buttons above the table jump from the selected record to the records that belong to it, with the filter already set:

Collection Buttons
Commits Files - the files in this commit. Projects - the project it belongs to.
Folders Projects - the projects in this folder.
Projects Commits - the commit history of this project.
Users Commits - everything this user has committed.

Filtering

The small JSON editor above the table takes a MongoDB filter. Type the filter and click the button to apply it - for example:

1
    { "deleted": true }

An empty or invalid filter lists everything.

Editing a record

Click a row to load the full record, as JSON, into the editor on the right. From there:

  • Update writes your edited JSON back, after asking Are you sure you would like to update the document?.
  • Delete removes the record, after asking Are you sure you would like to delete?.
  • Download, on the Files collection, saves the stored file under its original name. It is disabled for a record that has no stored file.

The + button, which creates a new record, is not offered for Commits and Files.

Warning

Deleting or editing a record here changes only that record. Nothing that refers to it is updated, so a hand edit can leave a project whose commits and files no longer match. Take a backup first.

Best Practices

  • Always create a backup before making any changes via DB Manager.
  • Use the collection buttons to trace a problem - project → commits → files - rather than guessing IDs.
  • Avoid deleting records outright; a project or folder marked deleted is recoverable, a removed record is not.