Sequel Pro: a powerful tool for working with MySQL
Makradar Technologies / / December 19, 2019
From time to time, I need a tool for working with MySQL. Of course, most of the action can also be performed in the terminal, but for most users, I think it will be much easier to run a graphical application and to correct everything you need in a jiffy.
So, what is the Sequel Pro? This is a great free utility that allows you to work efficiently with MySQL databases. Immediately after the start of the program, the user needs to configure a connection to the server that hosts this database.
Select the database can be hosted using the drop-down menu. Also, it can quite easily you can create a new database.
application main window is divided into several virtual parts, each of which is responsible for their functions. For example, by selecting an arbitrary table and going to the section «Structure», you can view its structure, change the parameters of some fields, add new or delete an existing field, as well as duplicate them. The lower half of the screen is designed to control and indexes key fields.
The second tab ( «Content») allows you to access the contents of the table with the ability to edit the field values and various filtering. Similarly, the tab buttons are provided for creating a new row in the table, its deletion or duplication.
In «Relations» tab displays the relationships between tables, and in the section «Table Info» you can see various information about selected database element: type, coding, number of lines, their physical size, SQL query syntax to create and so Further.
And for the "old school" administrators Sequel Pro is provided a window of "raw" the SQL-query input with syntax highlighting, which can be very detailed customized to your liking.
In my opinion, this is one of the best graphic tools to manage MySQL databases, moreover, is free and with source code.
Application site:Sequel Pro
Developer website:MJ Media
cost: is free
Personal rating: 5+