Skip to content

PostgreSQL Anonymizer

by DALIBO

Free PostgreSQL extension that masks or replaces personal data using rules declared in the database.

  • Self-hosted
  • Small business
  • Mid-size
  • Enterprise
  • Open source
  • Free tier

From PostgreSQL Anonymizer's own website and public documents, updated 4 Nov 2026. Not a hands-on review: I add a verdict only to products I use myself.

What is PostgreSQL Anonymizer?

PostgreSQL Anonymizer is an extension that masks or replaces personally identifiable information and commercially sensitive data inside a Postgres database. DALIBO develops it on GitLab as open source under the PostgreSQL License.

Masking rules are declared with SQL data definition statements, so the policy lives in the table definition. The project says the people who build the application should write the rules. It lists six masking methods: anonymous dumps, static masking, dynamic masking, replica masking, masking views and masking data wrappers.

Masking functions cover randomization, faking, partial scrambling, shuffling, noise and generalization, and custom functions are allowed. Detection functions guess which columns hold identifiers. Version 3.3.2 came out on 28 October 2026. The docs mention enterprise support from the maintainers.

Best forPostgreSQL teams that need masked copies, dumps or views for testing

PostgreSQL Anonymizer features

  • Declarative masking rules

    Rules are written in SQL inside the table definition.

  • Dynamic masking

    Hides personal data only for users marked as masked.

  • Static masking

    Removes personal data from a database according to the rules.

  • Anonymous dumps

    Exports masked data into an SQL file.

  • Replica masking

    Creates an anonymized clone of a database.

  • Masking functions

    Randomization, faking, partial scrambling, shuffling, noise, generalization and custom functions.

  • Identifier detection

    Functions that guess which columns need to be anonymized.

  • Masking views and data wrappers

    Dedicated views for masked users, and masking on external data.

PostgreSQL Anonymizer integrations

  • PostgreSQL

From the vendor's own integration list or documentation.

PostgreSQL Anonymizer pricing

Starting price

Free (PostgreSQL License)

  • Pricing modelFlat fee
  • Free tierYes
  • Free trialNo

Current prices on the vendor's site · Checked 4 Nov 2026. Prices change often; the vendor's page wins.

Security and compliance

Certifications
None listed on a public trust page
EU data residency
Not documented

Where it fits (NIST CSF 2.0)

  1. Govern (not covered)
  2. Identify (not covered)
  3. Protect
  4. Detect (not covered)
  5. Respond (not covered)
  6. Recover (not covered)

Independent audits

No public independent audit found.

Good to know before you buy

  • It works only on PostgreSQL, and you install and run it yourself.
  • The project's GitHub address returns 404; code lives on GitLab at dalibo/postgresql_anonymizer.
  • Enterprise support is offered by contacting the maintainers; no price is listed.

PostgreSQL Anonymizer alternatives

Database firewall, activity monitoring, masking and discovery across 50+ databases and data sources.

Imperva Data Security Fabric

Imperva (a Thales company)

Data activity monitoring, discovery and compliance reporting across databases, clouds and file stores.

Perforce Delphix

Perforce Software, Inc.

Sensitive data discovery, masking and synthetic data for test, analytics and AI environments.

PostgreSQL Anonymizer vs DataSunrise Database SecurityPostgreSQL Anonymizer vs Imperva Data Security FabricPostgreSQL Anonymizer vs Perforce Delphix

Frequently asked questions

What is PostgreSQL Anonymizer?

Free PostgreSQL extension that masks or replaces personal data using rules declared in the database.

How much does PostgreSQL Anonymizer cost?

PostgreSQL Anonymizer starts at Free (PostgreSQL License), according to its pricing page (checked 4 Nov 2026).

Is there a free version of PostgreSQL Anonymizer?

Yes. PostgreSQL Anonymizer has a free plan or tier; check the pricing page for its limits.

What are the alternatives to PostgreSQL Anonymizer?

Products in the same category include DataSunrise Database Security, Imperva Data Security Fabric, Perforce Delphix, Thales CipherTrust Data Security Platform.

Where is PostgreSQL Anonymizer based?

The company behind PostgreSQL Anonymizer is based in France.

Have you tested PostgreSQL Anonymizer?

Not yet. This page lists published facts only. When I test it, my verdict will appear at the top.

Sources (3), checked 4 Nov 2026
  1. postgresql-anonymizer.readthedocs.io/en/stable
  2. gitlab.com/dalibo/postgresql_anonymizer
  3. gitlab.com/dalibo/postgresql_anonymizer/-/blob/latest/LICENSE.md

Spotted something out of date? Tell me through the contact page and I will fix it.

By using this site, you agree to the Privacy Policy.