Getting Started
SequelPG is a native macOS application for browsing and querying PostgreSQL databases. Download it from the download page or build from source.
Once installed, launch the app and create a new connection to your PostgreSQL server. You can manage multiple connections from the sidebar.
Connections
To connect to a database, click the + button in the Connections sidebar. Fill in the following fields:
| Field | Description |
|---|---|
| Host | The hostname or IP address of your PostgreSQL server |
| Port | The port number (default: 5432) |
| Database | The name of the database to connect to |
| Username | Your PostgreSQL username |
| Password | Your PostgreSQL password |
| SSL Mode | SSL connection mode (Disable, Allow, Prefer, Require, etc.) |
Click Test to verify the connection, then Connect to open the database.
Structure View
The Structure tab displays the schema of the selected table. You can see column names, data types, nullable status, and default values at a glance.
Select a table from the sidebar Navigator to view its structure. The Inspector panel on the right shows additional metadata about the selected table.
Content View
The Content tab shows the actual rows stored in a table. Rows are displayed in a scrollable data grid with pagination controls.
Click on any row to view its details in the Inspector panel. You can see field-level data, raw values, and metadata for each record.
Query View
The Query tab provides a built-in SQL editor. Write your SQL statement and press Cmd+Enter (or click Run) to execute it.
Results appear below the editor. You can also use the Stop button to cancel a running query and Clear to reset the editor.
Inspector Panel
The Inspector panel appears on the right side of the interface. It provides context-sensitive details about the currently selected object.
When a table is selected, the Inspector shows the object name, approximate row count, and column count. When a row is selected in Content view, it shows the full row detail with all field values.