Featured

implementing-database-audit-logging

Name: implementing-database-audit-logging
Rating: 5 (621 reviews)
Author: jeremylongshore

This skill helps implement database audit logging for tracking changes and ensuring compliance. It is triggered when the user requests to "implement database audit logging", "add audit trails", "track database changes", or mentions "audit_log" in relation to a database. The skill provides options for trigger-based auditing, application-level logging, Change Data Capture (CDC), and parsing database logs. It generates a basic audit table schema and guides the user through selecting the appropriate auditing strategy.

TL;DR

Automates database audit logging setup with strategy selection and schema generation.

What Is It

Automates audit logging setup
Provides basic audit table schema
Supports multiple auditing strategies
Helps meet compliance and debugging needs

Key Features

Offers Trigger-Based, Application-Level, CDC, and Database Logs strategies
Generates basic SQL schema for audit tables
Simplifies implementation of audit trails
Supports compliance and debugging use cases
Integrates with logging and monitoring tools
Guides selection based on data sensitivity and performance

How to Use

1.Detect user intent to implement audit logging
2.Present available strategies for selection
3.Generate and provide basic audit table schema
4.Guide user to choose and tailor strategy to specific table or compliance need

Guardrails & Gotchas

MUST consider data sensitivity and implement security measures
FORBIDDEN to use without proper retention policy
CRITICAL: avoid performance degradation from trigger-based auditing

Explore More Skills

move-code-quality

@davila7

Analyzes Move language packages against the official Move Book Code Quality Checklist. Use this skill when reviewing Move code, checking Move 2024 Edition compliance, or analyzing Move packages for best practices. Activates automatically when working with .move files or Move.toml manifests.

12.4k

1.1k

1w ago