Navicat Essentials is a compact version of Navicat which provides the basic and necessary features you will need to perform simple database administration. It supports the latest features, including Triggers, Functions, Views, and also comes with an Import/Export tool which allows data conversion from plain text formats such as TXT, CSV, and XML. It can also connect you to local/remote servers, providing several utilities such as SQL editors, import/export, and dump/execute SQL scripts, all of which help facilitate data maintenance.

Navicat Essentials is for Commercial use and is available for MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, and SQLite databases. If you need to administer all aforementioned database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple servers from a single application.

In MySQL databases, Navicat Essentials supports:

MySQL 3.21 or above.
Drizzle, OurDelta, Percona Server and MariaDB.
All MySQL objects: tables, views, stored procedures/functions and events.
All subobjects: fields, indexes, foreign keys and triggers.
Partitioning.
Character sets and unicode.

In MariaDB databases, Navicat Essentials supports:

MariaDB 5.1 or above.
All MySQL objects: tables, views, stored procedures/functions and events.
All subobjects: fields, indices, foreign keys and triggers.
Extra MariaDB features: new storage engines, microsecond and virtual columns.
Partitioning.
Character sets and unicode.

In SQL Server databases, Navicat Essentials supports:

SQL Server 2000 or above.
SQL Azure.
All SQL Server objects: tables, views, and functions.
All subobjects: fields, indexes, foreign keys, uniques, checks and triggers.
Management of linked servers, server triggers.
Management of partition functions, partition schemes, and database triggers.
Management of indexes, synonyms and triggers.
Character sets and unicode.

In SQLite databases, Navicat Essentials supports:

SQLite 2 and 3.
All SQLite objects: tables and views.
All subobjects: triggers and indices.
Character sets and unicode.

In Oracle databases, Navicat Essentials supports:

Oracle Servers 8.1 or above. (* Mac OS X Edition starts from Oracle 8.1.7)
All Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
All subobjects: fields, indexes, foreign keys, uniques, checks, and triggers.
Management of directories, tablespaces, public database links, and public synonyms.
Management of database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, xml schema, and recycle bin.
Management of physical attributes.
Character set and unicode.

In PostgreSQL databases, Navicat Essentials supports:

PostgreSQL Servers 7.3 or above.
All PostgreSQL objects: tables (Normal and Foreign Table), views, and functions.
All subobjects: fields, indices, foreign keys, uniques, checks, rules, and triggers.
Management of tablespaces, casts, foreign server and language.
Management of aggregates, conversions, domains, trigger functions, operators and classes, sequences, and types.
Character sets and unicode.

Only for V.I.P