This tool allows you to run EXPLAIN on Toolforge queries, and will suggest improvements if common issues are detected.
Resources: Database access • Help:MySQL queries • Run query online