MySQL Workbench Beautifier

MySQL Workbench Beautifier is an AutoHotkey (AHK) script with rich SQL reserved keywords designed to enhance the SQL authoring experience within MySQL Workbench by automating the capitalization of SQL keywords in real-time. It aims to promote consistent query styling and reduce manual formatting efforts for developers.

Overview

This script integrates seamless SQL keyword formatting directly into MySQL Workbench, ensuring immediate adherence to coding standards without disrupting workflow. By automatically converting SQL keywords to uppercase as you type, it enhances query readability and minimises the need for post-authoring clean-up.

Key Features

• Real-Time Keyword Formatting: Automatically capitalises recognised SQL keywords as you type, maintaining consistent query style.
• Non-Intrusive Operation: Operates within MySQL Workbench without altering the application itself.
• Customisable Keyword List: Allows updating of SQL reserved keywords to suit specific project requirements.
• Auto Bind: Option to initiate the script on system startup for continuous usage convenience.

Usage

1. Download and Installation:

• Download the installer MySQLWorkbenchBeautifier-Setup.exe.
• Ensure MySQL Workbench is installed and running.

2. Running the Script:

• Simply run the windows installer MySQLWorkbenchBeautifier-Setup.exe.
• Launch the application.
• Make sure the script is running. (The easiest way to look is into the system tray)
• Start writing SQL queries in MySQL Workbench with enhanced keyword formatting.

3. Auto Bind (Optional):

• To automatically launch the script on system startup:
• Press Win + R, type shell:startup, and press Enter.
• Copy the MySQL Workbench Beautifier shortcut file in the program start-up folder.

Compatibility

• Platform: Windows
• MySQL Workbench Version: Tested with MySQL Workbench Community Edition

License

MySQL Workbench Beautifier is licensed under the MIT License, allowing for modification and distribution while maintaining attribution.