Download In2Sql for free. Excel ODBC SQL Manager. External Connection Editor.  This tool helps to SQL analytic create an Excel report based on ODBC data. 1)  You can create table base on data from a relational database  
2) You can create a pivot report using the same external connection  
3) Some ad-hoc toll available - like "keep only" and "remove only"
4)  for the largest dataset you can setup row limit  
5) Also here you can manage ODBC connection  
6)  you can use auto build SQL query if different tables match by column name

dbForge Studio for MySQL - графический клиент для редактирования и управления MySQL и MariaDB. Бесплатный MySQL менеджер для некоммерческого использования!