Comments - MAC database administration
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
There are numerous Mac OS clients for MySQL, all of which work for MariaDB, although you generally have to use SQL statements to use MariaDB features like virtual columns, etc.
First off, if you run a web server, you can use phpMyAdmin, which is nice because it will work on any platform that has a web browser. It has some quirks and has gotten slower over the years, so I don't use it very much now.
My favourite is Sequel Pro (http://www.sequelpro.com). It's free. I wish it could identify foreign keys with a tooltip, like phpMyAdmin does, but it at least gives you a link, so you're one click away.
Another one I like is Querious. (http://www.araelium.com/querious/) I would use it more often but for a silly reason: i can't remember its name! I think it costs something, but not very much. It has a nice boxes-and-lines graphical schema view that Sequel Pro lacks.
I also have downloaded other tools from the Apple Store, such as Toad, Metabase, LamaFree, and more. Most of them, I fire up, play with for a bit, then go back to my favourites above.
Hope this is helpful!
In the time since this answer was written, Sequel Pro has been mostly abandoned and crashes a lot :-(.
Some open source replacements: