CheatSheetsHero

Browse / Sequel App Cheatsheet (Sequel Pro/Ace)

April 24, 2025 23:46
MySQL
database
postgresql
sequelace
sequelpro
Download PDF
Missing something?

Sequel App Cheatsheet (Sequel Pro/Ace)

A quick reference guide to common keyboard shortcuts, querying, data management, and schema operations in the Sequel database GUI application.

General & Navigation

File & Window Management

Cmd + N

New Window

Cmd + W

Close Window/Tab

Cmd + T

New Tab

Cmd + Shift + T

Reopen Last Closed Tab

Cmd + Opt + Left/Right

Navigate between Tabs

Cmd + P

Show Connection Manager

Cmd + L

Open Location (Direct connection)

Cmd + Shift + N

New Database Connection

Interface Navigation

Cmd + 1

Switch to Structure Tab

Cmd + 2

Switch to Content Tab

Cmd + 3

Switch to Relations Tab

Cmd + 4

Switch to Info Tab

Cmd + 5

Switch to Trigger Tab

Cmd + 6

Switch to Query Tab

Esc

Focus Table/Database List

Enter (on table)

Switch to Content Tab for selected table

Cmd + F

Find (in current tab)

Querying & Data

Query Editor Actions

Cmd + R

Run Query (or selected text)

Shift + Cmd + R

Run Current Query Statement (ends with ;)

Opt + Cmd + R

Run Query in New Tab

Cmd + /

Toggle Comment Line

Ctrl + Space

Show Auto-Completion

Shift + Cmd + F

Format Query

Cmd + K

Clear Console Output

Cmd + S

Save Query as File

Content Tab & Data Editing

Cmd + N

Add New Row

Cmd + Delete

Delete Selected Row(s)

Cmd + E

Edit Selected Cell

Enter (on cell)

Edit Cell (unless it’s multiline text)

Shift + Enter (on cell)

Open Large Text Editor for Cell

Cmd + S

Save Changes (in Content tab)

Cmd + R

Refresh Data (in Content tab)

Double-click column header

Sort by Column

Schema & Structure

Database & Table Actions

Cmd + Shift + D

Add New Database

Cmd + N (in Structure tab)

Add New Table

Cmd + Shift + T

Duplicate Table

Cmd + Delete (on table/db)

Delete Table/Database

Cmd + I

Show Info (for selected item)

Cmd + R

Refresh Schema/Table List

Cmd + Shift + R

Flush Privileges

Opt + Cmd + L

Generate SELECT Query for Table

Column & Index Actions

Cmd + N (in Structure tab, columns list)

Add New Column

Cmd + Delete (on column)

Delete Selected Column

Cmd + N (in Structure tab, indexes list)

Add New Index

Cmd + Delete (on index)

Delete Selected Index

Double-click cell (column/index list)

Edit Cell Value

Shift + Cmd + C

Copy CREATE TABLE statement

Cmd + I (on column)

Show Column Info

Cmd + S (in Structure tab)

Apply Structure Changes

Tips & Tricks

Useful Shortcuts

Cmd + Opt + C

Copy Selected Rows as CSV

Shift + Cmd + C

Copy INSERT statement for selected rows

Cmd + J

Jump to Table/Database (type name)

Cmd + [ / Cmd + ]

Indent/Outdent selected text (Query tab)

Opt + Click (in Query tab)

Multiple Cursors

Ctrl + T (on table name in query)

Open Table in new tab

Cmd + G

Find Next (after Cmd+F)

Shift + Cmd + G

Find Previous

Efficiency Boosters

Filtering: Use the filter bar at the top of the Content tab (Cmd+F to focus) for quick filtering without writing SQL WHERE clauses. Supports wildcards (%, _) and operators (>, <, =).
e.g., Name: John%, Age: >30

Table Info: The ‘Info’ tab (Cmd+4) provides quick summaries, status, and engine details for the selected table without running separate queries.

Custom Queries: Save frequently used queries for easy access using File > Save Query or Cmd + S in the Query tab.

Favorites: Add frequently used connections to your Favorites in the Connection Manager for one-click access.

Bundles: Explore or create Bundles (Bundles menu) for automating common tasks via scripts.

Connection Aliases: Give your connections clear aliases in the Connection Manager to distinguish them easily, especially for similar databases (e.g., ‘Prod DB’, ‘Dev DB’).

Troubleshooting & Info

View Processes: Check the ‘Processes’ tab (Cmd+7) to see running queries and kill slow ones.

Server Variables: Check the ‘Server Variables’ tab (Cmd+8) for server configuration details.

Status: The ‘Status’ tab (Cmd+9) shows server status and statistics.

Console: The console at the bottom of the Query tab shows query execution time and errors.

Slow Queries: Configure your database server to log slow queries, and use the Sequel app to analyze them (often found under specific status/variable settings).