I have been using SQL for more than 10 years, including SQL Server, DB2, Teradata and MySQL. And my experience with MySQL in general are just good enough to handle basic. I started using Sequel Pro few weeks back when I joined a new company where MySQL is the main database, and SSL is required. There are not many free options as for SSL-support under Mac, and fortunately I found Sequel Pro.
I like how Sequel Pro is powerful comparing with the many other free tools, and here are what I like most:
1. Very straightforward interface, way better than many other tools. So you are even required to read the tutorial to get most functions you need.
2. Functionalities are very much enough, you can browser tables, check sample data, schema, and relations, all in one click.
3. Most of the time works perfect, and it seems to have cache ability that when you run a code again you will retrieve cache, but I have not yet confirmed.
There are still some areas that requires improvement.
1. It's not quite stable, and often you will see the app crashes. If you cancel a running query, sometimes, it takes minutes or even much longer.
2. The interface is being too simple that not everything can be found easily, i.e. run the current code (where the cursor is) vs. run the whole code in the editor. Or how to download the result (I actually didn't find how to copy the result, but have to use export to a CSV file).
3. There is query history, but seems not result history, or maybe I didn't find it.