Same here, this seems like a setup issue.

If you give the LLM the ability to run queries against prod-like data and review the paths, you have a fully autonomous system that can correctly optimize your ORM/queries. Been doing this for months.

pgAnalyze is a great complementary tool for this and they offer MCP