At least for me, I have a couple dozen years of DB experience but robot, given performance metrics, can get really close to optimal on a tactical level (single query or pattern of queries) but can't yet do the full normalize/denormalize level of improvements without supervision. But really solid if you have one misbehaving query and give it explain analyze access on a read only account

It has read only access, so it’s able to check query statistics, find slow queries, then run EXPLAIN ANALYZE to find the root cause and either tweak the query or suggest indexes. A lot of it is low hanging fruit, I just haven’t put in the time to fix it (startup).