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