Navicat

The main target of the initial version was to simplify the management of MySQL installations. In 2008, Navicat for MySQL was the winner of the Hong Kong ICT 2008 Award of the Year, Best Business Grand Award and Best Business (Product) Gold Award.{{cite web|publisher=Hong Kong Computer Society|title=Best Business Grand Award: PremiumSoft CyberTech Ltd. Navicat for MySQL|date=2008|url=http://www.hkictawards.hk/news.asp?menuid=10034&supmenuid=10022|accessdate=2014-12-01|url-status=dead|archiveurl=https://web.archive.org/web/20141123233446/http://www.hkictawards.hk/news.asp?menuid=10034&supmenuid=10022|archivedate=2014-11-23}}

Navicat is a cross-platform tool and works on Microsoft Windows, Mac OS X and Linux platforms. Upon purchase, users are able to select a language for the software from 13 available languages: English, French, German, Spanish, Japanese, Polish, Russian, Korean, Indonesian, Thai, Malay, Simplified Chinese and Traditional Chinese.

Officially released in March 2002, the Windows version of Navicat for MySQL became the first product offered to the public by PremiumSoft. Subsequently, the company released two additional versions of Navicat for MySQL on the Mac OS X and Linux operating system in June and October 2003 respectively. In November 2013, added the support of MariaDB.{{cite web|publisher=Navicat|title=Navicat for MySQL release notes|date=2002{{ndash}}14|url=https://www.navicat.com/en/products/navicat-for-mysql-release-note|accessdate=2014-12-01}}{{cite web|accessdate=2014-12-01|publisher=Techmixer|title=NaviCat MySQL – MySQL Database Management Tools For Windows|date=2009|url=http://www.techmixer.com/navicat-mysql-mysql-database-management-tools-for-windows}} PremiumSoft continued to expand their Navicat series by releasing Navicat for PostgreSQL for Windows in October 2005 and then for Mac OS X in June 2006. The Linux version of Navicat for PostgreSQL would not be released until 3 years later in August 2009.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for PostgreSQL release notes|date=2008{{ndash}}14|url=https://navicat.com/en/products/navicat-for-postgresql-release-note}} In August 2008 Navicat decided to further continue their product line and branch out into the Oracle community, creating Navicat for Oracle for Windows and Mac. In August of the following year they followed up with a version for the Linux Platform.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for Oracle release notes|date=2008{{ndash}}14|url=https://navicat.com/en/products/navicat-for-oracle-release-note}} The Oracle version of Navicat supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for Oracle overview|url=https://navicat.com/en/products/navicat-for-oracle}}{{cite web|accessdate=2014-12-01|publisher=Techmixer|title=Navicat for Oracle – Oracle Administration Tools For Windows And Mac|date=31 March 2009 |url=http://www.techmixer.com/navicat-for-oracle-windows-oracle-administration-tools}} Navicat for SQLite was released for Windows and Mac OS X simultaneously in April 2009, and the Linux version soon followed two months later in June of the same year.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for SQLite release notes|date=2010{{ndash}}14|url=https://www.navicat.com/products/navicat-for-sqlite-release-note}} In April 2010, Navicat Premium began including Navicat for SQLite starting from version 9 to expand the usability of Navicat Premium.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat Premium release notes|date=2009{{ndash}}14|url=https://www.navicat.com/en/products/navicat-premium-release-note}} Navicat for SQL Server was released in November 2010 for the Windows platform and Mac OS X. Also at the release, the SQL server version was included in the Premium version of Navicat. In January 2011, support for SQL Azure was added.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for SQL server overview|url=https://navicat.com/en/products/navicat-for-sqlserver}} Navicat for MariaDB was released in November 2013 for Windows, Mac OS X and Linux. Also at the release, the MariaDB version was included in both Navicat Premium and Navicat for MySQL.

In 2018, Navicat started to support NoSQL databases. MongoDB is currently the newest addition to the list of server Navicat supports. The new line of product, called Navicat for MongoDB, was released in July 2018 for Windows, Mac OS X and Linux. It provides a native environment for MongoDB management and supports the extra features like MapReduce, GridFS Buckets. Also at the release, the MongoDB version was included in Navicat Premium.

In May 2023, Navicat for Redis was released. It provides key-value data viewer, Pub/Sub feature, Command Monitor, Backup & Restore etc.

Navicat for Snowflake was officially released in March 2025. This version brings enhanced features tailored specifically for managing Snowflake databases, including advanced query building, intuitive data visualization, and seamless data migration tools.

In 2009, PremiumSoft released Navicat Premium, a series of Navicat software that combines all previous Navicat versions into a single version and can connect to different database types including MySQL, Oracle, and PostgreSQL simultaneously, allowing users to do data migration between cross databases. Navicat Premium version also supports cross-platform administration, serving Windows, Mac OS X and Linux. In April 2010, version 9 of Navicat Premium was released, which added the connectivity of SQLite database to Navicat Premium, allowing Navicat Premium to connect to MySQL, Oracle, PostgreSQL and SQLite in a single application. In November 2010, support for Microsoft SQL Server was added. In January 2011, SQL Azure was included. In November 2013, added the support of MariaDB.{{cite web|accessdate=2014-12-01|publisher=Techmixer|title=Navicat Premium – Cross Database Administrator Management Tool|date=6 September 2009 |url=http://www.techmixer.com/navicat-premium-cross-database-administrator-management-tool}} In July 2018, support for MongoDB was added to Navicat, enhancing its capabilities for managing NoSQL databases. In May 2023, Redis was introduced in Navicat Premium 16.2, further broadening the tool's database management options. The following year, in May 2024, version 17 was released, featuring new enhancements such as Visual Explain, Data Dictionary, and Data Profiling. In March 2025, support for Snowflake was also integrated, providing users with robust tools for managing cloud-based data solutions. Additionally, new AI features were introduced to enhance query writing, data analysis and streamline workflows.

Navicat Data Modeler Windows version was officially released in March 2012. Then, Mac OS X and Linux version were released in May 2012 and June 2012. This is a standalone product for developers to create data models for MySQL, SQL Server, Oracle, PostgreSQL and SQLite databases. Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc. In June 2015, added the support of MariaDB databases and several features such as Model Conversion, Physical/Logical/Conceptual model types and Navicat Cloud. In May 2024, version 4 was released, and added the support of MongoDB and several features such as synchronizing database to model, comparing model workspace. In March 2025, support for Snowflake was introduced, along with new modeling methods, including Data Vault 2.0 and Dimensional modeling techniques, providing users with advanced tools for effective data structure organization and analysis.

In August 2013, PremiumSoft released a new product - Navicat iOS.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat iOS|url=https://www.navicat.com/en/products}} It is a database administration tool developed for iOS with features included object viewer & designer, query builder & editor, Navicat Cloud,{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat Cloud|url=https://www.navicat.com/en/navicat-cloud}} server monitor, etc. MySQL was supported in the first release. Then, Navicat for PostgreSQL iOS version was released in January 2015. In September 2017, Navicat for MariaDB iOS version was released.

Navicat Cloud is a cloud service for users to synchronize their connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information with multiple platforms and devices. A user can share his project to others for collaborating on connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information.

Navicat Monitor was officially released in April 2018. It is a safe, simple and agentless remote server monitoring tool and supports to monitor MySQL, MariaDB and cloud databases. Users can access Navicat Monitor from anywhere via a web browser. The main features of Navicat Monitor including real-time instance performance monitoring, alert notification, query analyzer, replications monitoring.

In June 2019, Navicat Monitor supported monitoring SQL Server instances. And PostgreSQL was added in February 2023.

Navicat On-Prem Server is an on-premise solution that provides the option to host a cloud environment for storing Navicat objects (connection settings, queries, aggregation pipelines, snippets, model workspaces, BI workspaces and virtual group information) internally at user's location.

In Nov 2021, 2 new products, Navicat Charts Creator & Navicat Charts Viewer were released. Navicat Charts Creator is a GUI tool for creating visual representations (charts & dashboards) of database data. Navicat Charts Viewer is a tool for viewing charts workspace files. In May 2024, version 2 was released and added the support of MongoDB and Snowflake. The product names were changed to Navicat BI and Navicat BI Viewer.

Navicat's features include:

• SSH and HTTP tunneling
• object designer
• visual query-builder
• code snippet and code completion
• visual explain
• AI assistant
• data and structure synchronization
• data transfer
• import and export data
• backup and restore data
• BI (charts & dashboard)
• data modeling
• data profiling
• data generation
• data dictionary
• task scheduling and wizards tool

There are differences in the features available across operating systems.{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for MySQL Feature Matrix|url=https://www.navicat.com/products/navicat-for-mysql-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for MariaDB Feature Matrix|url=https://www.navicat.com/products/navicat-for-mariadb-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for PostgreSQL Feature Matrix|url=https://www.navicat.com/products/navicat-for-postgresql-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for Oracle Feature Matrix|url=https://www.navicat.com/products/navicat-for-oracle-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for SQLite Feature Matrix|url=https://www.navicat.com/products/navicat-for-sqlite-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for SQL Server Feature Matrix|url=https://www.navicat.com/products/navicat-for-sqlserver-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for MongoDB Feature Matrix|url=https://www.navicat.com/products/navicat-for-mongodb-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat for Redis Feature Matrix|url=https://www.navicat.com/products/navicat-for-redis-feature-matrix}}{{cite web|accessdate=2014-12-01|publisher=Navicat|title=Navicat Premium Feature Matrix|url=https://www.navicat.com/products/navicat-premium-feature-matrix}}

Navicat is also compatible with forks of MySQL such as Drizzle, OurDelta, and Percona.

Navicat supports Cloud Databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud, Google Cloud and Alibaba Cloud.

• Comparison of database tools

• {{Official website|https://www.navicat.com/}}

{{MySQL}}

Category:MySQL

Category:PostgreSQL

Category:Database administration tools

Category:Data modeling tools

Category:Software companies of Hong Kong

Category:Oracle database tools

Category:Microsoft database software

Category:MariaDB