How to view all tables in the current database?

In Navicat, use the shortcut keys Ctrl+T (Windows) or Command+T (Mac) to quickly view all tables in the current database.

How to quickly execute SQL queries?

Use the F5 key to quickly execute the current SQL query.

Can I customize shortcut keys?

Yes, Navicat allows users to customize shortcut keys in the settings, and users can set shortcut keys according to their own habits.

How to quickly close the current connection?

Use the shortcut keys Ctrl+W (Windows) or Command+W (Mac) to quickly close the current database connection.

Use the shortcut keys Ctrl+Shift+I (Windows) or Command+Shift+I (Mac) to import data.

Use the shortcut keys Ctrl+Shift+E (Windows) or Command+Shift+E (Mac) to export data.

How to stop query execution?

Use Ctrl+Shift+F5 (Windows) or Command+Shift+F5 (Mac) to stop the currently executing query.

How to copy the currently selected content?

Use the shortcut keys Ctrl+C (Windows) or Command+C (Mac) to copy the currently selected content.

Navicat HotKeys

2024 年 12 月 23 日2025 年 1 月 9 日

Post Views: 728

Navicat is a powerful database management tool that supports MySQL, PostgreSQL, SQLite, Oracle, MariaDB and other database systems. It not only provides a graphical interface to facilitate users to manage databases, but also supports various advanced functions such as data synchronization, backup, recovery, SQL query generation, etc. In order to improve work efficiency, Navicat provides many shortcut keys, through which users can quickly perform common operations and avoid frequent mouse clicks.

Navicat Windows shortcut keys

Charts

Shortcut keys	Function description
`F11`	Show dashboard
`F5`	Refresh data
`CTRL` + `D`	Design object
`CTRL` + `P`	Print dashboard

Models

Shortcut keys	Function description
`I`	New image
`CTRL` + `-` + `CTRL` + `Mousewheel down`	Zoom out
`L`	New layer
`R`	New foreign key/relation
`CTRL` + `B`	Show selected table, entity, view, foreign key, relationship, or shape in bold
`T`	New table/entity
`H`	Move diagram
`ESC`	Select
`CTRL` + `=` + `CTRL` + `Mousewheel up`	Zoom in
`CTRL` + `P`	Print chart
`V`	New view
`CTRL` + `D`	New chart in model
`A`	New label
`N`	New note
`CTRL` + `0`	Reset zoom

Debugger

Shortcuts	Function description
`F10`	Step over
`F9`	Run
`SHIFT` + `F11`	Step out
`F11`	Step in

SQL Creation Tool

Shortcuts	Function description
`CTRL` + `0`	Reset zoom
`CTRL` + `-`	Zoom out
`CTRL` + `=`	Zoom in

Query Editor

Shortcut keys	Function description
`CTRL` + `0`	Reset zoom
`CTRL` + `-`	Zoom out
`F3`	Find next text
`CTRL` + `/`	Comment/uncomment line
`CTRL` + `F`	Find text
`CTRL` + `SHIFT` + `V`	Paste from clipboard stack
`CTRL` + `=`	Zoom in

Query Designer

Shortcut keys	Function description
`CTRL` + `R`	Run/Run selected
`CTRL` + `E`	Switch to query editor
`ALT` + `1...9`	Switch to results tab
`CTRL` + `O`	Open external file
`CTRL` + `T`	Stop

Materialized View Designer

Shortcut Keys	Function Description
`ALT` + `1...9`	Switch to Results 1 - 9
`CTRL` + `O`	Import SQL
`CTRL` + `R`	Preview
`CTRL` + `E`	Switch to Definition

Data Viewer

Shortcut Keys	Function Description
`CTRL` + `END`	Move to the last row of the current column
`F3`	Find the next text
`CTRL` + `Q`	Query Object (Table, Collection, View, Materialized View)
`ESC`	Discard record changes
`CTRL` + `F`	Find text
`CTRL` + `DELETE`	Delete records
`SHIFT` + `ARROW`	Select cells
`CTRL` + `S`	Apply record changes
`INSERT` + `CTRL` + `N`	Add record
`CTRL` + `G`	Go to row
`CTRL` + `PAGE DOWN` + `CTRL` + `DOWN ARROW`	Move to the last row of the current page
`CTRL` + `PAGE UP` + `CTRL` + `UP ARROW`	Move to the first row of the current page
`CTRL` + `R`	Apply filter / Apply sort
`CTRL` + `ENTER`	Edit data using open editor
`CTRL` + `HOME`	Move to the first row of the current column
`CTRL` + `RIGHT ARROW`	Move to the last column of the current record
`CTRL` + `T`	Stop loading data
`CTRL` + `LEFT ARROW`	Move to the first column of the current record
`CTRL` + `D`	Design objects (tables, collections, views, materialized views)

