Ideal solution for MySQL/MariaDB administration and development

Navicat for MySQL

Navicat for MySQL

  -  194 MB  -  Trial
Navicat for MySQL (Mac version) is the ideal solution for MySQL/MariaDB administration and development. Connect to MySQL and MariaDB databases simultaneously within a single application. This all-inclusive front-end provides an intuitive and powerful graphical interface for database management, development, and maintenance. It delivers a comprehensive set of tools for those new to MySQL/MariaDB as well as professional developers.

Navicat for MySQL (macOS Version) connects to local/remote MySQL or MariaDB servers. It works with MySQL database servers from version 3.21 or above and MariaDB 5.1 or higher. It is also compatible with Drizzle, OurDelta, and Percona Server, and supports most of the latest features, including Tables, Views, Functions/Procedures, Events, and more.

Major features include the SQL Builder/Editor, a Data Modeling Tool, Data Transfer, Import/Export, Data/Structure Synchronization, Report, and much more.

Note: 30 days trial version. Requires 64-bit processor.

Also Available: Download Navicat MySQL for Windows

  • Navicat for MySQL 17.1.5 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    Navicat for MySQL 17.1.5 Screenshot 1
  • Navicat for MySQL 17.1.5 Screenshot 2
  • Navicat for MySQL 17.1.5 Screenshot 3

What's new in this version:

Navicat for MySQL 17.1.5
Fixed:
- Unable to show the trigger definition after reordering the trigger in Table Designer
- Minor bug fixes and improvements


Navicat for MySQL 17.1.4
Fixed:
- Unable to copy multiple columns in the data viewer
- Lost focus when updating row value
- Unable to open database connection after VPN disconnected/reconnected
- Minor bug fixes and improvements


Navicat for MySQL 17.1.3
Fixed:
- Incorrectly setting all values in the row to NULL, not just the selected cell
- Minor bug fixes and improvements


Navicat for MySQL 17.1.2
Fixed:
- Model diagram disappeared when hovering over
- Unable to import CSV data with escaped double quotes
- Minor bug fixes and improvements


Navicat for MySQL 17.1.0
Main New Features:
- Support Alibaba Cloud PolarDB for MySQL, Alibaba Cloud PolarDB for Xscale
- Support Visual Query Explain for OceanBase (MySQL Mode)
- Enhanced Query Editor
- Enhanced BI Feature
- New Filter & Sort Layout
- Many other new features and improvements


Navicat for MySQL 17.0.14
- Unable to copy and paste records in the data grid
- Crashed when clicking the Options button in the Data Generation window
- Minor bug fixes and improvements


Navicat for MySQL 17.0.13
Fixed:
- Vertical scroll bar was missing from the function input parameters dialog box
- Minor bug fixes and improvements


Navicat for MySQL 17.0.12
Fixed:
- Process list columns are duplicated in Server Monitor
- Foreign keys were not deleted when deleting the parent table in the model
- Minor bug fixes and improvements


Navicat for MySQL 17.0.10
- The pop-up menu in the navigation pane was missing options
- Crashed when creating relations in ER diagram
- Unable to delete the first record in the data grid
- Column settings reset after refreshing in Server Monitor
- Minor bug fixes and improvements


Navicat for MySQL 17.0.9
Fixed:
- Crashed when designing tables
- Form View did not display the current record selected in Grid View
- The reference field was not updated when changing the primary key field in the model
- Crashed when performing Forward Engineering
- Minor bug fixes and improvements


Navicat for MySQL 17.0.8
- Minor bug fixes and improvements


Navicat for MySQL 17.0.7
Fixed:
- SHIFT-TAB shortcut did not work in the data viewer
- Data edit mode did not work in some cases
- Minor bug fixes and improvements


Navicat for MySQL 17.0.6
Main New Features:
- All-New Model Workspace
- Data Profiling
- Data Dictionary
- Query Pinned Result
- Visual Query Explain
- Table Profile
- Navicat URI
- Manage Connection
- Enhanced BI Feature
- Focus Mode
- Many other new features and improvements


