Navicat Premium Essentials

Navicat Premium Essentials is an advanced utility that lets you administer SQL databases with user-friendly options and configuration settings. It offers support for MySQL, PostgreSQL, Oracle, SQLite, SQL Server and Maria DB.

Based on a normal window with a plain and simple structure, the interface is comfortable to work with. You can get started by indicating database connection settings, including name, IP address, port number, user name and password, settings location, along with preferences concerning the encoding method, automatic connection, SSL, SSH and HTTP tunnel. The connection can be tested before approving it.

It is possible to explore, open, create, design and create new tables, as well as to empty, duplicate and truncate them, set privileges, dump the corresponding SQL file, create shortcuts for opening tables, as well as to view and edit fields, indexes, foreign keys, triggers, options, and comments. The SQL query can be previewed within the main frame. What's more, objects can be sorted by various criteria (e.g. date of modification, rows, check time), while you can view a history log with app activity.

You can allow multiple instances for Navicat and forms, set the project to automatically save at a given frequency, hide the toolbar and main toolbar caption, show table hints, change the tab width for the editor, as well as modify the default locations for logs and profiles, and adjust the process priority level, among other options.

The software tool had minimal impact on computer performance during our tests, running on low CPU and RAM. It did not hang, crash or pop up error messages. Navicat Premium Essentials comes packed with the necessary and suffice tools for managing SQL databases.