Navicat

Navicat is a Windows application for database management, local and remote mode is supported. It is possible to connect to cloud storage. All necessary tools are available, including a query panel and script editor, a report generation module, and much more.

Connection

After installation, you need to initiate a connection to the new server. SSH tunneling is supported to protect the channel from external attacks. The password used can be saved and set up automatic connection after starting the program. This will eliminate the need to authorize each time you log in.

Development

The application allows you to create databases and design table structure. A set of tables can be transferred to another server and data can be exported to an external file. The set of available tools allows you to make selections, sort and search records. A handy query editor makes it easy to work with code. Syntax is highlighted, there is a system of hints. A multifunctional task scheduler is built in. To optimize your work, you can use scripts, assigning them to perform routine tasks. Convenient tools for generating reports are built in. In particular, you can visualize the current structure of tables and all the links between them. File import is supported. Functionality for organizing joint work is supported. It is possible to create backup copies of individual tables or databases, restoring them if necessary. You can synchronize information between different servers to distribute the load.

Features

• The program contains a set of tools for working with databases;
• you can design the structure of tables;
• working with queries;
• script editor for automation;
• data synchronization mode between servers;
• a convenient graphical interface is used.