Databases & Storage

Navicat 18 for PostgreSQL adds AI-assisted schema design, data masking, and Parquet import

Key Takeaway

Navicat 18 for PostgreSQL introduces AI-powered table design and data population, real-time SQL error detection with refactoring tools, and built-in data masking for compliance-sensitive testing workflows.

Summary

PremiumSoft has released Navicat 18 for PostgreSQL, a major update to its proprietary database management GUI that targets both on-premises and cloud-hosted PostgreSQL deployments including Amazon RDS, Aurora, Redshift, Azure Database, Google Cloud SQL, and Fujitsu Enterprise Postgres. The release integrates generative AI directly into the Data Editor and Table Designer through "Fill with AI" and "Ask AI" features, which can generate column definitions, data types, and table summaries. The SQL Editor gains refactoring capabilities via Rename Symbol, real-time syntax error detection, and code navigation tools including Hover Info, Highlight Usages, and Go to Declaration.

For data governance, Navicat 18 adds Data Masking with Substitution, Variance, Shuffling, Hashing, and Nulling techniques to create realistic mock data from production records. The new Hybrid Model unifies logical and physical database design in a single workspace with naming standards enforcement and bulk editing. Business Intelligence dashboards now support auto-tiling, parameterized filtering, page navigation, and auto-refresh. Usability improvements include a redesigned Import Wizard with Parquet support and live preview, Batch Editing across record grids, and Personal Profile Sync to private cloud accounts for settings portability.

What changes in Navicat 18 for PostgreSQL

  • AI-assisted schema and data operations: Ask AI generates PostgreSQL table definitions including columns and data types, while Fill with AI populates, translates, and analyzes column contents; Fill with Comment auto-generates table summaries.
  • SQL Editor refactoring and static analysis: Rename Symbol refactoring preserves query dependencies during restructuring; Real-Time Error Detection continuously scans scripts for syntax flaws; Hover Info, Highlight Usages, and Go to Declaration provide IDE-style code navigation.
  • Data Masking engine: Implements Substitution, Variance, Shuffling, Hashing, and Nulling transformations to produce realistic mock datasets from sensitive production PostgreSQL records for compliant non-production use.
  • Hybrid Model workspace: Merges logical entity design with physical constraint management in a unified environment, with Naming Standards & Glossary enforcement and Bulk Editor for multi-table updates.
  • Import and grid enhancements: New Import Wizard adds Parquet file support with live preview panels; Batch Editing enables multi-record grid modifications; Record Navigation side panel replaces sequential clicking for tuple traversal.

Why it matters

While Navicat remains proprietary software, its deep PostgreSQL support across major cloud providers and its adoption of AI-assisted schema design and Parquet import reflects tooling trends that influence open-source GUI alternatives like pgAdmin, DBeaver, and Beekeeper Studio. The data masking and BI feature expansion also signals growing enterprise demand for compliance-ready PostgreSQL tooling that open-source projects may need to match for broader organizational adoption.

Original reference: www.postgresql.org →