It helps you to quickly manage your databases edit tables!

Navicat Premium (32-bit)

Navicat Premium (32-bit)

  -  88.6 MB  -  Trial
Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, and Huawei Cloud. You can quickly and easily build, manage, and maintain your databases.

Features and Highlights

Seamless Data Migration
Data Transfer, Data Synchronization, and Structure Synchronization helps you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables/collections, views, or query results to formats such as Excel, Access, CSV, and more. Add, modify, and delete records with built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

Easy SQL/Query Editing
Visual SQL/Query Builder will help you create, edit, and run SQL statements/queries without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using debugging components such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

Intelligent Database Designer
Create, modify, and manage all database objects using professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.

Increase Your Productivity
Powerful local backup/restore solution and intuitive GUI for MongoDBDump, Oracle Data Pump, and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow, and set an automation for repeatable deployment processes like report generation, database backup, MapReduce job, and script execution at a specific time or day. No matter where you are, you can always get the job done.

Make Collaboration Easy
Synchronize your connection settings, models, queries, and virtual groups to the app Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.

Smart Schema Analyzer
Discover and explore your MongoDB schema with a built-in schema visualization tool. Analyze your documents and displays rich structures within your collections, so you can understand your data’s schema, find schema anomalies, and inspect outliers easily.

Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat Premium provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Note: 14 days trial version.

Also Available: Navicat Premium (64-bit) and Navicat Premium for Mac

  • Navicat Premium 16.3.9 (32-bit) Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    Navicat Premium 16.3.9 (32-bit) Screenshot 1
  • Navicat Premium 16.3.9 (32-bit) Screenshot 2
  • Navicat Premium 16.3.9 (32-bit) Screenshot 3
  • Navicat Premium 16.3.9 (32-bit) Screenshot 4
  • Navicat Premium 16.3.9 (32-bit) Screenshot 5

What's new in this version:

Navicat Premium 16.3.9 (32-bit)
Fixed:
- Incorrect SQL format when dumping Mariadb table
- Syntax error occurred when transferring tables with escape characters
- Unable to show data in some cases
- Unable to connect Azure CosmosDB using SSH tunnel
- Unable to connect PostgreSQL in some cases
- Minor bug fixes and improvements


Navicat Premium 16.3.8 (32-bit)
Fixed:
- Crashed when PostgreSQL connection was lost
- Primary key index incorrectly displayed when data type was citext
- Minor bug fixes and improvements


Navicat Premium 16.3.7 (32-bit)
Fixed:
- Importing data to Redshift was slow
- Crashed when importing paradox files
- Failed to import JSON file from web service
- Unable to transfer data from Redshift
- Refresh button did not work in Server Monitor
- Some labels disappeared after adding the chart to the dashboard
- Unable to display proportion percentages in the chart axis
- Minor bug fixes and improvements


Navicat Premium 16.3.5 (32-bit)
Improved:
- Support multi-host for GaussDB Centralized

Fixed:
- The percentage values shown in the chart were incorrect
- Not all data was imported when scheduling import
- Unknown Internal Error occurred when importing data
- Code Completion did not work properly in SQL Server queries
- The comment code shortcut did not work in some cases
- Unknown Internal Error occurred when transferring data
- Minor bug fixes and improvements


Navicat Premium 16.3.3 (32-bit)
Improved:
- Support Huawei Cloud GaussDB Distributed
- Support enabling or disabling "Detect Data Types" in Import Wizard
- Support ssh agent using pageant unix mode

Fixed:
- Primary keys were not displayed for PostgreSQL partitioned tables
- Minor bug fixes and improvements


Navicat Premium 16.3.2 (32-bit)
- Unable to show the privileges of "public" in PostgreSQL Privilege Manager
- Minor bug fixes and improvements


Navicat Premium 16.3.0 (32-bit)
Improved:
- Support Redis Cluster
- Support MongoDB Time-Series Collection
- Support setting MySQL descending primary key

Fixed:
- Naming issue in the Foreign Keys tab of SQL Server Table Designer
- Minor bug fixes and improvements


Navicat Premium 16.2.11 (32-bit)
Fixed:
- Crashed when opening Charts workspaces in some cases
- "The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values." error occurred when importing data to SQL Server.
- Unable to show all documents in Serverless MongoDB Atlas
- Missing parameters when transferring MariaDB Functions
- Crashed when scheduling import jobs
- 1064 error occurred when running query to create stored procedure in some cases
- Missing records when importing files in some cases
- Special characters were garbled when using double-click to add a snippet to the query
- Minor bug fixes and improvements


