Show HN: Brume – Postgres pseudonymization that preserves FKs across tables
Brume is an open-source tool for PostgreSQL that pseudonymizes datasets while preserving foreign key relationships across tables, allowing developers to work with realistic but de-identified data.
Background
- Brume is an open-source tool for pseudonymizing data in PostgreSQL databases while keeping foreign key relationships intact — a problem many anonymization tools handle poorly.
- Pseudonymization means replacing personally identifiable information (PII) with fake but consistent values, so the data remains usable for testing, analytics, or compliance without exposing real identities.
- This is relevant to GDPR and data privacy regulations, which require companies to protect user data but still need realistic datasets for development or debugging.
- The main challenge Brume solves: when you replace names or emails across multiple related tables, the fake IDs need to stay consistent so database relations (foreign keys) don't break.