Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases

Sequel Pro is a lightweight, user‑friendly MySQL and MariaDB client for macOS.

It can manage both local and remote MySQL servers on macOS 10.12.

Sequel Pro offers three connection methods: Standard, Socket, and SSH. The article demonstrates the Standard mode, which requires the following fields:

Name – a label for the connection.

Username – typically "root".

Host – the server IP address.

Password – the MySQL password.

Database – optional default database.

Port – default 3306 unless changed.

After filling the fields, three buttons appear:

Add to Favorites – saves the connection in the Favorites pane.

Save Changes – updates an existing connection.

Test Connection – verifies the settings before connecting.

When the connection succeeds, the main interface is displayed.

The interface is divided into several modules:

Select Database – choose the target database.

Table Structure – view columns, indexes, and keys.

Table Content – browse rows of a table.

Relationships – visualize links between tables.

Additional panels include:

Triggers – not covered in this guide.

Table Info – shows size, primary key, and other metadata.

Query – a space to write and run SQL statements or stored procedures.

To execute a single statement, select the line and press ⌘+R.

Finally, the article encourages readers to like and share the guide as support.