A really great loop idea is:
- Database alerts you there's a slow query (@PlanetScale does this)
- Opens an issue in your codebase
- Immediately schedules a PR from an implementer
- Reviewer agent reviews the PR
- Pings the human for review
Repeat ad nauseum until app is fast