Navicat for MySQL 17.0.5
Main New Features:
- All-New Model Workspace
- Data Profiling
- Data Dictionary
- Query Pinned Result
- Visual Query Explain
- Table Profile
- Navicat URI
- Manage Connection
- Enhanced BI Feature
- Focus Mode
- Many other new features and improvements


Navicat for MySQL 16.3.7
Fixed:
- Modified data types were not retained when switching to other tables in Import Wizard
- Incorrect json array index syntax was generated when transferring MySQL tables
- Unable to connect using ssh agent in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.3.6
Fixed:
- Crashed when presenting dashboard in some cases
- Unable to change data types when creating tables
- Focus moved to the upper level after deleting an object in Navigation Panel
- Some labels disappeared after adding the chart to the dashboard
- Unable to display proportion percentages in the chart axis
- Minor bug fixes and improvements


Navicat for MySQL 16.3.5
Fixed:
- Unable to load indexes in MariaDB Table Designer
- Crashed when closing Server Monitor
- The percentage values shown in the chart were incorrect
- Minor bug fixes and improvements


Navicat for MySQL 16.3.4
Fixed:
- Crashed when opening Navicat on older macOS versions
- Minor bug fixes and improvements


Navicat for MySQL 16.3.3
Improved:
- Support enabling or disabling "Detect Data Types" in Import Wizard
- Support ssh agent using pageant unix mode

Fixed:
- Minor bug fixes and improvements


Navicat for MySQL 16.3.2
- COMMAND-F shortcut did not work in the main window
- Refresh button did not work in Server Monitor
- Text in the Search box was hidden in some cases
- Advanced options in Structure Synchronization cannot be displayed
- Minor bug fixes and improvements


Navicat for MySQL 16.3.1
- Minor bug fixes and improvements


Navicat for MySQL 16.3.0
Improved:
- Support setting MySQL descending primary key

Fixed:
- Crashed when transferring large tables using SSH connection
- Minor bug fixes and improvements


Navicat for MySQL 16.2.9
Fixed:
- Crashed on macOS 14
- MariaDB Triggers were transferred multiple times during Data Transfer
- Minor bug fixes and improvements


Navicat for MySQL 16.2.7
Fixed:
- Beautify SQL incorrectly added spaces between the function name and parentheses
- Minor bug fixes and improvements


Navicat for MySQL 16.2.6
- Minor bug fixes and improvements


Navicat for MySQL 16.2.5
- Minor bug fixes and improvements


Navicat for MySQL 16.2.3
Fixed:
- Copy and paste shortcuts did not work in Navigation pane
- The focus jumped to the top level after renaming an object in Navigation pane
- Table tree loading issue in Navigation Pane
- Minor bug fixes and improvements


Navicat for MySQL 16.2.2
- Minor bug fixes and improvements


Navicat for MySQL 16.2.1
- Support sequence design for MariaDB
- Show fields, indexes and more under tables in Navigation Pane
- Minor bug fixes and improvements
- Navicat for Redis is released


Navicat for MySQL 16.1.10
Fixed:
- High CPU usage when using SSH connection
- Unable to save the schedule changes
- TAB key did not work when adding field
- Minor bug fixes and improvements


Navicat for MySQL 16.1.9
Fixed:
- Crashed when opening Preferences in some cases
- Crashed when importing database to model in some cases
- Crashed when saving table after changing field comment
- Minor bug fixes and improvements


Navicat for MySQL 16.1.7
Fixed:
- Memory utilization issue
- Crashed when importing data to model in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.1.5
Fixed:
- Default value did not show when adding new records
- Minor bug fixes and improvements


Navicat for MySQL 16.1.4
Fixed:
- Unable to enter Enum values in MariaDB table designer
- Query Builder did not recognize the selected fields
- Minor bug fixes and improvements


Navicat for MySQL 16.1.3
Fixed:
- Unable to enter Enum values in MariaDB table designer
- Query Builder did not recognize the selected fields
- Minor bug fixes and improvements


Navicat for MySQL 16.1.2
- Minor bug fixes and improvements


Navicat for MySQL 16.1.1
Fixed:
- Unable to open the objects in the "Find in Database" window
- Cannot show query errors when using HTTP tunnel
- Crashed when renaming a connection in a group
- Cannot show the new group unless Navicat was restarted
- Checks were not imported when using "Reverse Database to Model"
- Unable to sort columns in table viewer
- Minor bug fixes and improvements


