Top 5 MySQL clients for Mac

— 3 minute read

permalink

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.

1 TablePlus permalink

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.

TablePlus MySQL client for Mac

PROS

  • Clear interface
  • Quickly edit multiple rows at once
  • RAW query always visible

CONS

  • Only two tabs on the free version
  • No click-through for linked queries

Download TablePlus

2 phpMyAdmin permalink

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.

phpMyAdmin MySQL client for Mac

PROS

  • Close to your server interface for MySQL
  • Easy to install
  • Web-based

CONS

  • No syntax highlighting
  • Import/Export is web-dependent, making them influenced by the server settings

Download phpMyAdmin

3 DBeaver permalink

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.

DBeaver MySQL client for Mac

PROS

  • Packed with useful tools
  • ER diagrams!
  • Linked query click-through

CONS

  • A bit clunky for my taste

Download DBeaver

4 Querious permalink

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.

Querious MySQL client for Mac

PROS

  • Build for Mac
  • Very good interface for MySQL

CONS

  • 25$

Download Querious

5 Sequel Pro permalink

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.

Sequel Pro MySQL client for Mac

PROS

  • Very clear UI
  • Easy to understand and use

CONS

  • Crashes often, unfortunately in the latest releases

Download Sequel Pro

Thank you for reading, and let's connect! permalink

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter