Database admin / schema viewer primitives
Visual primitives for an internal database administrator — schema browser, column inspector, ER diagram, SQL editor + results, migrations, indexes, constraints, triggers, stored procedures, schema diff, and backup / restore. Wired to mock Mufflermen schema — no live database connection.
Database admin / schema viewer primitives is a reusable Oak Flats Muffler Men UI primitive with documented states, accessibility expectations, theme behavior, and implementation evidence.
Database admin / schema viewer primitives: Visual primitives for an internal database administrator — schema browser, column inspector, ER diagram, SQL editor + results, migrations, indexes, constraints, triggers, stored procedures, schema diff, and backup / restore. Wired to mock Mufflermen schema — no live database connection.
Schema tree
Left-rail schema browser — schemas → tables / views / materialized views / functions / sequences with counts and filter.
Column list panel
Right panel — columns of a table with type, nullable, default, PK / FK chips, and comment popovers.
ER diagram canvas
SVG entity-relationship canvas — table nodes with column rows, FK arrows, minimap.
Query editor
SQL editor with mono font, line-number gutter, connection chip, row-limit chip, run button.
Query results table
Composes DataTable + row-number column + type-aware cell renderers (number / date / boolean / json) + CSV export.
Migration row
Row per migration — version, name, applied-at, status chip (Pending / Applied / Failed / Rolled back), actions.
Index inspector
Index card — type chip (BTree / GIN / GIST / Hash / BRIN), columns, uniqueness, size, usage chip.
Constraint chip row
Row of PK / FK / UNIQUE / CHECK / NOT NULL chips with click-to-view details popover.
Trigger card
Trigger surface — name, timing (BEFORE / AFTER / INSTEAD OF), event chips, function ref, enabled toggle.
Stored procedure card
Procedure with arg list, return type, language chip, body excerpt rendered through CodeBlock.
Row count badge
Tiny tonal badge with K / M / B suffix that shifts tone for larger tables.
Foreign key arrow
Standalone FK visualizer — source.column → target.column with on-delete / on-update chips.
Schema diff pane
Side-by-side schema diff — left / right with added / removed / changed rows + summary chip row.
Backup / restore panel
Backup list, manual backup CTA, three-step restore wizard (Select → Review → Confirm).
Full database admin
Schema tree + column list + constraint row + index inspector + trigger card + ER tab + query editor + results + backup panel.