epic(viz): ER diagram, charts and plans: correct on real data, consistent with the UI kit #1166

Goal

Make the visual parts of Querya (ER diagram, result charts, query plans, dashboards) correct on real data and consistent with the UI kit. Findings of the UI review, Oct 2026.

Children

ER diagram (on top of #1145; #1157 before #1149 so the Relations view reuses it)

• fix(erd): long column types overflow the card, PK+FK shows only PK, colour/font literals #1152 fix: long column types overflow the card, PK+FK shows only PK, colour/font literals
• fix(erd): cap PNG export size, make SVG export look like the screen #1153 fix: cap PNG export size, SVG export looks like the screen
• feat(erd): fit to screen, zoom controls, table search, click to select #1154 fit to screen, zoom controls, table search, click to select
• feat(erd): double click opens the table browser, card context menu, keys-only cards #1155 double click opens the table browser, card context menu, keys-only cards
• feat(erd): nullability, optional/mandatory edge ends, edge tooltip #1156 nullability, optional/mandatory edge ends, edge tooltip
• ui(erd): toolbar, Export menu and empty/error states per UI kit #1157 toolbar, Export menu and empty/error states per UI kit

Charts (#1158 first: it defines Top N and aggregation used by #1160)

• fix(charts): bar/line silently use the first 50 rows; add aggregation and Top N #1158 fix: bar/line silently use the first 50 rows; aggregation and Top N
• fix(charts): pie without legend, colours repeat, fixed radius #1160 fix: pie without legend, colours repeat, fixed radius
• ui(charts): themed tooltips, number formatting, label overflow, titles and axis names #1161 themed tooltips, number formatting, label overflow, titles and axis names
• ui(results): UI kit in results toolbar, charts and groupings (segmented control, icon buttons, export, empty states) #1162 UI kit in results toolbar, charts and groupings
• feat(charts): time axis for line charts #1159 time axis for line charts

Shared and other diagrams

• feat(export): one light / current-theme option for chart and ERD images #1163 one light / current-theme option for chart and ERD images
• feat(explain): visual query plan (Plan | Text) for PostgreSQL, MySQL, SQLite #1164 visual query plan (Plan | Text)
• feat(stats): sparklines for polled metrics on Overview dashboards #1165 sparklines on Overview dashboards

Performance and catalog correctness (performance review, Oct 2026)

• fix(erd): PostgreSQL catalog misses keys for non-owner roles, composite FKs give wrong edges; read pg_catalog #1167 fix (P1): PostgreSQL catalog misses keys for non-owner roles, composite FKs give wrong edges; read pg_catalog
• perf(erd): router rebuilds the obstacle grid and re-routes every edge on each drag move #1168 perf: router rebuilds the obstacle grid and re-routes every edge on each drag move
• perf(erd): hover rebuilds and repaints the whole canvas; no viewport culling; first layout on the UI thread #1169 perf: hover rebuilds the whole canvas, no viewport culling, first layout on the UI thread
• perf(results): charts and groupings parse and aggregate all rows on the UI thread on every rebuild #1170 perf: charts and groupings parse and aggregate all rows on the UI thread

Order

P1 first: #1167, #1152, #1158. #1168 before the drag-heavy work in #1154 / #1155. Then #1157 + #1162 (UI kit), #1154, #1160, #1161. The rest after.

Related

#1151 (SQL workspace toolbar, run modes, Relations view in the table browser).