Navicat Premium 17

Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, Redis, PostgreSQL, SQL Server, Oracle, MariaDB, SQLite, and MongoDB databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, MongoDB Atlas and Redis Enterprise Cloud. Additionally, Navicat Premium is compatible with GaussDB and OceanBase databases. You can quickly and easily build, manage and maintain your databases.
Data Viewer
View, update, and delete records seamlessly in Grid View or Form View through our built-in editors. Integrate a data profiling tool for comprehensive and visual analysis of your data. You can also interact with the visual charts to further explore the data.
Object Designer
Manage database objects through a clear and responsive interface that breaks down query writing into structured tabs. Allow you to write complex queries with greater confidence and accuracy at every step.
Query Edit
Accelerate your coding process with Code Completion and Code Snippet, and gain valuable insights into query-database interaction by visualizing the execution plan. You can also visually construct queries using a set of interactive tools.
Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize data and structure between databases. Set up and deploy the comparisons in seconds, and get the detailed script to precisely outlines the changes you want to execute.
Model
Convert your databases into graphical representations and build multiple models in one workspace to illustrate different model objects within a single diagram. Seamlessly align your model design with the actual database to maintain the integrity of the model. Simplify the navigation and comprehension of complex systems.
BI
Create visual representations of large data sets to unearth patterns, trends and relationships among data, and present your findings in dashboard for sharing. In a dashboard, all charts linked to the same data source are interconnected, allowing any actions performed on the charts to instantly update and reflect your selections.
Import / Export
Import data into a database from various formats, or through an ODBC connection after setting up a data source connection. Seamlessly export data from tables, collections, views, or query results to popular formats such as Excel, Access, CSV and more.
Data Generator
Provide a comprehensive range of functions to generate a large volume of quality testing data. You can rapidly create realistic data sets with referential integrity based on business rules and constraints.
Collaboration
Synchronize your connection settings, queries, snippets, model workspaces, BI workspaces and virtual group information to the cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere.
Other useful features:
- Data dictionary
- Navicat URI
- ER diagram view
- Table/collection profile
- Text, hex, image, web or BFile viewer and editor
- Object filter
- Query pinned result
- SQL beautifier
- Debugger for Oracle and PostgreSQL
- Connection coloring
- Virtual grouping
- Backup and restore
- Aggregation pipeline for MongoDB
- Schema analysis for MongoDB
- Tree View and JSON View for MongoDB
- Pub/Sub for Redis
- Automation
- User privilege manager
- Server monitor
- Command monitor
- Focus mode
- Dark mode
Note: Try Navicat free for 14 days. This trial subscription includes full access to the Navicat app. Your trial will turn into a paid subscription automatically after the free trial ends. If you don't want to renew it, cancel it at least 24 hours before the end of your trial.
Terms of Use: https://www.navicat.com/manual/online_manual/en/navicat_17/mac_manual/#/license_agree