Sequel Pro HotKey Cheatsheet

Post Views: 676

Sequel Pro is a popular MySQL database management tool for macOS, known for its user-friendly interface and efficiency. Mastering its shortcut keys can significantly enhance your productivity by speeding up database management tasks.

Sequel Pro macOS Shortcut Keys

Main Tabs

ShortcutAction
Cmd1Table Structure
Cmd2Table Content
Cmd3Table Relations
Cmd4Table Info
Cmd5Custom Query
Cmd6Table Triggers

General Shortcuts

ShortcutAction
CmdNNew window (connection file)
CmdTNew tab (connection file)
CmdShiftAAdd connection to favorites
CmdOOpen (connection file or SQL file)
CmdOptOOpen current connection file in new window
CmdSSave (connection file)
CmdShiftSSave as (connection file)
CmdCtrlSSave query
CmdWClose (connection file)
CmdOptWClose all (connection file)
CmdPPrint
CmdShiftIImport
CmdShiftKShow console window
CmdKClear console
CtrlOptLeftBack in history
CtrlOptRightForward in history
CtrlTabSelect next tab
CtrlShiftTabSelect previous tab
CtrlShiftNInsert NULL value
CmdShiftCCopy create table syntax
CmdOptSShow create table syntax
CmdShiftRRefresh databases
CmdShiftDChoose database
CmdShiftVShow server variables
CmdOptPShow server processes
CmdCtrlRRefresh tables
CmdShiftFFlush privileges
CmdUUser accounts...
CmdCCopy selection or selected row(s)
CmdOptCCopy selected row(s) with column names
CmdOptCtrlCCopy selected row(s) as SQL INSERT
CmdShiftTShow/hide toolbar
CmdCtrlFFilter table content
CmdOptCtrlFFilter tables
CmdOptCtrlBBundle editor
CmdOptCtrlNNavigator

Select

ShortcutAction
CtrlWSelect current word
CtrlLSelect current line
CmdShiftBSelect enclosing brackets
CmdASelect all

Table Structure Tab

ShortcutAction
CmdOptAAdd a new field
DelDelete selected field
CmdDDuplicate selected field
CmdRRefresh table structure
Cmd4Edit table details

Table Content Tab

ShortcutAction
CmdOptAAdd a new row
DelDelete selected row(s)
CmdDDuplicate selected row
CmdRRefresh table contents

Custom Query Tab

ShortcutAction
CmdOptRRun all queries (1.0+) / Run current query or selection (<=0.9.9.1)
CmdRRun 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
CmdOpt/Toggle comment current query
F5Spell checker completion (narrow-down list)
CtrlYSelect current query
CtrlHShow MySQL help for current word or selection
CmdOptFOpen query favorites popup menu
CmdOptYOpen query history popup menu
CtrlUpInsert previous history item (successively)
CtrlDownInsert next history item (successively)
CmdOpt1Show all database names as completion list
CmdOpt2Show all table and view names as completion list
CmdOpt3Show all table names from current database as completion list

Download Sequel Pro MacOS Shortcut Keys Cheatsheet PDF

We provide a Sequel Pro macOS Shortcut Keys PDF download feature. Click the download button to get the file. Please note that generating the PDF may take some time, so please be patient. Download

About Sequel Pro

Sequel Pro is an open-source database management tool that supports MySQL and MariaDB. Designed for macOS, it provides developers and database administrators with a streamlined interface to manage databases effectively.

Sequel Pro Official Information

Sequel Pro Shortcut Keys FAQ

  1. How do I create a new database in Sequel Pro?
    Use the Cmd+N shortcut to open a new connection, then use the GUI to create a database.

  2. What shortcut executes a query?
    Press Cmd+Return to execute the current query.

  3. Can I undo an action in Sequel Pro?
    Yes, press Cmd+Z to undo and Cmd+Shift+Z to redo.

  4. How do I switch between tabs?
    Use Cmd+T to open a new tab or click on the tabs to navigate.

  5. What is the shortcut to toggle full-screen mode?
    Press Cmd+Shift+F.

  6. How do I delete a row using a shortcut?
    Select the row and press Cmd+Delete.

  7. Can I save query results using a shortcut?
    Yes, you can copy the query result using Cmd+Option+C.

  8. Is there a shortcut for editing data?
    Press Cmd+E to edit the selected row.

  9. How do I close Sequel Pro quickly?
    Use Cmd+Q to quit the application.

Conclusion

Learning Sequel Pro shortcut keys is a great way to enhance efficiency and streamline your database management tasks. Whether you are navigating tables, editing rows, or running queries, these shortcuts will save you time and effort. Explore the full list, try them out, and take your productivity to the next level!

4.5/5 - (2 votes)

Database Management,MacOS