| Connection |
| - MySQL 3.21 or later |  |  |
| - MariaDB 5.1 or later | | |
| - OceanBase Community and Enterprise 3.1.0 or later | | |
| - Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, Alibaba Cloud, Tencent Cloud, Huawei Cloud | | |
| - Secure connection: SSH, HTTP Tunnel and SSL/TLS | | |
| - PAM authentication | | |
| - Centralized connection management | | |
| - Connection profiles | | |
| - Customize connection colorings | | |
| - Export/import connection settings | | |
| Navicat Collaboration |
| - Collaboration: create projects, add members | | |
| - Synchronize connection settings, queries, snippets and virtual group information | | |
| - Synchronize BI workspaces and model workspaces | | |
| Data Viewer and Editor |
| - Grid view | | |
| - Form view | | |
| - Data profiling | | |
| - Text, hex, image or web viewer and editor | | |
| - Foreign key data selection | | |
| - Filter and sort | | |
| - Table profile | | |
| - Find and replace | | |
| Query Processing |
| - Query editor with syntax highlight | | |
| - Code completion | | |
| - Code snippet | | |
| - Query builder | | |
| - Visual explain | | |
| - Pin query result | | |
| - SQL beautifier and minifier | | |
| - Find and replace | | |
| - Create parameter queries | | |
| - Console | | |
| Object Designer |
| - Database object design tools | | |
| - View builder | | |
| - SQL preview | | |
| BI |
| - Over 20 chart type options | | |
| - Visualize live data | | |
| - Customized fields | | |
| - Customize multiple pages dashboard | | |
| - Add interactive controls | | |
| - Present mode | | |
| Model |
| - Conceptual, logical and physical model | | |
| - Reverse database to model | | |
| - Synchronize database to model | | |
| - Synchronize model to database | | |
| - Export model to SQL file | | |
| - Compare model workspaces | | |
| - Auto layout | | |
| - Add vertices, layers, images, notes, labels and shapes | | |
| - Print database diagrams to PDF and graphic files | | |
| Import and Export |
| - Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | | |
| - Import data from ODBC, MS Excel, MS Access, DBF | | |
| - Export data to MS Excel, DBF | | |
| - Export data to MS Access (Windows Edition only) | | |
| Structure and Data Manipulation |
| - Structure synchronization | | |
| - Data transfer | | |
| - Data synchronization | | |
| - Data generation | | |
| - Data dictionary | | |
| - Copy and paste data across databases | | |
| Backup and Restore |
| - Backup/restore database | | |
| - Convert backup file into SQL script | | |
| - Dump/execute SQL file | | |
| Automation |
| - Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export | | |
| - Run profiles from different servers in a single batch job | | |
| - Include attachment for export file in notification email | | |
| Server Security |
| - Manage user | | |
| - Server monitor | | |
| Other Useful Features |
| - ER diagram view | | |
| - Open object via URI | | |
| - Virtual grouping | | |
| - Database wide search | | |
| - Favorites list | | |
| - Focus mode | | |
| - Dark mode | | |