Object Design
well-designed user interface to create, modify, and manage all database objects, such as Tables, Views, Functions/Procedures, Indexes, Triggers, and Sequences.
Table Designer helps you create and modify tables, allowing you to set advanced options like relationships, constraints, triggers
Data Editing
Insert, edit, delete or copy/paste a data entry into spreadsheet-like data editor and Navicat will run the appropriate command (e.g. INSERT or UPDATE)
An array of data editing tools facilitate edits, such as the foreign key lookup, set/enum picker, and records filter.
SQL Editing
Context-sensitive Code Completion feature not only helps you to complete your queries
The Query Builder allows you to create and edit queries without knowledge of SQL.
The SQL Beautifier is designed to increase your productivity by helping you create well-formatted queries, improving their readability.
Data migration
Data Synchronization: Analyze and migrate data between databases/schemas, so you can ensure that databases are properly synchronized.
Data Transfer: Transfer data from local to local, local to remote, or even across MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases.
Export Wizard: Export data from tables, views, or query results to available formats like Excel, Access, and CSV.
Import Wizard: Import data from various files into your databases.
Report Builder
Convert data from your data source into report with Report Builder. Enhance reports with extensive charting and visualization options. Comprehensive report components, such as regions, subreports, and crosstabs.
Model Design
Convert your databases into graphical representations using a database design and modeling tool.
Use entity relationship diagrams to visualize database structures and data relationships so you can model, create, and understand complex databases with ease.
User Management
Create and edit user roles in minutes without having to type commands. User management capabilities enable you to elevate and manage administrative rights on a per-user basis. With this level of precise control, you can create rules and give users access without compromising database security.
Local backup solution to ensure the recovery of database Automatically perform backups with Schedule function, and save them on the local hard drive or a network drive.
Navicat lets you create a batch job to perform several tasks, such as printing reports, backing up your database, and then transferring data to another database.
You can schedule batch jobs to run at a specific time or day and set up email notification to ensure successful task completion. No matter where you are, you can always get the job done.
Navicat Cloud
Navicat provides users with our Navicat Cloud service. Sync your connection settings, models, queries and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.
Navicat supports almost all known database systems — MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite
Update tool info HERE
