Download Navicat Premium for macOS

Nine database types. One window. Navicat Premium 17.2.5 still does what it has done for years — MySQL, SQLite, Oracle, PostgreSQL, MongoDB, MariaDB, SQL Server, Redis and Snowflake all live in the same console, with the same toolbar and the same shortcuts.

The 17.2.5 build arrives as a maintenance release. Bug fixes mostly, plus small performance tweaks under the hood. What stays familiar is the breadth: stored procedures, triggers, functions and views are editable across MySQL, SQLite, Oracle and PostgreSQL. The import/export wizard handles data migration between different engines, and the job scheduler lets you queue batch tasks that span several database types overnight.

A short list of extras that keep this app useful: SQL Minifier for tidying long queries, business intelligence tools for quick charts, and access-rights configuration when you need to lock down a user. It is still part of the wider Navicat family, so if you have used Navicat for MySQL before, the layout will feel like home.

Switch to a mono font and tab-triggered completions

Open Preferences and switch the editor font to something monospaced you actually like — JetBrains Mono or Fira Code make a real difference when you stare at SQL all day. Next, turn on Auto-complete on tab under the SQL Editor section if it is not already active; it cuts down typing for object names across all nine database engines. Set the default snippet folder to a local path you sync, so your custom queries travel with you.

Another one people skip: head to the SSH panel and set a default key file. Once that is in place, every new tunnel inherits it — no more hunting through finder dialogs each time you add a connection.

Fix the TLS mismatch and blank PostgreSQL errors

Connection timeouts on Redis or MongoDB are often a TLS mismatch. Check whether the server expects --tls and toggle the setting in Navicat’s SSL tab to match. For PostgreSQL users, a blank error after running a function usually means the search path is not set; add SET search_path TO your_schema; ahead of the call.

Data sync between MySQL and Oracle trips up on date formats. If a sync job spits out warnings about timestamp conversion, open the sync profile and override the default format mask for the Oracle end — YYYY-MM-DD HH24:MI:SS usually resolves it. Also, the backup tool only covers MySQL InnoDB tables, so if you are running navicat premium 17 mac on a mixed engine setup, plan a separate dump script for MyISAM tables.

One window for MySQL, PostgreSQL and Redis

Anyone juggling three or more database engines daily gets the core value straight away. A developer who maintains a MySQL back end, a PostgreSQL reporting instance and a Redis cache layer can open one navicat window instead of three separate clients. The shared query builder and import wizard mean less context-switching.

Database engineers who migrate schemas across platforms lean on the data transfer tools heavily — moving a table from Oracle to PostgreSQL without leaving the interface saves a chunk of time. Even people who grab a Navicat Premium torrent for occasional cross-database lookups find the unified SQL console easier than remembering syntax differences for each engine.

Good to know: the ER model tool draws diagrams from live databases, so it is handy for documenting a legacy navicat for mac setup you inherited without any schema notes.

Version 17.3.12 rolls out a maintenance update with general stability work and minor corrections across the suite.

• macOS 11 or later
• Apple Silicon or Intel 64‑bit