Reporting tools
MySQL users would be familiar with the Export ResultSet option whereby one could generate HTML or Excel format based reports of a table or a query result. Similarly, Toad provides with a feature with which reports can be designed and generated for any schema, table or a query result. Schema Report Generator allows generation of HTML reports of selected databases and objects, including the source code for each object and links that display details for the object when selected. The report generator can be invoked directly by right clicking on any database object and selecting Generate Report option, which will initiate the report generator wizard that will ask for what database objects one needs in the report and in what type of layout. Similarly, Data Report Designer allows you to design and distribute live reports that can be used by users to run and view the latest data.

Use the Scripts tab to get the SQL code for that object and Data tab for editing the data for a table	Schema Compare shows which database objects differ and highlights those differences

Customize the report sheet with various controls and properties settings for each control using Data Report Designer	SQL Modeler lets you create framework for a query and view its immediate output; it also lets you rectify errors

Advanced features
Toad provides some advanced database administration tools like Schema Compare, Data Compare, Session Monitor, and Group Execute. Schema Compare lets us compare and synchronize database objects of two schemas. Similarly, Data Compare will let you compare data from indexed tables with the same schema on different databases (for example, you can compare the Employee table on the Production database with the Employee table on the Test database). Group Execute option can be used to execute one or more scripts in the active Editor window against multiple servers or multiple instances on a server. Whereas Session Monitor is a utility that can be used to view real-time information, including the total active and cached threads in your MySQL session.

Toad for MySQL has many other features that are useful for day-to-day tasks of database development and administration. One such feature is 'Explain Plan' which displays the steps a database uses to execute an SQL statement. The results of the Explain Plan show the order the database uses to search or join tables, and the names of indexes used. You can also import and export the scripts for SQL through an easy to use wizard. Another helpful feature is Knowledge Xpert, which provides helpful background information, best practices, and examples needed to write optimized code for your database. The Auto-Commit function, if enabled, will automatically commit the changes done to a database object. The Rollback function can also be used to revert the committed changes. With version 3 of Toad for MySQL scheduled for release this July, expect more enhanced features and functionalities.

Conclusion
Toad is a a powerful feature-rich GUI based tool for database developers and DBAs that provides them with convenient and productive utilities for MySQL database.