Mastering Sequel Pro: A Complete Guide to Managing MySQL Databases

What is Sequel Pro?

Sequel Pro is a lightweight graphical client for MySQL that offers a clean and easy‑to‑use interface for browsing and managing databases.

Connecting to a MySQL server

The client supports three connection methods – Standard, Socket and SSH. In the typical Standard mode you must provide the following fields:

Name : a label you choose for the connection.

Username : MySQL user name, often “root”.

Host : the server’s IP address.

Password : the account password.

Database (optional): the default database to open.

Port : MySQL port, 3306 by default unless changed.

After filling the form three buttons appear:

Add to Favorites : saves the connection in the left‑hand Favorites pane.

Save changes : updates an existing connection.

Test Connection : verifies the credentials before opening the session.

Main interface

Once the connection succeeds, Sequel Pro shows a window divided into several panels:

Select a database.

View table structures.

Browse table contents.

Inspect relationships between two tables.

Access Triggers (advanced feature).

Table Info – size, primary key, etc.

Query editor – write and run SQL statements or stored procedures.

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