Navicat for MySQL 16.1.1
- Unable to open the objects in the "Find in Database" window
- The first number of every value in the list was removed in the table filter
- Unknown Internal Error occurred when updating query results in some cases
- Unable to use "Copy As" in View results
- Crashed when opening functions in some cases
- Unknown Internal Error occurred when foreign key selection window popped up
- Crashed when clicking on the value box in table filter
- Cannot retain the window size and position for existing objects
- Minor bug fixes and improvements


Navicat for MySQL 16.1.0
Main New Features:
- Support OceanBase Community Edition
- Support Trend Line for several chart types
- Support adding On-Prem Server with URI
- Allow skip preview of changes in data sync
- Enhanced responsiveness and performance
- Improved UI/UX
- Minor bug fixes and improvements


Navicat for MySQL 16.0.14
Fixed:
- Query parameters did not work in some cases
- Function group creation issue
- Hanged when updating records in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.0.13
Fixed:
- Chart title display issue
- Query listing issue when loading cloud queries
- Minor bug fixes and improvements


Navicat for MySQL 16.0.12
Fixed:
- Crashed when opening a table in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.0.11
Fixed:
- Add/Delete Foreign Key issue in ER diagram
- "Show bar labels" setting cannot be saved in Charts
- Crashed when moving a connection from Navicat Cloud to My Connections
- Crashed when running Automation in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.0.10
- Change log not available for this version


Navicat for MySQL 16.0.9
Fixed:
- The "Compare" button did not work in Data Synchronization in some cases
- "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters
- Minor bug fixes and improvements


Navicat for MySQL 16.0.7
Fixed:
- Data Transfer failed when using HTTP tunnel
- Line numbers disappeared when scrolling in Query Editor
- Crashed when mapping MySQL and MariaDB fields in Data Synchronization
- Minor bug fixes and improvements


Navicat for MySQL 16.0.5
Fixed:
- Connection encoding issue in Navicat Cloud
- Connection password issue when updating connection in Navicat Cloud
- Error occurred when synchronizing to Navicat Cloud
- Minor bug fixes and improvements


Navicat for MySQL 16.0.4
Fixed:
- Syntax error occurred when importing data to MySQL table
- Crashed when opening query on macOS 10.14
- SSL connection error
- Missing zero padding in year when exporting data to CSV / TXT file
- Missing menu items when opening query in new window
- Crashed when importing connections
- Minor bug fixes and improvements


Navicat for MySQL 15.0.32
Fixed:
- Crashed when running scripts in some cases
- Crashed when copying records in some cases
- The TEXT pane did not retain when running queries
- Minor bug fixes and improvements


Navicat for MySQL 15.0.30
Fixed:
- Unable to show the cursor when editing TEXT data using Form View in Dark Mode
- Minor bug fixes and improvements


Navicat for MySQL 15.0.29
Fixed:
- Differences were incorrectly detected when synchronizing MySQL table structures
- Crashed when running query in some cases
- Minor bug fixes and improvements


Navicat for MySQL 15.0.28
Fixed:
- Unable to update data in some cases
- Crashed when using Data Transfer in some cases
- Exporting JSON field didn't handle NULL and integer values properly
- Cursor did not focus to the Search box after pressing CMD-F
- Crashed when selecting the "Group by Object Type" in Structure Synchronization
- Minor bug fixes and improvements


Navicat for MySQL 15.0.26
Fixed:
- Unable to read grid data in Dark mode
- Unable to sort the last column by clicking the column header in Table Viewer
- Duplicate entry error occurred when editing the pasted records
- Hanged when starting Navicat in some cases
- "Different primary key type" error occurred when synchronizing MySQL data
- Minor bug fixes and improvements


Navicat for MySQL 15.0.25
Bug-fixes:
- 'Primary key needs to be integer' error occurred when synchronizing data
- Unable to show the ENUM items list in Table Viewer
- Unable to sort by clicking the column header in Table Viewer
- Minor bug fixes and improvements


