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
Download Navicat Windows Shortcut Keys Cheatsheet PDF
We provide a Navicat Windows 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
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
Download Navicat MacOS Shortcut Keys Cheatsheet PDF
We provide a Navicat 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 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.
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.
