TLDR version - local mysql server, local apache server w/ php support, and phpmyadmin
If you have your existing queries, and a sample dataset that hits all the combos, you could load it all up in phpMyAdmin and work with it in-browser. View or create relationships, run queries, edit/delete/insert data, etc. Save queries, export data, all sorts of good stuff.
Either set up MAMP, or do it in a VM via VirtualBox using a quick LAMP set up. Personally, I recommend doing it on LAMP, with a nice GUI desktop
- Download and install VirtualBox for Mac
- Download a Linux Mint MATE edition 64bit installer ISO
- Create a new VM, give it sufficient disk space dynamically allocated - it won't use the disk space until it has data to store on it.
- Click through the installer for Mint, just take the defaults
On first boot, open a terminal and run
sudo apt-get update
sudo apt-get dist-upgrade
After updates are done, reboot the VM. Log back in, open a terminal, and run
sudo apt-get install apache2 libapache2-mod-php7.0 php7.0-mcrypt php7.0-mysql phpmyadmin
The VM will download and install all required packages, prompting you for some info along the way (mysql admin password to create, which webserver -apache2 - you want to configure for phpmyadmin, etc). Almost always the default choice is a correct one.
After it is all done installing, open a browser (firefox is installed by default, or you can manually install chrome/chromium) and go to http://localhost/phpmyadmin . Log in with the root username and whatever password you created during install, and there you are.