Aireforge Advisor
Advisor analyses a SQL Server instance, its databases, tables and indexes, and reports issues against a library of checks covering performance, security, reliability, data integrity and operational excellence. Each finding explains what was found and, where there's a fix, gives you the SQL to review and run yourself.
Advisor needs a live connection to the instance: it runs its checks as real queries against the server each time, rather than working from previously collected data. It only ever recommends. There is no button anywhere in Advisor that changes anything on your server.
Advisor is not available on the Free tier.