Implements comprehensive database audit trails for PostgreSQL and MySQL to track data modifications and ensure regulatory compliance.
This skill enables the automated setup of database-level audit logging to monitor INSERT, UPDATE, and DELETE operations. It generates the necessary SQL DDL for audit tables, trigger functions, and indexes, while also handling application-level user context, monthly partitioning for performance, and compliance reporting. It is particularly useful for engineering teams needing to meet strict GDPR, HIPAA, or SOX requirements by creating immutable records of data changes with full before-and-after snapshots.
主な機能
01Performance-optimized monthly partitioning and secondary indexing
02Integration of application-level user context via session variables
030 GitHub stars
04Pre-configured compliance report queries for security and audit scenarios
05Automatic capture of before and after record values in JSONB format
06Trigger-based auditing for PostgreSQL and MySQL
ユースケース
01Investigating unauthorized data modifications or suspicious bulk deletions
02Ensuring GDPR and HIPAA compliance for sensitive PII and health records
03Generating detailed change history reports for financial or transactional data
