Composition / Full database admin

Full database admin scene

Composition layering all 14 primitives — schema tree on the left, selected table view in the centre (columns + constraints + indexes + triggers with an ER diagram tab), query editor + results below, and backup / restore in the right column. Backed by a mock Mufflermen schema across public / analytics / audit.

Production answer

Full database admin scene is a reusable Oak Flats Muffler Men UI primitive with documented states, accessibility expectations, theme behavior, and implementation evidence.

Primary CTAReview Full database admin scene states
Generative search brief

Full database admin scene: Composition layering all 14 primitives — schema tree on the left, selected table view in the centre (columns + constraints + indexes + triggers with an ER diagram tab), query editor + results below, and backup / restore in the right column. Backed by a mock Mufflermen schema across public / analytics / audit.

Live composition — public.quotes
Schema18 objects
Columnspublic.quotes10 cols · 1 pk · 1 fk
  • iddefault: nextval('quotes_id_seq')
    bigint
    PKNOT NULL
  • customer_id
    bigint
    FKNOT NULL
  • vehicle_rego
    varchar(8)
    NOT NULL
  • exhaust_kinddefault: 'cat-back'
    varchar(40)
    NOT NULL
  • subtotal_centsdefault: 0
    integer
    NOT NULL
  • gst_centsdefault: 0
    integer
    NOT NULL
  • statusdefault: 'draft'
    quote_status
    NOT NULL
  • valid_until
    date
    NULL
  • created_atdefault: now()
    timestamptz
    NOT NULL
  • updated_atdefault: now()
    timestamptz
    NOT NULL
Constraints
quotes_pkeyBTreeUnique
id
Size 1.1 MBhigh
quotes_customer_id_idxBTree
customer_id
Size 805 KBhigh
quotes_status_partial_idxBTree
status
Size 188 KBmedium
quotes_set_updated_atBefore
UPDATE
Callsfn_set_updated_at()
quotes_audit_logAfter
INSERTUPDATEDELETE
Callsfn_audit_log()
Backup / Restore4 backups available
  • scheduled2026-05-27 03:00 UTC4.2 GB30d
  • scheduled2026-05-26 03:00 UTC4.2 GB30d
  • manual2026-05-25 14:22 UTC4.2 GB90d
  • scheduled2026-05-25 03:00 UTC4.2 GB30d
Restore wizard
Pick a backup from the list above to begin a restore.
Queryprod · postgres
SQL190 chars5 lines
Result5 rows· 184ms8 columns
#
18,421BVR-2183,102142,500sentfalse2026-05-26 08:14:22.000 UTC["urgent","catback"]
28,420TKM-9912,89089,900draftfalse2026-05-26 07:48:01.000 UTC[]
38,419OAK-4474,044268,400acceptedtrue2026-05-25 16:02:11.000 UTC["fleet"]
48,418FLT-0084,0440rejectedfalse2026-05-25 11:30:00.000 UTCnull
58,417RX7-3221,188412,100acceptedtrue2026-05-24 19:55:43.000 UTC["premium","stainless"]