Mastering MySQL with Sequel Pro: A Complete Beginner's Guide

Overview of Sequel Pro

Sequel Pro is a lightweight MySQL management tool with a clean, easy‑to‑use interface.

Connecting to a MySQL Server

Sequel Pro provides three connection methods—Standard, Socket, and SSH. The guide uses the Standard method, which requires the following fields:

Name – a label for the connection.

Username – the MySQL user name (commonly “root”).

Host – the server IP address.

Password – the account password.

Database – optional default database.

Port – MySQL’s default port 3306 (or a custom port).

Connection Buttons

Add to Favorites – stores the connection in the Favorites pane for quick access.

Save Changes – updates an existing connection after editing its settings.

Test Connection – verifies that the credentials and network settings are correct before establishing a session.

Main Interface After Login

Once connected, the main window is divided into several modules:

Select Database – choose the active schema.

View Table Structure – inspect columns, indexes, and definitions.

View Table Content – browse rows of data.

View Relationships – see foreign‑key links between tables.

Triggers – (not detailed in this guide).

Table Info – summary information such as size and primary key.

Query – write and execute SQL statements or stored procedures; selected statements can be run with ⌘+R.