dexterlagan / database-master

A small, simple tool to manage a MySQL database. Includes a decent query monitor with real-time explain and kill.

Database Master

A small, simple tool to manage a MySQL database. Includes a decent query monitor with real-time explain and kill. This is the Main Window of the app :

Downloads

You can download the latest release for Windows and Linux HERE.

Features

Several practical functions are hidden in the main menu, replicated in contextual menus available in each list-box. 'Export to CSV' and 'Export to Excel' are self-explanatory. 'Export to Scribble' is a more advanced feature which exports to Racket's Scribble documentation format. Scribble is a domain-specific language used to create application and language manuals. It outputs HTML and PDF through Latex.

Here is the Configuration Dialog, where you input your database settings :

On the Preferences Dialog, one can specify which table prefixes to ignore to hide them from the left-hand table list :

This is the Query Tester window, that let you input queries and execute them. The results are displayed as table below :

The same window sports 'Explain' and 'Extended Explain' buttons, which displays information about a query. Useful to troubleshoot and tune query performance :

Here is the Query Builder window, used to generate queries visually :

Finally, the Query Monitor is an advanced tool which displays queries being executed on the server in real-time. The delay between list refreshes can be adjusted from 'Never' to 30 seconds. There are several fonctions available via context menus, such as 'Explain', which opens the selected query in the Query Tester window, and explains it, or 'Kill', which cancels the query thread - useful to kill queries taking too long.

Other Features

• contextual export function to Excel and CSV;
• automatic, context-aware column size adjustment (i.e. comment columns are larger);
• fast, efficient binaries with small memory footprint;
• query monitor long query log with executation time and 'explain' function;
• optionnal side-panel list-view on the Main Window activated on double-click.

Version History

• v1.0 build 538
  • added SQL query formatting function to Query Tester dialog.
• v1.0 build 537
  • no longer displays an error when attempting to enter the name of a new server.
• v1.0 build 536
  • added support for deleting servers in the configuration dialog.
• v1.0 build 534
  • added new installer based on InnoSetup v6.x;
  • added full support for loading/saving an unlimited number of MySQL servers;
  • removed obsolete 'test' database server switch;
  • added official support for Dark Mode;
  • added support for Hi-DPi;
  • switched to Windows 64 bits as default platform.
• v1.0 build 533
  • preferences dialog is now known as 'Display Exclusions', updated main menu bar;
  • refactored window centering code and made it part of a common module.
• v1.0 build 532
  • improved query monitor;
  • started work on support for multiple databases.
• v1.0 build 531
  • added support for hiding ghost processes in Query Monitor.
• v1.0 build 530
  • added support for automatic refresh to the Query Monitor.

License

Database Master is free software; see LICENSE for more details.