implementing-database-audit-logging

## Overview This skill automates the process of setting up database audit logging. It helps users choose an appropriate auditing strategy and provides a basic audit table schema. It simplifies the implementation of robust audit trails for compliance and debugging purposes. ## How It Works 1. **Identify Request**: Detects user intent to implement database audit logging. 2. **Present Audit Strategies**: Offers a selection of auditing strategies: Trigger-Based, Application-Level, CDC, and Database Logs. 3. **Generate Audit Table Schema**: Provides a basic SQL schema for an audit log table. ## When to Use This Skill This skill activates when you need to: - Implement database audit logging for compliance requirements. - Track changes to specific database tables. - Debug data inconsistencies by reviewing historical changes. - Securely monitor database activity. ## Examples ### Example 1: Implementing Audit Logging for a Specific Table User request: "Implement database audit logging for the users table." The skill will: 1. Present the available audit logging strategies (Trigger-Based, Application-Level, CDC, Database Logs). 2. Provide the basic audit table schema. 3. Guide the user to choose an appropriate method and tailor the schema to the "users" table. ### Example 2: Adding Audit Trails for Compliance User request: "Add audit trails to my database to meet compliance regulations." The skill will: 1. Present the available audit logging strategies. 2. Provide the basic ...