pgMemento
PostgreSQL extension providing an audit trail and schema versioning using transaction-based logging and JSONB delta storage.
What is pgMemento?
pgMemento is a PostgreSQL extension that provides a built-in audit trail and schema versioning system. It logs all data modifications (INSERT, UPDATE, DELETE) and schema changes (CREATE, ALTER, DROP) using database triggers and PL/pgSQL functions, storing change deltas as JSONB. It solves the problem of tracking historical data changes, enabling data restoration, compliance auditing, and understanding database evolution over time.
Database administrators, backend developers, and DevOps engineers working with PostgreSQL who need reliable, database-native auditing for compliance, debugging, or historical data analysis.
Developers choose pgMemento because it integrates auditing directly into PostgreSQL without external tools, uses efficient JSONB delta storage, provides transaction-aware logging, and includes unique schema versioning capabilities—all while being open-source and self-hosted.
Overview
Audit trail with schema versioning for PostgreSQL using transaction-based logging
Use Cases
Best For
- Implementing regulatory compliance (e.g., GDPR, HIPAA) audit trails in PostgreSQL
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
