It helps you to quickly manage your databases edit tables!

Navicat Premium for Mac

Navicat Premium for Mac

  -  299 MB  -  Trial
Navicat Premium for Mac is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas and Huawei Cloud. You can quickly and easily build, manage and maintain your databases.

Features and Highlights

Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables/collections, views, or query results to formats such as Excel, Access, CSV and more. Add, modify, and delete records with built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat for macOS gives you the tools you need to manage your data efficiently and ensure a smooth process.

Easy SQL/Query Editing
Visual SQL/Query Builder will help you create, edit and run SQL statements/queries without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

Intelligent Database Designer
Create, modify and manage all database objects using professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.

Increase Your Productivity
Powerful local backup/restore solution and intuitive GUI for MongoDBDump, Oracle Data Pump and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow, and set an automation for repeatable deployment process like report generation, database backup, MapReduce job and script execution at a specific time or day. No matter where you are, you can always get the job done.

Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to the app Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.

Smart Schema Analyzer
Discover and explore your MongoDB schema with built-in schema visualization tool. Analyze your documents and displays rich structures within your collections, so you can understand your data’s schema, find schema anomalies, and inspect outliers easily.

Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navi cat Premium provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Note: 14 days trial version.

Also Available: Download Navicat Premium for Windows

  • Navicat Premium 17.1.5 Screenshots

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

    Navicat Premium 17.1.5 Screenshot 1

What's new in this version:

Navicat Premium 17.1.5
Fixed:
- Unable to show the trigger definition after reordering the trigger in Table Designer
- Error occurred when duplicating SQL Server tables
- Minor bug fixes and improvements


Navicat Premium 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 Premium 17.1.3
- Incorrectly setting all values in the row to NULL, not just the selected cell
- Unable to show "SECURITY DEFINER" in the function definition
- No tables listed when reverse engineering SQL Server databases to model
- Minor bug fixes and improvements


Navicat Premium 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 Premium 17.1.0
Main New Features:
- Support Microsoft Garnet
- Support Alibaba Cloud PolarDB for MySQL, Alibaba Cloud PolarDB for PostgreSQL, Alibaba Cloud PolarDB for Xscale
- Support Visual Query Explain for SQL Server, MongoDB and OceanBase (MySQL Mode)
- Support Tree View for Redis Data
- Enhanced Query Editor
- Enhanced BI Feature
- Support Conceptual Models Comparison
- New Filter & Sort Layout
- Many other new features and improvements


Navicat Premium 17.0.14
- Unable to copy and paste records in the data grid
- Crashed when clicking the Options button in the Data Generation window
- Incorrect Boolean values were transferred when transferring PostgreSQL tables
- Minor bug fixes and improvements


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


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


Navicat Premium 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 Premium 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 Premium 17.0.8
- Minor bug fixes and improvements


Navicat Premium 17.0.7
Fixed:
- SHIFT-TAB shortcut did not work in the data viewer
- Data edit mode did not work in some cases
- Crashed when reversing SQL Server database to model
- Crashed when reversing SQLite database to model
- Minor bug fixes and improvements


Navicat Premium 17.0.6
Main New Features:
- All-New Model Workspace
- Data Profiling
- Data Dictionary
- Query Pinned Result
- Visual Query Explain
- Table/Collection Profile
- Navicat URI
- Manage Connection
- Enhanced BI Feature
- Visual Aggregation Pipeline
- Focus Mode
- Support Redis Sentinel
- Many other new features and improvements


Navicat Premium 17.0.5
Main New Features:
- All-New Model Workspace
- Data Profiling
- Data Dictionary
- Query Pinned Result
- Visual Query Explain
- Table/Collection Profile
- Navicat URI
- Manage Connection
- Enhanced BI Feature
- Visual Aggregation Pipeline
- Focus Mode
- Support Redis Sentinel
- Many other new features and improvements


Navicat Premium 16.3.7
Fixed:
- Crashed when PostgreSQL connection was lost
- Modified data types were not retained when switching to other tables in Import Wizard
- "Invalid cursor state" error occurred after computer was idle
- 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 Premium 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 Premium 16.3.5
Fixed:
- Unable to load indexes in MariaDB Table Designer
- Crashed when closing Server Monitor
- Crashed when switching tabs on Information Pane
- Unable to access users in MongoDB
- The percentage values shown in the chart were incorrect
- Minor bug fixes and improvements


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


Navicat Premium 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
- Crashed when typing commands in Redis Query
- Minor bug fixes and improvements


Navicat Premium 16.3.1
- Crashed when opening Redis connection
- Minor bug fixes and improvements


Navicat Premium 16.3.0
Improved:
- Support Redis Cluster
- Support MongoDB Time-Series Collection
- Support setting MySQL descending primary key

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


Navicat Premium 16.2.9
Fixed:
- "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
- Crashed on macOS 14.
- MariaDB Triggers were transferred multiple times during Data Transfer
- Minor bug fixes and improvements


Navicat Premium 16.2.7
Improvements:
- Support Huawei Cloud GaussDB Centralized

Fixed:
- Beautify SQL incorrectly added spaces between the function name and parentheses
- Dump SQL File did not correctly generate DEFAULT PARTITION
- "Parameters supplied for object 'xxx' which is not a function" error occurred when adding record in some cases
- Minor bug fixes and improvements


Navicat Premium 16.2.6
Improved:
- Support JSON key type for Redis

Fixed:
- Syntax error occurred when creating SQL Server database
- Minor bug fixes and improvements