Navicat Premium 16.2.10 (32-bit)
Fixed:
- Crashed when importing Access files
- Minor bug fixes and improvements


Navicat Premium 16.2.8 (32-bit)
Improvements:
- Support Huawei Cloud GaussDB Centralized
- Auto guess field types when importing xlsx files

Fixed:
- Beautify SQL incorrectly added spaces between the function name and parentheses
- Unable connect to MySQL via SSH tunnel in some cases
- Dump SQL File did not correctly generate DEFAULT PARTITION
- "Parameters supplied for object 'xxx' which is not a function" error occurred when adding record in some cases
- Minor bug fixes and improvements


Navicat Premium 16.2.7 (32-bit)
Fixed:
- Incorrectly triggering code completion when pressing ENTER in Query Editor
- Minor bug fixes and improvements


Navicat Premium 16.2.6 (32-bit)
Improved:
- Support JSON key type for Redis

Fixed:
- Unable to close tabs in some cases
- Slashes () were removed from triggers when synchronizing MariaDB structures
- Minor bug fixes and improvements


Navicat Premium 16.2.5 (32-bit)
Fixed:
- "Implicit conversion from data type" error occurred when synchronizing SQL Server data.
- The default directory of new SQL Server database was incorrect.
- Unknown Internal Error occurred when connecting to Redis.
- Cannot type a new name for the table in Import Wizard.
- Minor bug fixes and improvements.


Navicat Premium 16.2.3 (32-bit)
Fixed:
- Expressions for virtual columns were truncated
- Unable to display SQLite BLOB data
- Minor bug fixes and improvements


Navicat Premium 16.2.2 (32-bit)
Improved:
- Support unix socket forwarding in SSH

Fixed:
- Unable to connect SQL Server using the Encrypted option
- Minor bug fixes and improvements


Navicat Premium 16.2.1 (32-bit)
- Support Redis connections
- View, edit, search and sort Redis keys and data with Data View
- Capture and analyze Redis Pub/Sub messages in real-time
- Support local backup and restore of Redis databases
- Intuitive interface for editing Redis users and ACLs
- Redis Console with syntax highlight and code completion
- Well-formatted Redis query results
- Automate Redis backup and query execution
- Command Monitor and Server Monitor for real-time monitoring of Redis
- Support sequence design for MariaDB
- Show fields, indexes and more under tables in Navigation Pane
- Minor bug fixes and improvements
- Navicat for Redis is released


Navicat Premium 16.1.15 (32-bit)
Fixed:
- High CPU usage when using SSH connection
- "permission denied for view geometry_columns" error occurred when opening PostgreSQL table
- Minor bug fixes and improvements


Navicat Premium 16.1.12 (32-bit)
Fixed:
- Unable to Import MySQL Longtext data to SQL Server
- Query Builder window was larger than the screen in some cases
- Unable to display full server output in Query's Message tab
- Unknown Internal Error occurred when clicking the last page button in MongoDB query results
- Modifying PostgreSQL table with a geometry field and no primary key did not take effect
- Unable to display the data differences of TEXT fields in Data Synchronization
- The second field was selected when adding a sort condition in Table Viewer
- Crashed when stopping Data Transfer process
- Minor bug fixes and improvements


Navicat Premium 16.1.11 (32-bit)
- Minor bug fixes and improvements


Navicat Premium 16.1.9 (32-bit)
Improvements:
- Support OceanBase Oracle Mode

Fixed:
- Memory utilization issue
- Modification did not take effect on tables with geometry fields and no primary key
- Table Viewer did not show the SQL if errors occurred
- Minor bug fixes and improvements


Navicat Premium 16.1.8 (32-bit)
- Unable to save changes after deleting a cell value in Table Viewer
- Access violation error occurred when opening a model
- Minor bug fixes and improvements


Navicat Premium 16.1.7 (32-bit)
Improved:
- Support MariaDB UUID type
- Support the PARALLEL option for PostgreSQL functions