Table/Collection Designer

Shortcut keys	Function description
`CTRL` + `O`	Open table/collection
`SHIFT` + `F3`	Find previous field
`F3`	Find next field
`CTRL` + `F`	Find field

ER Diagram View

Shortcut keys	Function description
`CTRL` + `-` + `CTRL` + `Mousewheel down`	Zoom out
`DELETE`	Delete selected foreign key
`CTRL` + `=` + `CTRL` + `Mousewheel up`	Zoom in
`CTRL` + `0`	Reset zoom
`R`	Create new foreign key
`ESC`	Select
`H`	Move diagram
`F5`	Refresh

Main Window

Shortcut Keys	Function Description
`CTRL` + `L`	History
`CTRL` + `N`	New Object
`CTRL` + `SHIFT` + `F`	Find in Database/Schema
`CTRL` + `1...9`	Open Favorites Link
`CTRL` + `G`	Open Settings Location Folder
`F6`	Console
`F12`	Show Active Object Only

Common

Shortcut Keys	Function Description
`F8`	Navicat Main Window / Object Tab
`CTRL` + `Q`	New Query
`F1`	Help
`CTRL` + `SHIFT` + `1...9`	Add to Favorites
`CTRL` + `TAB` + `SHIFT` + `CTRL` + `TAB`	Next window/tab

Navicat MacOS shortcut keys

Charts

Shortcut keys	Function description
`⌘` + `R`	Refresh data
`F11`	Show dashboard
`⌘` + `D`	Design object

Models

Shortcut keys	Function description
`⌘` + `Mousewheel ↓`	Zoom out
`V`	New view
`A`	New label
`⌘` + `0`	Reset zoom
`⌘` + `B`	Show selected table, entity, view, foreign key, relationship, or shape in bold
`H`	Move diagram
`I`	New picture
`⎋`	Select
`T`	New table/entity
`⇧` + `⌘` + `P`	Page Setup
`⌘` + `P`	Print Diagram
`L`	New Layer
`N`	New Note
`R`	New Foreign Key/Relation
`⌘` + `Mousewheel ↑`	Zoom In

Debugger

Shortcuts	Function Description
`F10`	Step Over
`F11`	Step In
`⌘` + `F11`	Step Out
`F9`	Run

Query Editor

Shortcuts	Function Description
`⌘` + `[`	Decrease Indent
`⌘` + `UP ARROW`	Go to Top of Page
`⌘` + `G`	Find Next Text
`⌘` + `+`	Zoom In
`⌘` + `/`	Toggle comment
`⇧` + `⌘` + `G`	Find previous text
`⌘` + `LEFT ARROW`	Go to the beginning of the current line
`⌘` + `F`	Find text
`⌘` + `RIGHT ARROW`	Go to the end of the current line
`⌘` + `0`	Reset zoom
`⌘`	Zoom out
`⌘` + `DOWN ARROW`	Go to the end of the page
`⌥` + `⌘` + `F`	Find and replace
`⌘` + `]`	Increase indent

Query Designer

Shortcut keys	Function description
`⇧` + `⌘` + `R`	Run current statement
`⌘` + `.`	Stop
`⌘` + `R`	Run/Run Selected

Materialized View Designer

Shortcut Keys	Function Description
`⌘` + `R`	Preview
`⌘` + `.`	Stop

Data Viewer

Shortcut Keys	Function Description
`⌘` + `F`	Find Text
`⌃` + `0`	Set to NULL
`⌃` + `⌥` + `⌘` + `F`	Filter Wizard
`⌘` + `D`	Design Object (Table, Collection, View, Materialized View)
`⌃` + `⇧` + `B`	Toggle Image Editor
`⇧` + `⌘` + `G`	Find previous text
`⌘` + `RETURN`	Apply record changes
`⌘` + `UP ARROW`	Sort ascending
`⌃` + `⇧` + `W`	Switch web editor
`⇧` + `⌘` + `Y`	Query object (table, collection)
`⌘` + `G`	Find next text
`⇧` + `⌘` + `V`	Switch view
`⌘` + `+`	Add record
`⌘` + `DOWN ARROW`	Sort descending
`⌥` + `⌘` + `F`	Find and replace
`⌃` + `⇧` + `H`	Switch hex editor
`⌘`	Delete record
`⌘` + `.`	Stop loading data
`⌘` + `⎋`	Discard record changes
`⌃` + `⇧` + `T`	Switch text editor