Navicat Premium 16.2.5
- Field mapping lost after saving MongoDB import wizard profile
- Minor bug fixes and improvements


Navicat Premium 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 Premium 16.2.2
Improved:
- Improve SQL Server Trigger editor

Fixed:
- Minor bug fixes and improvements


Navicat Premium 16.2.1
- Support Redis connections
- View, edit, search and sort Redis keys and data with Data View
- Capture and analyze Redis Pub/Sub messages in real-time
- Support local backup and restore of Redis databases
- Intuitive interface for editing Redis users and ACLs
- Redis Console with syntax highlight and code completion
- Well-formatted Redis query results
- Automate Redis backup and query execution
- Command Monitor and Server Monitor for real-time monitoring of Redis
- 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 Premium 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 Premium 16.1.9
Fixed:
- Crashed when opening Preferences in some cases
- Unable to save changes in SQL Server View
- Crashed when importing database to model in some cases
- Crashed when saving table after changing field comment
- Minor bug fixes and improvements


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


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


Navicat Premium 16.1.4
Fixed:
- 1267 error occurred when clicking the "Users" button
- Bar chart label display issue
- Unable to connect CockroachDB Serverless
- BLOB data was truncated in Console
- MongoDB create index issue
- Table columns were not aligned in Console
- Chart value labels disappeared after reopening Navicat in dark mode
- Minor bug fixes and improvements


Navicat Premium 16.1.3
Fixed:
- Unable to enter Enum values in MariaDB table designer
- Query Builder did not recognize the selected fields
- Crashed when connecting to MongoDB in some cases
- "Feature not supported" error occurred when using MongoExport
- "Incomplete Input" error occurred when editing SQLite table
- Minor bug fixes and improvements


Navicat Premium 16.1.2
- Minor bug fixes and improvements


Navicat Premium 16.1.1
Fixed:
- Unable to open the objects in the "Find in Database" window
- The values of RAW columns were displayed as garbled characters
- Cannot show query errors when using HTTP tunnel
- Data transfer process stopped when transferring MongoDB database
- Crashed when renaming a connection in a group
- Cannot show the new group unless Navicat was restarted
- CREATE INDEX SQL was missing table name when exporting PostgreSQL model to a SQL file
- Syntax error occurred when using BEGIN ATOMIC in query
- Checks were not imported when using "Reverse Database to Model"
- Unable to sort columns in table viewer
- Minor bug fixes and improvements


Navicat Premium 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 Premium 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 Premium 16.0.13
Fixed:
- Chart title display issue
- Query listing issue when loading cloud queries
- Minor bug fixes and improvements


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


Navicat Premium 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 Premium 16.0.10
- Change log not available for this version


Navicat Premium 16.0.9
- Minor bug fixes and improvements


Navicat Premium 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 Premium 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
- Unknown Internal Error occurred when designing PostgreSQL table
- Minor bug fixes and improvements


Navicat Premium 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
- Minor bug fixes and improvements


Navicat Premium 16.0.3
Main New Features:
- New Data Generation Tool
- Enhanced Charts Feature
- Support of Navicat On-Prem Server

Additional Features:
- Connection Profiles
- Field Information Pane
- PostgreSQL Extensions Management
- Query Execution Summary
- Navicat On-Prem Server is released
- Many other new features and improvements


Navicat Premium 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
- Cannot connect to Microsoft Azure Database in some cases
- Minor bug fixes and improvements


Navicat Premium 15.0.30
Fixed:
- Unable to dump databases from MongoDB Atlas using MongoDump
- Unable to show the cursor when editing TEXT data using Form View in Dark Mode
- Minor bug fixes and improvements


Navicat Premium 15.0.29
Fixed:
- Crashed when adding relations to a logical model
- Differences were incorrectly detected when synchronizing MySQL table structures
- Crashed when running query in some cases
- Error occurred when transferring SQL Server tables with user-defined types to other server types
- Minor bug fixes and improvements


Navicat Premium 15.0.28
Fixed:
- Unable to update data in some cases
- Crashed when adding a trigger to PostgreSQL model
- 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 Premium 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
- Unable to connect to server via SSH Tunnel in some cases
- Hanged when starting Navicat in some cases
- "Different primary key type" error occurred when synchronizing MySQL data
- Minor bug fixes and improvements


Navicat Premium 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 Premium 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 Premium 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 Premium 15.0.21
Bug fixes:
- The "Set to 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 "SQLite3 Dynamic Library" option did not work
- 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 Premium 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
- Crashed when connecting to MongoDB in some cases
- Minor bug fixes and improvements


Navicat Premium 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
- "Authentication failed" error occurred when using MongoDump
- Crashed when running MongoDB query for the second time
- Minor bug fixes and improvements


Navicat Premium 15.0.17
Bug fixes:
- Error occurred when running a valid updateMany query
- 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 Premium 15.0.16
Bug fixes:
- MongoDB data export failed
- Minor bug fixes and improvements


Navicat Premium 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
- Unable to set SET IDENTITY_INSERT ON in Data Synchronization
- The list of the reference tables for foreign key was empty in Model
- Minor bug fixes and improvements


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


Navicat Premium 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 Premium 15.0.11
Bug fixes:
- Relation attributes were wrong after reopening the logical model
- Minor bug fixes and improvements


Navicat Premium 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 Premium 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 Premium 15.0.7
Bug fixes:
- Crashed when starting Navicat
- Crashed when running Data Transfer in some cases
- Minor bug fixes and improvements


Navicat Premium 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 Premium 15.0.5
- Change log not available for this version


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