After transitioning to local development using MAMP, more and more I found myself diving into the WordPress database. At first it was really hairy, with the rows and rows of tabular data and intimidating strings of code. It slowly became more comfortable, but it was still a little awkward having multiple windows of PHPMyAdmin open for the transferring of the pertinent data. I sometimes felt like I was living on the edge while dropping tables, often scared I had the databases backwards and was erasing important data (this is why you should always export your databases with CLEAR filenames before doing any such operations).
Then I discovered Stor, a Mac client for accessing and editing multiple MySQL databases. I used it primarily for one very large database transfer project (involving copious search/replace), but I wasn’t completely satisfied with the interface. (I think I actually prefer the interface of PHPMyAdmin.)
I find its interface to be much more amenable than that of Stor, and it seems to be under more active development.