Skip to content

Navicat for MySQL Feature Matrix

Navicat 17 for MySQL Feature Matrix

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