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 |  |  |