Which database systems does this skill support?

This skill provides specialized templates and scripts for PostgreSQL and MySQL, but the underlying strategies and logic can be applied to most SQL-based database systems.

Does it track who made the change?

Yes, the generated triggers and application logic are designed to capture the database user, application context, client IP, and timestamps for every logged event.

How does it handle the performance overhead of auditing?

The skill includes performance optimization techniques such as partitioning audit tables by date, using asynchronous logging where possible, and auditing only critical tables rather than the entire database.

What happens to the audit data as it grows over time?

The skill provides automated archival procedures to move old logs to cold storage and partitioning schemas to ensure that the primary audit table remains performant.

Can this skill help with GDPR and HIPAA compliance?

Yes, it specifically includes query templates for data access reports and modification logs required by major regulatory frameworks like GDPR, HIPAA, and SOX.

Database Audit Logger

Name: Database Audit Logger
Author: jeremylongshore

byjeremylongshore

•

897

Database Management

Implements comprehensive database change tracking and audit logging to ensure regulatory compliance and security monitoring.

About

This skill automates the implementation of robust database audit trails using various strategies like SQL triggers, Change Data Capture (CDC), and application-level logging. It helps developers maintain compliance with standards such as GDPR, HIPAA, and SOX by providing automated DDL generation, row-level tracking triggers, and pre-built reporting queries. Designed for performance and scalability, the skill includes guidance on table partitioning, automated archival, and minimal-impact monitoring to track sensitive data changes without compromising database stability.

Key Features

Support for multiple strategies including Trigger-based, CDC, and App-level auditing
Automated SQL DDL generation for optimized audit log tables and indexes
Pre-built compliance report templates for GDPR, SOX, and HIPAA audits
Automated creation of AFTER INSERT/UPDATE/DELETE triggers for PostgreSQL and MySQL
Integrated archival and partitioning logic for high-volume audit data management
897 GitHub stars

Use Cases

Monitoring administrative actions and bulk deletions in production environments
Meeting regulatory requirements for tracking modifications to sensitive user data
Building a historical record of database changes for security forensics and debugging

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills implementing-database-audit-logging

For use in Claude.ai and ChatGPT

Download Skill

GitHub