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 and Google Cloud, and all PostgreSQL database objects.

Windows
macOS
iOS
1
2
3
4
5
6
7
8
9
10

Main Screen

Intuitive and well-designed GUI simplifies your database administration and development.

Object Designer

Manage all the database objects with smart object designer.

Data Manipulation

Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.

Modeling

Visualize and edit your databases using a sophisticated database design and modeling tool.

Data Synchronization

Compare and sync data between databases/schemas with a detailed analytical process.

Structure Synchronization

Deliver a full picture of database differences, and generate script to update the destination database.

Code Completion

Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.

Code Snippet

Insert a snippet into the SQL Editor for faster and error-free SQL writing.

Automation

Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.

Navicat Cloud

Store your files in cloud to start collaboration with your team members.

Features

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

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, views, or query results to formats like Excel, Access, CSV and more. Add, modify, 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.

Easy SQL Editing

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

Intelligent Database Designer

Create, modify and manage all database objects using our 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

Our powerful local backup/restore solution 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 process like report generation, database backup, 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 our Navicat 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. Learn more >

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

1
2
3
4
5
6
7
8
9
10

Main Screen

Intuitive and well-designed GUI simplifies your database administration and development.

Object Designer

Manage all the database objects with smart object designer.

Data Manipulation

Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.

Modeling

Visualize and edit your databases using a sophisticated database design and modeling tool.

Data Synchronization

Compare and sync data between databases/schemas with a detailed analytical process.

Structure Synchronization

Deliver a full picture of database differences, and generate script to update the destination database.

Code Completion

Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.

Code Snippet

Insert a snippet into the SQL Editor for faster and error-free SQL writing.

Automation

Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.

Navicat Cloud

Store your files in cloud to start collaboration with your team members.

Features

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

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, views, or query results to formats like Excel, Access, CSV and more. Add, modify, 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.

Easy SQL Editing

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

Intelligent Database Designer

Create, modify and manage all database objects using our 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

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.

Make Collaboration Easy

Synchronize your connection settings, models, queries and virtual groups to our Navicat 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. Learn more >

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

System Requirements

Windows

Microsoft Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008, Server 2008 R2, Server 2012, Server 2016

macOS

Mac OS X 10.10 Yosemite, Mac OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra

Linux

Ubuntu 12.04, Ubuntu 14.04, CentOS 6.7, CentOS 7, Fedora 22, Fedora 23, Linux Mint 13, Linux Mint 17.3, openSUSE 13.2, openSUSE 42.1

Navicat Cloud

Navicat provides users with our Navicat Cloud service. Sync your connection settings and queries to the cloud so you can get real-time queries and connections anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more ›

Secure Connection

Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair. Navicat also comes with HTTP Tunneling, allowing you to bypass ISP restrictions on direct database server connections.

Object Designer

Create, modify, and design database objects using professional object designers, available for all database objects such as Tables, Views, Functions, and Triggers. Without the need to write complex SQL to create and edit objects, you’ll know exactly what you are working on.

Table Viewer

Grid View

Add, modify, and delete records using Grid View. Navigate the Grid View with spreadsheet-like features, such as sorting and searching, or use our assistant editors like memos, images, and more.

Foreign Key Data Selection

Use foreign key relationships in your database to anchor referenced lookup tables and automatically create dropdown lists. Without the need to constantly reference a master table, you can optimize your workflow and productivity.

SQL Builder/Editor

SQL Builder

SQL Builder allows you to create and edit queries/views without having to worry about syntax and proper usage of commands. Just choose the operation you would like to perform on the tables, and it will write the SQL statements for you.

Code Completion

Quickly construct SQL statements in the SQL Editor with our code completion feature. Whether you want to select properties of database objects or SQL keywords, all it takes is a pick from the suggestion list.

Useful Tools

Tree/Object Filter

Use the Tree/Object Filter to narrow the list of displayed database objects. Simply type in the text and only objects that start with the specified string are shown.

System Requirements
iOS

Compatibility: Requires iOS 7.0 or later. Compatible with iPhone, iPad, and iPod touch.
This app is optimised for iPhone 5, iPhone 5C, iPhone 5S, iPhone 6, iPhone 6 Plus, iPhone 6S, iPhone 6S Plus, iPhone 7, and iPhone 7 Plus.
Available Navicat for MySQL, Navicat for MariaDB and Navicat for PostgreSQL only.
(Other products are coming soon.)


