This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MAC database administration

I'm looking for database administration tools for MariaDB, I've used HeidiSQL on a PC and live this, but I understand it isn't available for a MAC.

Answer Answered by Jan Steinman in this comment.

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!

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.