New Navicat 16 for PostgreSQL View larger

Navicat 16 for PostgreSQL

New product

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. From writing simple SQL queries to developing complex databases, Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote PostgreSQL servers and compatible with cloud databases like Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud and Microsoft Azure, and all PostgreSQL database objects.

Features

Data Viewer

View, update, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

Object Designer

Our Object Designer provides you easy and fast access for managing database objects. Navicat breaks down query writing into tabs through a convenient UI. Allow you to write complex SQL with greater confidence and accuracy at every step.

SQL Edit/ Debugger

Visual SQL Builder will help you create, edit and run SQL statements 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. Also, you can quickly locate and correct PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

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 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.

Model

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. Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click.

Charts

Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.

Import/Export

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, views, or query results to formats like 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.

Increase Productivity

Our powerful local backup/restore solution guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.

Collaboration

Synchronize your connection settings, queries, models, snippets, chart 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. Learn more >

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 GSSAPI authentication. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Dark Mode

Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

Cross-Platform Licensing

Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.