Released in 2024 with build 3, Navicat for PostgreSQL v17.0.3 (x64) is the dedicated PostgreSQL administration and development tool from PremiumSoft, providing a powerful graphical interface for managing PostgreSQL servers from version 8.x to 17.x with advanced features for database design, query building, and data manipulation.
Key Highlights
- Full PostgreSQL Support – Complete management of tables, views, functions, triggers, indexes, schemas, extensions, and advanced objects like partitions and foreign data wrappers.
- Visual Query Builder – Drag-and-drop interface for building complex SQL queries with joins, subqueries, CTEs, and window functions without writing code.
- Data Synchronization & Transfer – Structure and data synchronization between PostgreSQL databases, import/export from CSV, Excel, JSON, XML, and direct server-to-server transfer.
- Powerful Data Editor – Inline grid editing with filtering, sorting, foreign key navigation, JSON viewer/editor, and geometry data support for PostGIS.
- ER Diagram Tool – Automatic reverse engineering of database structure into professional ER diagrams with forward engineering and synchronization capabilities.
- Backup & Restore Wizard – Automated backup scheduling, pg_dump integration, and point-in-time recovery for PostgreSQL instances.
- Performance & Stability – Optimized handling of large result sets, improved connection stability for cloud PostgreSQL services, and full Windows 11 compatibility.
System Requirements
- Windows 11 64-bit (or Windows 10)
- 8 GB RAM minimum (16 GB+ recommended)
- Integrated GPU sufficient
- NVMe SSD strongly advised