Fixed:
- Cannot display column comment when mouse over in dark mode
- "Default or null are not allowed as explicit identity values" error occurred when inserting a row in SQL Server table
- Missing $$ quotes in PostgreSQL function definition
- Cannot delete document after clicking the last page button
- Data Synchronization did not work in Automation
- "Failed to send mail. Stream error." occurred when sending email
- Minor bug fixes and improvements


Navicat Premium 16.1.6 (32-bit)
Fixed:
- Unable to list tables or views in Azure SQL Database connection
- "Cannot open source table" error occurred when using Condition Query in Import Wizard
- Exporting to Excel file was slow
- Minor bug fixes and improvements


Navicat Premium 16.1.4 (32-bit)
Fixed:
- 1267 error occurred when clicking the "Users" button
- Unable to connect Azure Database for PostgreSQL with Azure Active Directory Authentication
- Bar chart label display issue
- Unable to export Excel file in some cases
- Hanged when transferring tables
- Unable to connect CockroachDB Serverless
- Minor bug fixes and improvements


Navicat Premium 16.1.3 (32-bit)
Fixed:
- Unable to connect server using HTTP tunnel in some cases
- Font size issue in Form View
- Unknown Internal Error occurred when adding records in SQL Server Views
- Field size was not retained in SQLite table designer
- Buttons in the lower right corner of the main window were missing in some cases
- Minor bug fixes and improvements


Navicat Premium 16.1.2 (32-bit)
- Crashed when changing the chart type in some cases
- Hanged when deleting a table in Query Builder
- Text color issue in Dark Mode
- Unable to generate CREATE PROCEDURE SQL in Data Transfer
- Dump Script File feature generated an invalid JSON
- Unable to connect AWS RDS database via SSH
- Backup and Dump SQL File was slow in some cases
- Minor bug fixes and improvements


Navicat Premium 16.1.1 (32-bit)
Fixed:
- Unable to open the objects in the "Find in Database" window
- The first number of every value in the list was removed in the table filter
- Unknown Internal Error occurred when updating query results in some cases
- Unable to use "Copy As" in View results
- Crashed when opening functions in some cases
- Unknown Internal Error occurred when foreign key selection window popped up
- Unable to open schema in Azure SQL
- Crashed when clicking on the value box in table filter
- Decimal separator issue in SQLite
- Cannot retain the window size and position for existing objects
- Minor bug fixes and improvements


Navicat Premium 16.1.0 (32-bit)
Main New Features:
- Support OceanBase Community Edition
- Support Trend Line for several chart types
- Support adding On-Prem Server with URI
- Allow skip preview of changes in data sync
- Enhanced responsiveness and performance
- Improved UI/UX
- Minor bug fixes and improvements


Navicat Premium 16.0.14 (32-bit)
Fixed:
- Query parameters did not work in some cases
- Unable to synchronize PostgreSQL data in some cases
- Decimal precision issue when importing from Excel files
- Minor bug fixes and improvements


Navicat Premium 16.0.12 (32-bit)
Fixed:
- Wrong time zone was added to TIMESTAMP field when exporting CSV file
- Extra commas were added to the script in Structure Synchronization
- Unknown Internal Error occurred when exporting large amount of data
- Unable to sign in Subscription plan
- Minor bug fixes and improvements


Navicat Premium 16.0.11 (32-bit)
Fixed:
- Crashed when running Automation in some cases
- Missing the first record when import
- Unable to locate project when running batch job
- Unable to get table information when scheduling data synchronization
- Refresh button ran all SQLs in Query Editor
- .0000 data export issue
- Function execution message log issue
- Access Violation error occurred when removing default value
- Navicat exited when clicking the Type column in Table Designer
- Crashed when batch querying tables with FK dependency
- Minor bug fixes and improvements


Navicat Premium 16.0.10 (32-bit)
- Change log not available for this version


Navicat Premium 16.0.9 (32-bit)
Fixed:
- The "Compare" button did not work in Data Synchronization in some cases
- "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters
- Minor bug fixes and improvements


Navicat Premium 16.0.7 (32-bit)
Fixed:
- Unable to show data when using HTTP tunnel
- Unable to show utf8mb4 data
- Minor bug fixes and improvements


Navicat Premium 16.0.5 (32-bit)
Fixed:
- Connection encoding issue in Navicat Cloud
- Connection password issue when updating connection in Navicat Cloud
- Error occurred when synchronizing to Navicat Cloud
- Unknown Internal Error occurred when designing PostgreSQL table
- Minor bug fixes and improvements


