TotalApp Docs
Ctrl K
EN | TR
Go to App

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.

Screen preview

A quick look at the screens. Use the toggle in the corner of each preview to switch between the dark and light themes.

app.totalapp.app/developer/database
🗄 Database Manager postgres://prod-db:5432
Query 1 Schema History
SELECT u.id, u.name, u.email,
      COUNT(o.id) AS order_count,
      SUM(o.total) AS total_spent
FROM users u LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at > '2026-01-01'
GROUP BY u.id ORDER BY total_spent DESC LIMIT 20
4 rows returned · 20 of 1,284 users ⚡ 12ms
ID Name Email Orders Spent
#1042
Alice Martin
alice@acme.io
47
$8,420
#0887
Bob Chen
bchen@corp.com
31
$6,110
#2201
Sarah Young
sara@startup.dev
28
$5,780
#0391
Tom Walsh
twalsh@labs.io
19
$3,290

Database manager

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

EndpointModuleContents
/api/data/employeesHREmployee profiles, departments, roles, contact info
/api/data/projects-indexPMProject index with metadata (name, status, members)
/api/data/project/:idPMFull project details: columns, cards, member assignments
/api/data/leavesHRLeave requests with status, dates, and approvals
/api/data/expensesHREmployee expense submissions with categories and amounts
/api/data/overtimeHROvertime records with hours, dates, and approval status
/api/data/financial-accountsFinanceChart of accounts — account codes, names, types, balances
/api/data/expense-managementFinanceCompany-level expense categories and budget allocations
/api/data/my-documentsPMSaved documents from the Doc View terminal sessions
/api/data/my-presentationsPMSaved presentations from the Presentation Wizard
/api/data/ecommerce-reportsMarketingAI-generated ecommerce reports from the Shopify assistant