When it comes to databases, MySQL is a big player and widely used. Today we'll be looking at some MySQL clients we can use on Mac to view these databases.
TL;DR: My personal favorite for Mac is TablePlus. It offers a free variant which is sufficient enough.
TablePlus is the MySQL client I'm using currently. I'm still on the free plan, which only allows you to have two tabs open at a time, which is enough for me.
- Clear interface
- Quickly edit multiple rows at once
- RAW query always visible
- Only two tabs on the free version
- No click-through for linked queries
phpMyAdmin is another excellent resource to view your MySQL databases. It's a very good one since most servers will come with phpMyAdmin installed. Making it a good universal interface.
- Close to your server interface for MySQL
- Easy to install
- No syntax highlighting
- Import/Export is web-dependent, making them influenced by the server settings
DBeaver is a free and open-source database tool. It's built around usability.
This tool is complete and has many cool features. For me, however, it feels a bit too much.
- Packed with useful tools
- ER diagrams!
- Linked query click-through
- A bit clunky for my taste
Very Mac like interface and clear to understand how it works and what it does. I really like the tool however, it should have been a free tool.
- Build for Mac
- Very good interface for MySQL
5 Sequel Pro
Sequel Pro used to be my favorite MySQL client for Mac, however, they seem to have a fair amount of crashes lately. The reason I switched to TablePlus.
The tool itself is one of the best UI's for MySQL I've personally seen.
- Very clear UI
- Easy to understand and use
- Crashes often, unfortunately in the latest releases