Navicat Premium 16.0.4 (32-bit)
Fixed:
- Syntax error occurred when importing data to MySQL table
- Notification Email authentication failed in some cases
- Minor bug fixes and improvements


Navicat Premium 15.0.27 (32-bit)
Fixed:
- Double foreign key lines were printed when exporting a model to a PDF file
- Access violation error occurred when searching in the Backup's Object Selection tab
- No data value on the label when exporting a chart to a PDF file
- Unable to synchronize decimal precision from a model to SQL Server database
- Unable to rename a view inside a group in Navicat Cloud
- Cannot connect to Microsoft Azure Database in some cases
- Minor bug fixes and improvements


Navicat Premium 15.0.26 (32-bit)
Improvements:
- Support Retryable Writes and Retryable Reads for MongoDB
- Support tunneling on PHP 8

Bug fixes:
- Unable to show accurate value of Oracle BINARY_DOUBLE type
- Unknown Internal Error occurred when importing Excel file in some cases
- Wrong SQL generated when comparing SQL Server tables with different constraint names
- An empty string was not quoted when exporting to a text file
- Query was garbled when the system locale set to Japanese
- Export/Import profile did not work if it was copied to Desktop
- Minor bug fixes and improvements


Navicat Premium 15.0.25 (32-bit)
Bug fixes:
- Empty rows were added when exporting more than 1.05 M records to Excel file
- Unable to rename Oracle views when the "Use custom database list" option is enabled
- Error occurred when using Recordset Generator to generate a record set for the Date field
- Hanged when designing a table with many fields
- Error occurred when copying tables from one SQLite database to another
- Unable to display the definition of SQLite View in some cases
- Relation lines were disappeared after saving and reopening Logical Model
- Minor bug fixes and improvements


Navicat Premium 15.0.23 (32-bit)
Fixed:
- Unable to exclude collations when synchronizing a model to a database
- Functions were not properly saved as the default value in MariaDB
- ER diagram was reloaded when clicking the Design Table button
- Unable to toggle "Virtual Type" in an existing table
- Error 1227 occurred when creating or designing a table
- Minor bug fixes and improvements


Navicat Premium 15.0.22 (32-bit)
- Change log not available for this version


Navicat Premium 15.0.21 (32-bit)
Bug-fixes:
- Queries cannot be displayed when "Settings Location" was set to a network path
- Error 80041318 occurred when setting schedule
- Minor bug fixes and improvements


Navicat Premium 15.0.20 (32-bit)
Bug-fixes:
- Slow response when querying the full collection count
- Flashed in dark mode
- "Unallowed argument in list..." error when running export / import schedule
- Error occurred when modifying the value in a DateTimeOffset field
- Unable to load version 10 data synchronization profiles
- Differences were incorrectly detected in Synchronize to Database
- Minor bug fixes and improvements


Navicat Premium 15.0.19 (32-bit)
- Change log not available for this version


Navicat Premium 15.0.18 (32-bit)
Bug-fixes:
- "IDENTITY_INSERT is already ON" error occurred when synchronizing SQL Server tables
- Unable to show records that had -1 data in Table Viewer
- "Drop target objects before create" option did not work in Data Transfer
- Memory leak issue when enabled code completion
- "Relation does not exist" error occurred when debugging a function in a schema other than the "public" schema
- "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data
- Slow issue when transferring large tables
- Unable to show the inputted text in Filter Wizard
- Error occurred when filtering data by right-clicking a cell in Table Viewer
- "Cannot insert into column" error occurred when transferring PostgreSQL tables
- Inserted records to the wrong table when transferring data to the target table with a different name
- "Debugger Plugin is not installed or enabled" error occurred when the extension was installed in another schema
- Unable to connect MySQL server when using TLSv1.2
- "COMMENT ON FUNCTION" clause was mistakenly generated when synchronizing PostgreSQL procedures
- Minor bug fixes and improvements


Navicat Premium 15.0.17 (32-bit)
- Change log not available for this version


Navicat Premium 15.0.16 (32-bit)
Improvements:
- Support Active Directory authentication method for SQL Server
- Integer column exported in Number format when exporting Excel file
- Display export profiles in the same group of queries

