truf-server/openspec/changes/simplify-dashboard/tasks.md

1. Authoritative Data Model

• 1.1 Add validated preset/custom UTC reporting-window helpers.
• 1.2 Add PostgreSQL-authoritative KPI, source activity, alive breakdown, queue, and runtime queries.
• 1.3 Add safe lookup normalization and bounded current-status/origin queries.

2. Single-Page Interface

• 2.1 Build the one-page lookup, KPI, breakdown, and runtime layout with clear empty/error states.
• 2.2 Replace visible legacy navigation and compatibility panels with the single-page route.
• 2.3 Disable Streamlit usage telemetry while retaining loopback supervisor authority and disabled-by-default startup.

3. Verification

• 3.1 Add focused tests for time-window validation, SQL-before-limit behavior, lookup hashing, identity search, and raw-column exclusion.
• 3.2 Run dashboard and security tests, then the broader relevant suite.
• 3.3 Launch through the supervisor and smoke-test desktop/mobile rendering, search, accurate 24-hour totals, and clean shutdown.