MySQL Workbench runs on Windows and Linux. The commercial version will let you reverse engineer and edit the stucture of a live database, with the free one you have first to dump the structure to a file. Its ancestor DBDesigner is a bit older, but doesn't have this limitation. Windows and Linux too.
If these two are overkill you may try with HeidiSQL, the descendant of MySQLFront. It runs on Windows only, but there is an alpha version running on Java.
Here are a few MySQL Data Visualization Tools which are used by the MySQL DBA for data analytics in order to boost the overall performance:
Tableau is a widely used data visualization tool which has been very much compatible with the RDBMS. It is synonymous to Business Intelligence, helping the enterprises in data mining and analysis. Tableau helps MySQL DBA to diligently analyze the database operational performance in real time. With an array of different visualization figures, Tableau is a versatile MySQL Data Visualization Tool.
Chartio enables the MySQL DBA with SQL and interactive query modes which could be leveraged for advanced data analytics. Helping its users with quick access, data visualization, Chartio offers an intuitive interactive interface to aid with insights for analytics.
MySQL Workbench offers an integrated visual tool helping the MySQL DBAs with visual data comprehension, aiding in improving the database performance with analytics. With its backup and recovery, MySQL Workbench helps the MySQL DBA to access history and make quick backups.
It assists the DBAs with the audit reports and data logs to understand the performance lags and work on them to optimize database performance.
Mode helps with exploring and visualizing the MySQL Database with its quick and powerful insights. It ensures analytical consistency throughout making it reliable. It is fast to access and visualize data with Mode MySQL visualization tool. You can easily look at the data visualizations and build reports and insights to ensure a better performance.
Using SQL query, Ubiq user can easily get the data visualization and MySQL data reporting in real time. This is very helpful especially for the MySQL DBA to enhance the RDBMS performance with advanced data analytics.
Ubiq supports local, remote and cloud data, thereby providing more data access to the user. It has features such as filters and functions which can help in getting improved analytics helping MySQL DBA in performance tuning of the database.