Navicat for MySQL 15.0.24
Improvements:
- Set the values of a column to NULL

Bug fixes:
- Crashed when saving MariaDB Views
- The modified dates of backup files were incorrect
- Minor bug fixes and improvements


Navicat for MySQL 15.0.22
Improvements:
- Prompt to change the MariaDB password when it expired

Bug fixes:
- Unable to show the granted privileges if the database name contained wildcard characters
- Only the last selected table was printed when printing multiple tables
- The SQL Editor was flickered and repainted when saving the query
- "Auto Increment" and "Unsigned" options were removed after adding another field
- Crashed when using Query Builder on Big Sur
- Minor bug fixes and improvements


Navicat for MySQL 15.0.21
Bug fixes:
- The "Set Null" option was applied to a wrong column when some columns were hidden in Table Viewer
- The field size was incorrect in Form View
- Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents
- The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud
- "Dump SQL File" stopped running in some cases
- Minor bug fixes and improvements


Navicat for MySQL 15.0.20
Bug fixes:
- Unable to set the encoding of MariaDB connection
- Unable to connect MySQL server when using TLSv1.2
- Schedule did not trigger when using Navicat App Store version
- The "Close Database" option in the context menu was dimmed when a query tab was focused
- The entire connection tree was collapsed when searching
- Crashed when deleting a data source in Charts
- Minor bug fixes and improvements


Navicat for MySQL 15.0.18
Improvements:
- Improvement on resizing Information pane

Bug fixes:
- Negative default value displayed as "-" in MariaDB
- No records were imported in some cases when Import Wizard displayed "Finished Successfully"
- Wrong SQL generated for CAST function when switching between Query Editor and Query Builder
- Minor bug fixes and improvements


Navicat for MySQL 15.0.17
Bug fixes:
- Unable to show full table names in the Data Synchronization window
- Field names in the Join dialog were truncated
- Minor bug fixes and improvements


Navicat for MySQL 15.0.16
- Minor bug fixes and improvements


Navicat for MySQL 15.0.15
Bug fixes:
- Jumped to the first record when refreshing in Form View
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- The list of the reference tables for foreign key was empty in Model
- Minor bug fixes and improvements


Navicat for MySQL 15.0.14
Bug fixes:
- The state of the pane in model was not retained
- Field count was missing in Table Designer
- Crashed when opening Console
- Minor bug fixes and improvements


Navicat for MySQL 15.0.12
Bug-fixes:
- "9015: Error Moving Error" error occurred when using Navicat Cloud
- Crashed when clicking the Next button without choosing a target database in Data Transfer
- Unable to show the whole Trial Reminder dialog
- Crashed when editing/composing new queries in some cases
- Invalid XML error occurred when importing connections
- Crashed when starting Data Transfer in some cases
- Minor bug fixes and improvements


Navicat for MySQL 15.0.11
Bug fixes:- Console was missing in Standard eidtion
- Minor bug fixes and improvements


Navicat for MySQL 15.0.10
Bug fixes:
- Crashed when using Data Transfer in some cases
- Inserted records to the target server when transferring views
- CPU usage was high when using Query Builder
- Unable to open the main window when starting Navicat
- Minor bug fixes and improvements


Navicat for MySQL 15.0.8
Bug fixes:
- Crashed when starting Navicat
- Dates before 1900 were exported as numeric values when exporting to Excel
- The Search feature did not work properly in the Data Transfer window
- Icon and text were not aligned well in the Navigation pan
- The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat
- Minor bug fixes and improvements


Navicat for MySQL 15.0.7
Bug fixes:
- Crashed when starting Navicat
- Crashed when running Data Transfer in some cases
- Minor bug fixes and improvements


Navicat for MySQL 15.0.6
Bug fixes:
- Unable to run selected query in some cases
- Crashed when using Data Transfer
- Unable to show which database is active
- Minor bug fixes and improvements


Navicat for MySQL 15.0.5
- Change log not available for this version


Navicat for MySQL 15.0.4
Bug fixes:
- Data Synchronization options were unable to save in profile
- Auto Layout feature separated notes and labels from layers
- Unable to copy SQL query from Process List in Server Monitor


Navicat for MySQL 15.0.3
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements