Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Open Diffix

open-diffix.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.5 Club score Visit open-diffix.org

What Open Diffix is

Open Diffix is an open-source project that develops tools for anonymizing structured data. Its SynDiffix Python package generates synthetic data intended to be statistically accurate while maintaining strong anonymity. It is particularly suited to descriptive analysis, including histograms, heatmaps, column correlations, counts, averages, and standard deviations. Teams can create synthetic tables tailored to individual analytic tasks, with the project designed to preserve anonymity across many combinations of columns. SynDiffix can also be used for machine learning, though the maker says it is somewhat less easy to use for those applications. Users can distribute a blob for others to generate synthetic tables, but recipients need to install SynDiffix, and blobs do not scale well beyond about 10 columns. Installation uses pip and requires Python 3.10 or later. For data with multiple rows per protected entity, the entity identifier must be supplied separately or anonymity may be compromised. Open Diffix also offers pg_diffix, a PostgreSQL extension that returns aggregate answers for a very limited subset of SQL; its development is paused.

Who it suits

Open Diffix suits teams that need synthetic structured data for descriptive analytics and can work with Python. It may also interest PostgreSQL users seeking anonymized aggregate answers, though pg_diffix development is paused.

Good to know, and what to watch

  • Open-source tools for anonymizing structured data.
  • SynDiffix supports descriptive analytics, including histograms and correlations.
  • Can tailor synthetic tables to individual analytic tasks.
  • Supports synthetic data distribution through blobs.
  • Available for Linux, macOS, and Windows.
  • SynDiffix requires Python 3.10 or later.
  • Blobs do not scale well beyond about 10 columns.
  • Protected entity identifiers must be supplied separately in some datasets.
  • pg_diffix development is paused and supports limited SQL.

The verdict

SynDiffix is geared toward producing task-specific synthetic data for descriptive analysis, with machine learning also possible but less straightforward. Check its Python requirement and blob limitations, and treat pg_diffix as a separate, paused option with narrow query support.

What the maker publishes

Analytics
SynDiffix is especially suited to descriptive analytics, including histograms, heatmaps, column correlations, counts, averages, and standard deviations. source
Blob limit
The maker’s repository says SynDiffix blobs currently do not scale well beyond about 10 columns. source
Distribution
SynDiffix supports creating a distributable blob from which users can generate synthetic tables, and the maker says users need to install SynDiffix to use a blob. source
Install
The SynDiffix repository says to install the package with pip and requires Python 3.10 or later. source
Machine learning
SynDiffix can be used for machine learning, though the maker says it is somewhat less easy to use for ML applications. source
Origins
The underlying technology for Open Diffix tools was developed by the Max Planck Institute for Software Systems in partnership with the former Aircloak GmbH. source
pg_diffix
pg_diffix is a PostgreSQL extension that returns aggregate anonymized answers for a limited subset of SQL queries, and its development is currently paused. source
pg_diffix compatibility
The pg_diffix repository says PostgreSQL version 13 or higher is required and documents installation on Linux and Windows. source
pg_diffix limitations
The Open Diffix site says pg_diffix only returns aggregate answers consisting of column values and associated counts for a very limited subset of SQL, and is less flexible than SynDiffix. source
pg_diffix requirements
The pg_diffix repository requires PostgreSQL 13 or higher and documents installation for Linux and Windows. source
pg_diffix support
The maker says pg_diffix development is currently paused and invites interested project teams to contact them. source
PostgreSQL extension
pg_diffix is a PostgreSQL extension that returns aggregate anonymized answers to a very limited subset of SQL queries. source
Project
Open Diffix is an open-source project developing tools for anonymizing structured data. source
Protected entities
For data with multiple rows per protected entity, the entity identifier must be supplied separately or anonymity may be compromised. source
Runtime requirement
SynDiffix installs with pip and requires Python 3.10 or later. source
Support
The maker invites questions and requests for help or advice by email and bug reports or feature requests through GitHub issues. source
SynDiffix
SynDiffix is a Python package for generating statistically accurate and strongly anonymous synthetic data from structured data. source
Tailored datasets
SynDiffix is designed to generate a separate synthetic dataset tailored to each use case, and the site says it can support thousands of column combinations while preserving anonymity. source
Usage
SynDiffix can create separate synthetic tables tailored to individual analytic tasks while maintaining strong anonymity across many column combinations. source

Checked against the maker's pages on 8 Oct 2026.