Hindsight Maintenance

Keep the self-hosted Hindsight memory system healthy across every bank on a schedule. The expensive, dangerous, and repetitive parts — bank enumeration, the health sweep, the orphaned-job reaper, the new-memory watermark — are pre-paid in scripts/. Spend agent judgment only on the creative optimization passes (pollination, synthesis, prune review), never on re-deriving the CLI or SQL surface.

Endpoint https://api.hs.delo.sh. The database is host-native Postgres at 127.0.0.1:5432, database hindsight, schema hindsight (not public) — this custom schema is the root of two upstream bugs the tune-up workflow guards against. Stack and DB repair SQL live in ~/docker/stacks/ai/hindsight/ (compose.yml, .env, fixes/).

Operating Principles