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
SQLPro Studio is an extremely lightweight and supportive Mac OS MySQL. I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysqlinstalldb. However when I try to connect to the.
Free Mysql Database
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.
- Navicat For Mysql Download Free; Download Navicat Premium 2020 v15.0 for Mac free standalone latest offline setup. The Navicat Premium 15.0 is a complete database management application for connecting to multiple database engines i.e. SQL Server, MariaDB, MySQL, Oracle, SQLite, and PostgreSQL.
- I like SQLGrinder. It's built using Cocoa, so it looks a lot better and feels more like an Mac OS X application than all the Java-based application mentioned here. It uses JDBC drivers to connect to Microsoft SQL Server 2005, FrontBase, MySQL, OpenBase, Oracle, PostgreSQL, and Sybase. Free trial or $59.
- Here are the 5 best MySQL GUI tools for Windows, Linux and Mac. MySQL Workbench. MySQL Workbench is one of the most popular MySQL GUI tools available for Windows, Linux and Mac. It is meant for database designers & architects, developers and administrators. MySQL Workbench is available in 3 editions – Community, Standard and Enterprise.
Mysql Client Macos Free
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
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.
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
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.
PROS
- Packed with useful tools
- ER diagrams!
- Linked query click-through
CONS
- A bit clunky for my taste
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.
PROS
- Build for Mac
- Very good interface for MySQL
CONS
- 25$
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.
PROS
- Very clear UI
- Easy to understand and use
CONS
- Crashes often, unfortunately in the latest releases
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
Comments are closed.