Our Customers

  • “Navicat is strong in that function and it has a good query handling. Especially the query builder helps me to save time.

    Navicat has a good user interface and it has perfect multitasking usability.

    It helps very much for our department to generate new reports.”

    Karl Hogerl

    Internet & Database Service Engineer
    TOSHIBA Europe GmbH

    “Navicat is fabulous, fast, easy to use. It makes working with databases fun.

    It's much better than TOAD.

    My favourite features of Navicat are Backup, import/export, basic database functionality, including browsing tables, connections management, toolbar, subdivision of functions, user management, queries, performance.”

    Jan Theodore Galkowski

    MIT (Massachusetts Institute of Technology)

    “I have tried many other fine programs, but Navicat is by far the best. Ease of use and the list of features make it my choice for MySQL administration.”

    “Customer support for Navicat is very good. My email questions were quickly and accurately answered.”

    Jeff Tucker

    Director of Engineering
    Emmis Communications (NASDAQ: EMMS)

  • “Navicat save our time to manage our databases. The backup features and how simple it is to use cannot be compared. I recommend PremiumSoft Navicat to everyone I know. Keep up the great work guys!!!”

    Orlando Piedrahita

    System Engineer
    World Fuel Services Corporation (NYSE:INT)

    “I really like the new GUI in Navicat.

    The Speed of Navicat is very fast and its Interface is very nice. Stability has also been strengthened.”

    Karsten Torp Rasmussen

    Senior Consultant
    KPMG Advisory

    “It is an excellent tool that allows me to design all aspects of a MySQL DB's.

    The real values of Navicat are:
    - editing of tables in an Excel type fashion
    - import/export from/to many function
    - migration of DB's from one server to another”

    Proenen, Hanns

    General Electric (Capital Solutions GmbH & Co.KG)

  • “The main problem Navicat is solving for me is creating the queries in a fast.

    The query builder helps tremendously with that - and I haven’t seen any other tool that helps me create my queries for MySql. Navicat is pretty much self-explanatory.”

    Ed Garcia

    Yahoo! (NASDAQ: YHOO)

    “Very professional product. Easy to use. Nice GUI.

    We use Navicat to produce custom reports based on complex queries.”

    Jeff Gellner

    CISSP JPMorgan Chase & Co.

    “These are the features that we like :

    - It allows us to transfer file between two servers
    - It allows us to synchronize between two databases in a single and bidirectional directions
    - It allows us to build queries faster with query builder
    - It allows us import and export databases into different file formats
    It has a good online visual demo. The help file is also well organized and easy to follow.”

    Mark Horn

    Intel Corporation (Nasdaq:INTC)

  • “I worked since 2005 with this database tool. As interface to our MySQL severs I developed with Navicat many queries. The tables are partial very big (more than 50 Million records).

    With my favourite tool Navicat I create the queries fast and effective and with nightly schedules I get the query results on early morning. Also, your support worked quick and professional and now everything is alright.”

    Volker Plank

    Porsche Leipzig GmbH

    “Navicat is the only program I have seen that works this well on the Mac. Able to export and import easily. Very easy to use. Lightening fast. Scheduling, back-ups, Queries are all very easy to use. This does a lot more than what I expected.

    Didn't really need the documentation. Navicat was so well designed and user-friendly that I just started using it.”

    Scott Lozier

    Administrative Coordinator
    Office for the Arts at Harvard
    Harvard University

    “Navicat integrates managing MySQL database in a very user friendly interface. Updating without a UI from search table results. The database conversion from older formats to MySQL is seamless.

    It’s one tool solution for Designing, Managing and Automating MySQL. Transferring data from one server to other is very convenient. Backup and restoration DB in 1 easy step”

    Sandeep.Bishnoi

    Alcatel

  • “The clear and powerful GUI was leagues ahead of other solutions. Of particular importance to this choosing this solution was the strong CSV upload and export tools. It also proved really useful to be able to store queries and share them between users. The query builder was a big plus too.

    We’re really happy with Navicat and only wish that we’d chosen the product sooner.”

    Matt Fenby Taylor

    SonyBMG Music Entertainment Ltd.

    “Navicat provided a quick and easy means of importing many different spreadsheets into database tables and an easy way to update those tables. Even after weeks of having a standard process of managing the database we utilize Navicat's import mechanism to handle unique data updates coming from our customer. Without this ability we would be weeks behind schedule.”

    James Hoover

    Hewlett-Packard

    “Navicat allows the building of complex queries, and also management and backup of the database, from a remote windows environment. Navicat is relative ease of use, and flexibility.”

    Dr Richie Gill

    Oxford University

  • “Navicat makes the transfer between software engines extremely simple, better than the other options I explored. Also, the interface for dealing with the database is straightforward, easy to use, and powerful. It is convenient to use to begin to implement SQL code, for example”

    Dr Tim Walsh

    Research Foundation For Mental
    HygieneColumbia University

    “Navicat does an excellent job and as an added bonus, we can use the export function to convert data into other formats for specialized use. The XML conversion was particularly impressive.”

    Donald J. Varney

    Systems Developer III
    State of Vermont - Department of Banking,
    Insurance, Securities & Health Care Administration

    “Using Navicat, it is essentially a breeze to manage MySQL. It is going to save us tons of time and time is money!

    Navicat is easy to use because the menus and tools bars are very clearly label and designed. We have never had a problem with the software crashing or corrupting data.

    A GUI interface that provides complete functionality for configuring and using MySQL. What might take hours with the command line, Navicat can accomplish in seconds.”

    Dave Garcia

    Washington State University Student Publications

  • “Navicat is very important for us to manage our MySQL databases. It is quite easy to use and has very powerful features as, for instance, the query builder. The features we use most are the backup and queries, also in relation with the scheduler. A nice-to-have feature would be a mailer function where, for instance, a result of a query could be sent to a specific user.”

    Gilbert Schroeder

    Goodyear Luxembourg Tires SA.

    “I use Navicat to help with entry. There are approximately 2300 rows, and approx 123 columns for each row of data, it is used daily, I am currently trying to convince the office the benefits of using the MySQL/Navicat combination over other implementations.”

    “I enjoy your product very much, I purchased it, and Navicat increase productivity 1000 fold.”

    Jonathan Mark Petrush

    United States Marine Corps

    “I have used Navicat almost daily, and have recommended it to many others in my field. It is by far the best product of its kind on the market. And the price is much lower than I would have expected for such a robust feature rich product.”

    Jeff Austin

    Division of Biological Sciences, Office of the Dean
    University of California, Davis

  • “Most of our data is in Microsoft Access or MS SQL Server. With Navicat importing and exporting data from and to those formats is very easy and requires virtually no additional training. Moving to new technology is often intimidating to people but once I demonstrated Navicat to our staff they were pleasantly surprised. Navicat truly makes it easier to administer mySQL than any other product I have tried.”

    Matthew Ryan

    NCDA&CS Website Manager
    North Carolina Department of Agriculture & Consumer Services

    “Navicat is an excellent product and I have yet to look at the documentation!

    Navicat 's strengths are (obviously) its ease of setup and use. I've dealt with software since my junior year in high school (1981) and know a good product when I see one.”

    Jesse A. Canchola

    Principal Statistician Director, Data Analytic & Survey Services
    University of California at San Francisco

    “These are the strengths of Navicat --
    - Easy to manage multiple connections
    - Access to MySQL databases across the WAN is very quick and efficient compared to other products
    - Designing and updating table structures is much easier than comparable products
    - Provides an "easy to use" import and export wizard
    - User administration interface is excellent
    - Reporting tool looks promising”

    Larry Tomsic

    Director - Information Technology
    Alsco, Inc.

  • “Navicat did everything I needed it to do in a simplier way than by using text type tools. I purchased two copies so that we can use it with other Mysql databases that we want to deploy. The purchase was simple, and the product is now up and running. Since we need to develop additional databases, I am sure it will help us make that management much easier.”

    Doug Stoner

    Manager of Computer Services
    Conestoga Valley School District

    “Your product saved us a lot of time and solved my problem of importing and exporting the data to the tables and even creating Tables, Databases, and Queries. Now I do not have to worry about how to backup the Databases -its just one click now.”

    “It is so easy and simple for the Unix Administrator to connect to the local or remote Database and manage the users with full security. And I would like to thank your technical support staffs. They answered all my question in a short period of time.”

    Firas Najjar

    Web Application Developer at College of Engineering
    Florida State University

    “Navicat really helped easily get my excel data into mysql, and Navicat makes it easy to maintain using a GUI, rather than the line commands, or tedium of phpMyAdmin for multiple edits.

    I am sure Navicat will have more to offer, as my database matures. I can't comment on the documentation, because I've been able to figure out the few things I need to do just from the menus and icons on screen.”

    Charley Weiland

    Stanford University

Awards