Database Manager

Inspect and manage the server-backed JSON data stores directly from your browser.

Overview

The Database Manager is a visual browser for TotalApp's server-backed JSON data layer. Every piece of data in TotalApp — employees, projects, leaves, expenses, financial accounts, and more — is stored as a JSON file on the server and exposed via a /api/data/* endpoint. The Database Manager lets you browse, inspect, and edit these records without writing code or making raw HTTP requests.

Use with Care on Production

The Database Manager writes directly to the server's JSON files. Changes take effect immediately and are not reversible from within the app. Use it for debugging and data repair on development instances. On production, make a backup before editing.

Endpoint Browser

The left panel lists all available /api/data/* data domains. Click any domain to load its records into the main view. The record count is displayed next to each domain name so you can quickly see how much data is stored.

Domains are colour-coded by module: HR domains use a green accent, Finance domains use blue, PM domains use indigo, and so on — matching the module accent colours used throughout TotalApp.

Record Viewer

After selecting a domain, the main panel displays all records in a table. Table columns are auto-generated from the JSON fields present in the records. Click any row to open the full JSON for that record in the detail panel on the right.

The detail panel renders the JSON with syntax highlighting (keys in blue, strings in green, numbers in orange) and indentation for readability. Use the copy icon to copy the raw JSON to your clipboard.

Record Editor

With a record open in the detail panel, click Edit to switch to edit mode. The JSON becomes an editable textarea. Make your changes and click Save to POST the updated record back to the server. The table row updates immediately to reflect the change.

Validation Before Save

The editor validates that your JSON is syntactically correct before sending it to the server. If the JSON is malformed, the Save button stays disabled and an error message appears below the textarea. Fix the syntax error and try again.

Available Endpoints

Endpoint	Module	Contents
/api/data/employees	HR	Employee profiles, departments, roles, contact info
/api/data/projects-index	PM	Project index with metadata (name, status, members)
/api/data/project/:id	PM	Full project details: columns, cards, member assignments
/api/data/leaves	HR	Leave requests with status, dates, and approvals
/api/data/expenses	HR	Employee expense submissions with categories and amounts
/api/data/overtime	HR	Overtime records with hours, dates, and approval status
/api/data/financial-accounts	Finance	Chart of accounts — account codes, names, types, balances
/api/data/expense-management	Finance	Company-level expense categories and budget allocations
/api/data/my-documents	PM	Saved documents from the Doc View terminal sessions
/api/data/my-presentations	PM	Saved presentations from the Presentation Wizard
/api/data/ecommerce-reports	Marketing	AI-generated ecommerce reports from the Shopify assistant