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

•

데이터베이스 관리

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

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.

주요 기능

01Support for multiple strategies including Trigger-based, CDC, and App-level auditing

02Automated SQL DDL generation for optimized audit log tables and indexes

03Pre-built compliance report templates for GDPR, SOX, and HIPAA audits

04Automated creation of AFTER INSERT/UPDATE/DELETE triggers for PostgreSQL and MySQL

05Integrated archival and partitioning logic for high-volume audit data management

06897 GitHub stars

사용 사례

01Monitoring administrative actions and bulk deletions in production environments

02Meeting regulatory requirements for tracking modifications to sensitive user data

03Building 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

주요 기능

01Support for multiple strategies including Trigger-based, CDC, and App-level auditing

02Automated SQL DDL generation for optimized audit log tables and indexes

03Pre-built compliance report templates for GDPR, SOX, and HIPAA audits

04Automated creation of AFTER INSERT/UPDATE/DELETE triggers for PostgreSQL and MySQL

05Integrated archival and partitioning logic for high-volume audit data management

06897 GitHub stars

사용 사례

01Monitoring administrative actions and bulk deletions in production environments

02Meeting regulatory requirements for tracking modifications to sensitive user data

03Building 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