implementing-database-audit-logging

What problem does it solve?

This skill automates the process of setting up database audit logging, helping users choose an appropriate auditing strategy and providing a basic audit table schema. It simplifies the implementation of robust audit trails for compliance, debugging, and security monitoring.

Core Features & Use Cases

• Strategy Selection: Offers trigger-based, application-level, Change Data Capture (CDC), and database log parsing options.
• Schema Generation: Provides a basic SQL schema for an audit log table.
• Compliance & Debugging: Track changes to specific tables for regulatory compliance or to debug data inconsistencies.
• Use Case: Implement audit logging for a critical users table to meet compliance regulations and track all modifications.

Quick Start

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.