The SQL query can be previewed within the main frame. 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. Manage tables, views, functions and events The connection can be tested before approving it. 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. Clean and elegant interfaceīased on a normal window with a plain and simple structure, the interface is comfortable to work with.

It offers support for MySQL, PostgreSQL, Oracle, SQLite, SQL Server and Maria DB.

Navicat Premium Essentials is an advanced utility that lets you administer SQL databases with user-friendly options and configuration settings.

Navicat premium download