Web-based Visual Query Designer

Web-based Visual Query Designer is a tool for visually generating SELECT SQL queries. Currently, it is designed only for MySQL .

Feel free to try this tool for generating simple SELECT queries for the MySQL database.

Think of it as a supplement to your MySQL front-end tool (like phpMyAdmin ).

Online demo (adapted for a static website)

Screenshots

Design queries visually

Drag-n-drop

Screencast

Youtube / Invidious

Dependencies

• apache2
• mysql server
• php7
• php mysqli extension

Installation

Extract all the files to the www folder of your web server. Open conn.php file and set the $username and $password for your MySQL database. This user (configured in conn.php) needs to have atleast READ access to information_schema.

Limitations (as of now)

• A join can be made between 2 tables only on one set of condition

• Aggregate queries and sub-queries are not yet supported

License

Web-based Visual Query Designer is an open source software released under the MIT License.

Feedback

Please let me know if you find it useful.

Swapnil Joshi

swapnil [dot] gnu [at] gmail.com