Sequel Pro HotKeys

Post Views: 623

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

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

General Shortcuts

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

Select

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

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

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

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

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

Posted by HotKey Guru