Brilliant management of Several databases from one application. Management of aggregates, conversions, domains, trigger functions, operators and classes, sequences, and types.I am happy with overall usage of Navicat because it has helped in creating very complex SQL queries easily using its visual Query Builder.Management of tablespaces, casts, foreign server and language.All subobjects: fields, indices, foreign keys, uniques, checks, rules, and triggers.All PostgreSQL objects: tables (Normal and Foreign Table), views, and functions.In PostgreSQL databases, Navicat Essentials supports: Management of database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, xml schema, and recycle bin.Management of directories, tablespaces, public database links, and public synonyms.All subobjects: fields, indexes, foreign keys, uniques, checks, and triggers.All Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.(* Mac OS X Edition starts from Oracle 8.1.7) In Oracle databases, Navicat Essentials supports: In SQLite databases, Navicat Essentials supports: Management of indexes, synonyms and triggers.Management of partition functions, partition schemes, and database triggers.

Management of linked servers, server triggers.All subobjects: fields, indexes, foreign keys, uniques, checks and triggers.All SQL Server objects: tables, views, and functions.In SQL Server databases, Navicat Essentials supports: Extra MariaDB features: new storage engines, microsecond and virtual columns.All subobjects: fields, indices, foreign keys and triggers.

In MariaDB databases, Navicat Essentials supports:

All subobjects: fields, indexes, foreign keys and triggers.

All MySQL objects: tables, views, stored procedures/functions and events.

Drizzle, OurDelta, Percona Server and MariaDB.

In MySQL databases, Navicat Essentials supports:

Navicat premium 16