Navicat Premium 17.3.12 — Mac version

You’re pulling a report that needs figures from a MySQL sales database and a PostgreSQL stock system. Instead of switching between two heavyweight apps, you open a single workspace and get both sets of tables side by side.

Connect to MySQL, SQLite, Oracle and PostgreSQL in one window

• Working across database types at once. Connect to MySQL, SQLite, Oracle and PostgreSQL simultaneously. No hopping between tools.
• Building queries without writing every line. The query builder lets you drag columns and set conditions visually, then see the raw SQL it produces.
• Moving data between systems. The transfer tool copies records straight from MySQL to PostgreSQL or Oracle, handling the type mapping for you.
• Designing a database before you build it. Data modelling and ER diagram tools give you a clean canvas for sketching out tables, relationships and indexes.
• Routine admin jobs. Create or drop databases, tables, indexes and users. Back up and restore without leaving the app.
• Getting data in and out. Import and export wizards cover CSV, Excel and other common formats. A report wizard turns query results into printable output.
• Searching across schemas. The database search digs through table names, field names and data so you find a stray column fast.

Interface feels busy when you only need a quick connection

• It bundles features from several Navicat apps, so the interface can feel busy when you only need a quick connection.
• HTTP Tunnel support is included for reaching databases behind a web server, but it’s one more thing to configure if your host needs it.

Chasing a reporting bug across e-commerce and warehouse databases

You’re chasing down a reporting bug. The overnight export shows fewer orders than yesterday, so you launch Navicat Premium and open your saved connections — MySQL for the e-commerce tables, PostgreSQL for the warehouse data — in one window.

You type a quick COUNT query against the orders table and spot nothing unusual. So you open the query builder, drag the order date field into the grid and add a condition for the last 24 hours. The row count matches what the broken report said. Next you turn to the PostgreSQL connection, paste the same time-window query into the SQL console and compare the results side by side. That’s when you see it: the warehouse stock updates ran late and the batch job never picked up those rows. You jot the fix in a sticky note and close the tabs. No exports, no separate tools — ten minutes, one application, problem found.

Morning MySQL health check and evening PostgreSQL backup in one tool

Database admins who juggle three or four engines daily. If your morning starts with a MySQL health check and ends with a PostgreSQL backup, having one tool that knows both dialects saves you from mental context-switching. Developers building across Oracle and SQLite get the same benefit — write a query once, then tweak the syntax per engine without leaving the workspace. Data engineers moving legacy records into something newer will lean on the transfer wizard, because it handles the type mapping that makes manual imports such a grind. Anyone doing occasional cross-database reports also gets value, though the full interface might feel heavy if you only open it once a week.

Eight database servers listed without a noticeable pause

Connection pane opens fast even when you’ve saved eight or ten database servers — it lists them without a noticeable pause. Query results for medium-sized tables (under a hundred thousand rows) appear in under a second on a recent Mac, and scrolling through larger sets doesn’t stutter. The query builder feels snappiest on Apple Silicon, but it runs without complaint on an Intel Mac with 8 GB of RAM as well. Memory use sits around 600–700 MB with multiple connections open, which is fair for what it’s holding. Crashes are rare in routine editing tasks, though the occasional beachball can appear when you run a badly-optimised query that ties up the server — close the tab and you’re back in control. If you’re after a navicat torrent for a first look, you’ll find the current build runs smoothly on macOS 11 and above.

Build 17.3.12 gathers the latest stability work and under-the-hood tidying for the multi-database toolkit.

• macOS 11 (Big Sur) or later
• Apple Silicon or Intel 64-bit Mac