Experience Navicat AI: Get 20% off your new perpetual license today.

Buy Now
More info
Data Masking > Learn More
Windows
macOS
Linux

Data Masking

Protect sensitive personal data and enforce strict privacy compliance across development, testing, and analytics workflows. Obfuscate confidential fields effortlessly without compromising data structure, referential integrity, or application usability.

Flexible Workflows & Smart Auto-Matching

Choose to transform data during cross-database transfers or mask existing tables directly. Navicat automatically evaluates column names, data types, and field lengths to intelligently assign appropriate default techniques across your schemas.

Comprehensive Object Support & Filtering

Mask data across tables, views, and materialized views, with options to convert views into masked target tables during transfer. Easily include associated database objects like functions and sequences, or target specific row subsets using custom SQL filters.

Multiple Masking Techniques

Choose from substitution, numeric/date variance, cryptographic hashing, shuffling, or nulling. Customize character rules, prefixes, and numeric ranges to fit your specific data requirements.

Live Side-by-Side Preview

Validate transformations before committing changes using an interactive split-screen preview comparing raw input records against masked output values.

Save & Automate Profiles

Save your settings as reusable profiles to streamline future tasks and automated updates. Learn more

20% OFF

*Promotion ends 6 August, 2026 (23:59 ET)