PostgreSQL Anonymizer

7.0easy start · #4 of 22
in Data Masking Software

Free to practise onyes
Free trialnot on record
Well documentedyes
Runs where you workyes

Runs on Linux, Mac, self-hosted, Windows.

PostgreSQL Anonymizer is ranked #4 of 22 in data masking software on The Geeks Club. It runs on Linux, macOS, Self-hosted, Windows. There is a free plan.

PostgreSQL Anonymizer plans and pricing

All plans

PostgreSQL Anonymizer Free Use, copy, modify, and distribute under the PostgreSQL License; commercial support available separately gitlab.com · 29 Sept 2026

Compared on data masking software

Free plan: Yes
Masking methods: both
Synthetic data: Yes
Referential integrity: Yes
Data subsetting: Yes
API access: Yes

Best PostgreSQL Anonymizer alternatives

See all 12

MySQL 0 of 4 in the starter kit Lesson 17.9 DataVeil 0 of 4 in the starter kit Lesson 27.4 Jailer 0 of 4 in the starter kit Lesson 37.0 Greenmask 0 of 4 in the starter kit Lesson 56.9 DATPROF 0 of 4 in the starter kit Lesson 66.8 MOSTLY AI 0 of 4 in the starter kit Lesson 76.8

The record

Purpose: A PostgreSQL extension for masking or replacing personally identifiable or commercially sensitive data.
Declarative rules: Masking rules can be declared in SQL using PostgreSQL DDL and stored in the database schema.
Masking functions: Available function types include randomization, faking, partial scrambling, shuffling, noise, generalization, and custom functions.
Identifier detection: Its detection function searches for common identifier names using English and French dictionaries, and the documentation warns that detection can produce false positives and false negatives.
Anonymous exports: A masked database role can be used with pg_dump to export anonymized data, and the documentation says masking rules should be removed from the resulting dump.
Integrations: Installation documentation includes Ansible, Docker, and Django, and lists compatible PostgreSQL forks and cloud database providers.
Supported deployment: The extension has installation instructions for Linux distributions and self-hosted PostgreSQL; it can also be built from source on macOS, but community support for macOS is not provided.
Windows support: There is no native Windows build; the documentation describes running PostgreSQL Anonymizer inside PostgreSQL on WSL2.
Cloud limitation: Installation requires superuser privileges, so a DBaaS provider must add the extension to its catalog for customers to use it.
Dynamic masking limitation: Masked roles are not allowed to use EXPLAIN, and masking rules can break data integrity, for example when masking a UNIQUE column to NULL.
Support: The project invites users to join its Matrix or Discord communities or open a public GitLab issue; enterprise support is available by contacting Dalibo.
License: The project license permits use, copying, modification, and distribution without a fee, while disclaiming any obligation to provide maintenance, support, or updates.
Price from: Free

Where it ranks on The Geeks Club

Best Data Masking Software in 2026#4 of 22

Is PostgreSQL Anonymizer yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote PostgreSQL Anonymizer

Sources

postgresql-anonymizer.readthedocs.io/en/stable/· checked 29 Sept 2026
postgresql-anonymizer.readthedocs.io/en/stable/detection/· checked 29 Sept 2026
postgresql-anonymizer.readthedocs.io/en/stable/anonymous_dumps/· checked 29 Sept 2026
postgresql-anonymizer.readthedocs.io/en/stable/INSTALL/· checked 29 Sept 2026
postgresql-anonymizer.readthedocs.io/en/stable/dynamic_masking/· checked 29 Sept 2026
gitlab.com/dalibo/postgresql_anonymizer/-/blob/mas· checked 29 Sept 2026