ola.hallengren - Alternative MySQL scripts!
You might like to visit https://github.com/shlomi-noach/awesome-mysql which is a list of recommended community tools for MySQL.
Specifically the kind of tools you want may be:

common_schema - DBA's framework for MySQL, providing a function library, views library and QueryScript interpreter.
sys - A collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage.
Percona Toolkit - a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually.
openark kit - a set of utilities that solve everyday maintenance tasks, which may be complicated or time consuming to do by hand, written in Python.