Sequel Pro

Keyboard Shortcuts

Main Tabs

Shortcut	Action
Cmd 1	Table Structure
Cmd 2	Table Content
Cmd 3	Table Relations
Cmd 4	Table Info
Cmd 5	Custom Query
Cmd 6	Table Triggers

{.shortcuts}

General Shortcuts {.row-span-4}

Shortcut	Action
Cmd N	New window (connection file)
Cmd T	New tab (connection file)
Cmd Shift A	Add connection to favorites
Cmd O	Open (connection file or SQL file)
Cmd Opt O	Open current connection file in new window
Cmd S	Save (connection file)
Cmd Shift S	Save as (connection file)
Cmd Ctrl S	Save query
Cmd W	Close (connection file)
Cmd Opt W	Close all (connection file)
Cmd P	Print
Cmd Shift I	Import
Cmd Shift K	Show console window
Cmd K	Clear console
Ctrl Opt Left	Back in history
Ctrl Opt Right	Forward in history
Ctrl Tab	Select next tab
Ctrl Shift Tab	Select previous tab
Ctrl Shift N	Insert NULL value
Cmd Shift C	Copy create table syntax
Cmd Opt S	Show create table syntax
Cmd Shift R	Refresh databases
Cmd Shift D	Choose database
Cmd Shift V	Show server variables
Cmd Opt P	Show server processes
Cmd Ctrl R	Refresh tables
Cmd Shift F	Flush privileges
Cmd U	User accounts…
Cmd C	Copy selection or selected row(s)
Cmd Opt C	Copy selected row(s) with column names
Cmd Opt Ctrl C	Copy selected row(s) as SQL INSERT
Cmd Shift T	Show/hide toolbar
Cmd Ctrl F	Filter table content
Cmd Opt Ctrl F	Filter tables
Cmd Opt Ctrl B	Bundle editor
Cmd Opt Ctrl N	Navigator

{.shortcuts}

Select

Shortcut	Action
Ctrl W	Select current word
Ctrl L	Select current line
Cmd Shift B	Select enclosing brackets
Cmd A	Select all

{.shortcuts}

Table Structure Tab

Shortcut	Action
Cmd Opt A	Add a new field
Del	Delete selected field
Cmd D	Duplicate selected field
Cmd R	Refresh table structure
Cmd 4	Edit table details

{.shortcuts}

Table Content Tab

Shortcut	Action
Cmd Opt A	Add a new row
Del	Delete selected row(s)
Cmd D	Duplicate selected row
Cmd R	Refresh table contents

{.shortcuts}

Custom Query Tab

Shortcut	Action
Cmd Opt R	Run all queries (1.0+) / Run current query or selection (<=0.9.9.1)
Cmd R	Run current query or selection (1.0+) / Run all queries (<=0.9.9.1)
Cmd [	Shift line or selection rightwards
Cmd ]	Shift line or selection leftwards
Cmd /	Toggle comment line or selection
Cmd Opt /	Toggle comment current query
F5	Spell checker completion (narrow-down list)
Ctrl Y	Select current query
Ctrl H	Show MySQL help for current word or selection
Cmd Opt F	Open query favorites popup menu
Cmd Opt Y	Open query history popup menu
Ctrl Up	Insert previous history item (successively)
Ctrl Down	Insert next history item (successively)
Cmd Opt 1	Show all database names as completion list
Cmd Opt 2	Show all table and view names as completion list
Cmd Opt 3	Show all table names from current database as completion list

{.shortcuts}

Also see

• Keyboard shortcuts for Sequel Pro (sequelpro.com)