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 Data Modeler 2.1 is a graphical tool that helps you build accurate predictive models quickly and intuitively, enabling users of all levels to create high quality data models with ease. It provides professional users with sophisticated features specific to their needs, but it is also easy enough for those new to modeling to get started with.

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.

Simpler. Smarter. Faster.

Navicat Data Modeler 2.1 comes with an incredibly responsive and elegant design that enhances the performance and usability in order for you to get a simple and precise picture of your model easily without spending too much time learning the software.

Together with an accurate field type prediction feature and unlimited undo/redo capability, it reduces your development time and offers a quick and efficient way to create and edit your table/view structures.

Reduce costs, increase productivity
We’ve designed a collection of features for you to choose from. Whether you want to create new databases from a data model, or import a data model from an existing database. Here is the place.

Reverse
Engineering
With the reverse engineering feature, you can create models from existing databases with just a few simple clicks.

Using a step-by-step wizard, you can import existing database structures and create models from different sources such as MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, SQLite, and even from an ODBC data source.

The resulting models graphically show the structure of a database so that you can see and organize data elements, such as tables, views and relations without showing the actual data.

Forward
Engineering
With the forward engineering feature, your visual data model can be transformed into a physical database on any servers supported by Navicat Data Modeler - MySQL, MariaDB, SQL Server, PostgreSQL, Oracle and SQLite.

You can also compare your model with a live database to capture the differences in objects and properties, so that you can get a full analysis before expanding and upgrading your existing system.

Additionally, you can export a model directly to DDL script to streamline the process of writing SQL statements.

Only for V.I.P