Bug-fixes:
- The fields of PostgreSQL compound index were displayed incorrectly
- Unable to show index fields in PostgreSQL 9.0
- Unable to set data to NULL in query results
- Crashed when clicking the ellipsis button in Custom Recordset
- Pasting data into a column cleared another column data
- Default Settings Location path was set to a wrong location for some cases
- "Floating point division by zero" error occurred when setting the dashboard background
- The file extension was missing when exporting the dashboard
- Query Parameter did not work when using a parameter twice
- "Invalid floating point operation" error occurred when adding NULL data to the chart
- Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
- Minor bug fixes and improvements


Navicat Premium 15.0.14 (32-bit)
Bug fixes:
- Unable to set the identity seed and increment in PostgreSQL models
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- Unable to set SET IDENTITY_INSERT ON in Data Synchronization
- Unable to export data to .mdb files
- Minor bug fixes and improvements


Navicat Premium 15.0.13 (32-bit)
Bug-fixes:
- MySQL table row format reverted to Compact after editing
- Unknown Internal error occurred when opening Oracle tables
- Syntax error occurred when creating events
- Unable to set default value for fields in Table Designer
- Unable to show SUPER privilege for MariaDB 10.4 in the user object list
- Foreign key was dropped and added when re-comparing the model
- Data Pump Import's Table Exists Action drop-down list options were incorrect
- Minor bug fixes and improvements


Navicat Premium 15.0.12 (32-bit)
Bug fixes:
- Incorrect SQL generated when transferring Oracle tables
- Invalid XML error occurred when importing connections
- Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database
- Incorrect data was updated when saving ; in a non-text field
- Unable to import data to PostgreSQL array fields
- Incorrect SQL generated for altering fields in Structure Synchronization
- Incorrect items were displayed in suggestion list when using code completion with alias
- Incorrect SQL generated when enabling "On Update Current_timestamp" in Table Designer
- Minor bug fixes and improvements


Navicat Premium 15.0.11 (32-bit)
Bug fixes:
- Query wrongly returned null results in some cases
- "," was replaced by "." when using Custom Filter in Table Viewer
- Relation attributes were wrong after reopening the logical model
- Minor bug fixes and improvements


Navicat Premium 15.0.9 (32-bit)
Bug fixes:
- Only the first batch was transferred when "Number of row per batch" was enabled
- Minor bug fixes and improvements


Navicat Premium 15.0.8 (32-bit)
Improvements:
- Added "Keep Orthogonal Layout" to Model

Bug fixes:
- Unable to update bit type data
- Minor bug fixes and improvements


Navicat Premium 15.0.7 (32-bit)
Bug fixes:
- The "Others" button was missing for PostgreSQL, Oracle and SQL Server connections


Navicat Premium 15.0.6 (32-bit)
Improvements:
- Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor

Bug fixes:
- "Unknown Internal Error" occurred when modeling databases
- Find bar UI issue in Data Viewer
- Unable to print table when using popup menu on Navigation pane
- Syntax error occurred when renaming index in MariaDB table
- Explain feature did not work with query parameters
- Interval type was not supported in Charts
- Highlight color issue in Filter wizard when using Dark mode
- Minor bug fixes and improvements


Navicat Premium 15.0.5 (32-bit)
Bug fixes:
- OCI Environment setting was unable to save
- "Invalid floating point operation" error occurred when resizing tables in View Builder
- Multiple primary key names were generated when exporting model to SQL files
- int8 type was converted to int8(255) when synchronizing model to PostgreSQL server
- Syntax error occurred when connecting to MySQL 4
- Minor bug fixes and improvements


Navicat Premium 15.0.4 (32-bit)
Bug fixes:
- Access violation error occurred when adding users to Navicat Cloud project
- Access Denied error occurred when designing table
- Unable to highlight field when typing in Filter's field selection list
- Wrong fields are exported to the SQL file when not all fields are selected
- Dark theme kept reverting back to Normal theme
- Wrong CREATE INDEX was generated in Model
- MySQL JSON data was truncated in Table Viewer
- Empty value was exported as **** when exporting DBF file
- Data Transfer high memory consumption issue
- Unable to connect Azure Database for MariaDB
- Run queries slow issue
- Unable to set Numeric field without precision in PostgreSQL server
- "List index out of bounds (-1)" error occurred when editing role privileges
- "Last Tab Window" option was missing


Navicat Premium 15.0.3 (32-bit)
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements