A question that is asked in every enterprise developer training is, what are the useful clients for MySQL operation? As a MySQL practitioner and software lover for many years, I would like to recommend 6 clients in three dimensions, all of which are personally tested and used by the author:

  1. Fee category (2 items)

  2. Command line classes (2)

  3. Rising Star (2 Free)

First, let’s talk about charging clients:

1.  Navicat

Website: navicat.com

Latest version: Navicat 15

Applicable platforms: Windows, MacOS, Linux, etc

Navicat is very easy for developers to use and is very convenient for CRUD class management. But debugging stored procedures may not be his strong suit. This tool is also very popular among developers.

2. SQLyog

Website: webyog.com

Latest version: SQLyog 13.1.8

Platform: Windows

SQLyog is one of the GUI tools I’ve been using for the Windows platform for the longest time, mostly to write stored procedures. The Ssh and HTTP channels feature of this tool is awesome. If you’re looking for a MySQL GUI tool on A Windows platform and you’re a developer, SQLyog is worth it to you.

These two tools are very good, if only do simple Schema management,CRUD operations, basically can meet. SQLyog is recommended if stored procedure development is required

Let’s look at the command line tool again:

1. mysql

Official tools, which I use a lot in my work, are recommended for professional DBAs to use skillfully. Not recommended for developers.

2. mycli

Website: www.mycli.net

Use python implementation of a command line management tool, with its own completion function.

This tool is pushed to do the operation and maintenance platform of the students, can be based on this command line tool developed very many meaningful tools. It is suggested that students who do automation platform can learn to read the implementation of this tool.

Finally, I recommend two up-and-comers:

If the above tools are great, you’ll never know, but open source tools are even better. For the last six years or so, I have been using MySQL GUI tools, managing CURD in main scenes, tuning complex SQL, Schema planning and other work. These tools used to be powered by PowerDesinger. Now there are tools in the open source ecosystem to do it. There are also two tools I recommend.

1.  MySQL Workbench

Liverpoolfc.tv: dev.mysql.com/downloads/w…

Latest version: 8.0.25

Supported platforms: Windows, MacOS, Linux

The official GUI tool is the closest to the MySQL version. At the same time, for stored procedures, the ER diagram design of Schema is very friendly. Because it is a special tool customized for MySQL, it also includes some monitoring report support for MySQL. MacOS support is also great. This tool is well worth having if you mostly use MySQL.

**  2.  DBeaver**

Liverpoolfc.tv: dbeaver. IO

Open source: github.com/dbeaver/dbe… More than 20,000 Star projects

Latest version: 21.0.5

Supported platforms: Windows, MacOS, Linux, and even IDE plugins such as Eclipse

The open source version basically supports all relational databases and is the most comprehensive SQL IDE TOOL I’ve seen, most recently with Clickhouse.

There are a lot of MySQL client tools out there. MySQL Workbench, DBeaver is a great product for later projects. If you haven’t found the right one yet, consider choosing one of these two tools.

The author also never thought well, now do not charge for the tool to use down experience, use all aspects are very good, belongs to the good product, personal use push the best use of tools: MySQL Workbench and DBeaver, two tools that have won the ecosystem for free, and the DBeaver code is also open source, which is a good base if you need custom tools within the company. From a database ecosystem perspective, almost all relational databases can support it. All databases can be managed with one tool in hand.

Today give you a change of taste of the article, try a developer-oriented article, I hope to help you.

This article uses the article synchronization assistant to synchronize