This 100% works. Ignore the replies worried about slop or "scale".
(I have access to more data/examples and "at scale" databases than most anyone. It works.)
Hook up mcp in your code base, get data, fix queries, loop.
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
