[MAC] Sequel Pro/Ace Keyboard Shortcuts

Keyboard Shortcuts

Get the most out of Sequel Pro by remembering the following keyboard shortcuts.

Main Tabs

Table StructureTable ContentTable RelationsTable InfoCustom QueryTable Triggers

⌘   1

⌘   2

⌘   3

⌘   4

⌘   5

⌘   6

General Shortcuts

New Window (Connection File)New Tab(Connection File)Add Connection To FavoritesOpen (Connection File or SQL File)Open current Connection File in New WindowSave (Connection File)Save As (Connection File)Save QueryClose (Connection File)Close All (Connection File)PrintImportShow Console WindowClear ConsoleBack in HistoryForward in HistorySelect Next TabSelect Previous TabInsert NULL valueCopy Create Table SyntaxShow Create Table SyntaxRefresh DatabasesChoose DatabaseShow Server VariablesShow Server ProcessesRefresh TablesFlush PrivilegesUser Accounts…Copy selection / Copy selected row(s)Copy selected row(s) with column namesCopy selected row(s) as SQL INSERTShow/Hide ToolbarFilter Table ContentFilter TablesBundle EditorNavigator

⌘   N

⌘   T

⇧   ⌘   A

⌘   O

⌥   ⌘   O

⌘   S

⇧  ⌘   S

^  ⌘   S

⌘   W

⌥   ⌘   W

⌘   P

⇧   ⌘   I

⇧   ⌘   K

⌘   K

⌃   ⌥   ←

⌃   ⌥   →

⌃   ⇥

⌃   ⇧   ⇥

⌃   ⇧   N

⇧   ⌘   C

⌥   ⌘   S

⇧   ⌘   R

⇧   ⌘   D

⇧   ⌘   V

⌥   ⌘   P

⌃   ⌘   R

⇧   ⌘   F

⌘   U

⌘   C

⌥   ⌘   C

⌃   ⌥   ⌘   C

⇧   ⌘   T

⌃   ⌘   F

⌃   ⌥   ⌘   F

⌃   ⌥   ⌘   B

⌃   ⌥   ⌘   N

Select

Select current wordSelect current lineSelect enclosing bracketsSelect all

⌃   W

⌃   L

⇧   ⌘   B

⌘   A

Table Structure Tab

Add a new fieldDelete selected fieldDuplicate selected fieldRefresh table structureEdit table details

⌥   ⌘   A

⌫

⌘   D

⌘   R

⌘   4

Table Content Tab

Add a new rowDelete selected row(s)Duplicate selected rowRefresh table contents

⌥   ⌘   A

⌫

⌘   D

⌘   R

Custom Query Tab

 

Version 1.0 and laterRun all queriesRun current query or selectionVersions 0.9.9.1 and earlierRun all queriesRun current query or selection Shift line or selection rightwardsShift line or selection leftwards(Un)Comment line or selection(Un)Comment current queryCompletion (narrow-down list / fuzzy search)    Insertion of an item    Insertion full schema reference    Keep Window Open after Insertion    Fuzzy Search    Close WindowSpell Checker Completion (narrow-down list)Select current queryShow MySQL help for current word or selectionOpen query favorites popup menuOpen query history popup menuInsert previous history item (successively)Insert next history item (successively)Show all database names as completion listShow all table and view names as completion listShow all table names from current database as completion list

⌥   ⌘   R

⌅ or ⌘   R

⌅ or ⌘   R

⌥   ⌘   R

⌘   [

⌘   ]

⌘   /

⌥   ⌘   /

⎋

↩ , ⇥ , Double-Click

⇧ + ↩ , ⇧   ⇥ , ⇧   Double-Click

holding down ⌃while insertion

⌃   ⎋

⎋

F5

⌃   Y

⌃   H

⌥   ⌘   F

⌥   ⌘   Y

⌃ +  ↑

⌃   ↓

⌥   ⌘   1

⌥   ⌘   2

⌥   ⌘   3