Table/Collection Designer

Shortcut keys	Function description
`⌘` + `O`	Open table/collection
`⌘` + `F`	Find field
`⌘` + `D`	Duplicate field
`⇧` + `⌘` + `K`	Set field as primary key
`⌘` + `+`	Add field
`⌘` + `G`	Find next field
`⇧` + `⌘` + `G`	Find previous field
`⌘` + `DOWN ARROW`	Move down
`⌘` + `-`	Delete field
`⌘` + `UP ARROW`	Raise

ER Diagram View

Shortcut Keys	Function Description
`⌘` + `0`	Reset Zoom
`⌘` + `Mousewheel ↑`	Zoom In
`⌫`	Delete Selected Foreign Key
`⎋`	Select
`⌘` + `Mousewheel ↓`	Zoom Out
`H`	Move Diagram
`R`	Create New Foreign Key

Navicat Main Window

Shortcut Keys	Function Description
`⇧` + `⌘` + `.`	Close Connection/Database/Schema
`⌘` + `1`	Show/Hide Navigation Pane
`⇧` + `⌘` + `F`	Find in Database/Schema
`⌃` + `⌘` + `F`	Full screen
`⌥` + `⌘` + `T`	Show/hide toolbar
`⇧` + `⌘` + `H`	History
`⇧` + `⌘` + `C`	Console
`⌘` + `2`	Show/hide information pane
`⇧` + `⌘` + `T`	Data transfer

Common

Shortcut keys	Function description
`OPTION` + `SHIFT` + `1...9`	Add to favorites
`⇧` + `⌘` + `D`	Duplicate object
`CONTROL` + `SHIFT` + `1...9`	Open favorites link
`⌘` + `Y`	New query
`⌘` + `R`	Refresh
`⇧` + `⌘` + `W`	Close window
`⌘` + `W`	Close tab
`⌘` + `}` + `⌘` + `{`	Select next/previous tab
`⇧` + `⌘` + `S`	Save as
`⌘` + `>` + `⌘` + `<`	Select next/previous page
`⌘` + `N`	New object
`⌘` + `D`	Design object
`⌘` + `S`	Save

About Navicat

Navicat is a database management tool developed by PremiumSoft that supports multiple database systems such as MySQL, PostgreSQL, SQLite, Oracle, etc. Navicat provides an intuitive user interface, a powerful SQL editor, and many convenient tools to help database administrators and developers manage databases efficiently.

The main features of Navicat include:

Cross-platform support: Can be used on Windows, MacOS and Linux.
Powerful data synchronization and backup functions: Supports cross-server data synchronization and backup, and can also import and export data in multiple formats.
Graphical interface: Simplifies database management tasks through visual tools.
SQL editor: Provides syntax highlighting, auto-completion and code snippets to improve development efficiency.

Navicat official website information

Official website address: https://www.navicat.com/
Download address: https://www.navicat.com/en/download
Shortcut address: https://www.navicat.com/en/products/navicat-for-mysql/keyboard-shortcuts

Navicat shortcut key FAQ

How to view all tables in the current database?
In Navicat, use the shortcut keys Ctrl+T (Windows) or Command+T (Mac) to quickly view all tables in the current database.
How to quickly execute SQL queries?
Use the F5 key to quickly execute the current SQL query.
Can I customize shortcut keys?
Yes, Navicat allows users to customize shortcut keys in the settings, and users can set shortcut keys according to their own habits.
How to quickly close the current connection?
Use the shortcut keys Ctrl+W (Windows) or Command+W (Mac) to quickly close the current database connection.
How to import data?
Use the shortcut keys Ctrl+Shift+I (Windows) or Command+Shift+I (Mac) to import data.
How to export data?
Use the shortcut keys Ctrl+Shift+E (Windows) or Command+Shift+E (Mac) to export data.
How to stop query execution?
Use Ctrl+Shift+F5 (Windows) or Command+Shift+F5 (Mac) to stop the currently executing query.
How to copy the currently selected content?
Use the shortcut keys Ctrl+C (Windows) or Command+C (Mac) to copy the currently selected content.

Summary

Navicat provides a large number of shortcut keys that can significantly improve the efficiency of database management and development. By familiarizing yourself with and using these shortcut keys, users can quickly complete tasks such as file operations, editing data, executing queries, importing and exporting data, etc., thereby reducing operation time and improving work efficiency.