Shanxi Computer Training/lists several useful database management tools (some of which are not open source or free) for developers' reference: 1, MySQL management tool phpMyAdminphpMyAdmin is a very popular MySQL database management tool based on web.
It can create and delete databases, create/delete/modify tables, delete/edit/add fields, and execute SQL scripts.
Disadvantages: SQL syntax is not highlighted. 2. Database management tool NavicatLiteNavicat is a fast, reliable and reasonable database management tool, which can be used to simplify database management and reduce system management costs.
Its design meets the needs of database administrators, developers and small and medium-sized enterprises.
Navicat has an intuitive user graphical interface, which allows you to create, organize, access and use information in a safe and simple way.
The databases supported by Navicat include MySQL, Oracle, SQLite, PostgreSQL and SQLServer.
Navicat offers a commercial version of NavicatPremium and a free version of NavicatLite.
However, the lite version is no longer available in Navicat.
Disadvantages: the free version has stopped updating.
3. DBeaverDBeaver is a general database management tool and SQL client, which supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby and other JDBC-compatible databases.
DBeaver provides a graphical interface for viewing database structure, executing SQL queries and scripts, browsing and exporting data, processing BLOB/CLOB data, modifying database structure and so on.
4.Mysqlworkbench is a MySQL database modeling tool and a visual database design and management tool for database architects and developers. It is the successor of the famous database design tool DBDesigner4.
You can use MySQLWorkbench to design and create new database diagrams and create database documents.
It has an open source version and a commercial version.
Can be used on Windows, Linux, Mac OS X.
20 16 10 became a stable tool.
Disadvantages: more complicated than phpMyAdmin.