jeremylongshore/tons-of-skills-marketplace / plugins/database/database-audit-logger/skills/implementing-database-audit-logging
implementing-database-audit-logging
VerifiedProcess use when you need to track database changes for compliance and security monitoring. This skill implements audit logging using triggers, application-level logging, CDC, or native logs. Trigger with phrases like "implement database audit logging", "add audit trails", "track database changes", or "monitor database activity for compliance".
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 9.2 KB |
| assets/README.md | markdown | 281 B |
| references/README.md | markdown | 64 B |
| scripts/README.md | markdown | 477 B |
| scripts/audit-archival.shexecutable | script | 820 B |
| scripts/audit_log_analyzer.pyexecutable | script | 4.7 KB |
| scripts/audit_log_generator.pyexecutable | script | 4.6 KB |
| scripts/audit_table_creator.pyexecutable | script | 4.7 KB |
scripts/audit_log_generator.py
View on GitHub#!/usr/bin/env python3
"""
database-audit-logger - Analysis Script
Generates sample audit log entries for various database operations.
Generated: 2025-12-10 03:48:17
"""
import json
import argparse
from pathlib import Path
from typing import Dict
from datetime import datetime
class Analyzer:
def __init__(self, target_path: str):
self.target_path = Path(target_path)
self.stats = {"total_files": 0, "total_size": 0, "file_types": {}, "issues": [], "recommendations": []}
def analyze_directory(self) -> Dict:
"""Analyze directory structure and contents."""
if not self.target_path.exists():
self.stats["issues"].append(f"Path does not exist: {self.target_path}")
return self.stats
for file_path in self.target_path.rglob("*"):
if file_path.is_file():
self.analyze_file(file_path)
return self.stats
def analyze_file(self, file_path: Path):
"""Analyze individual file."""
self.stats["total_files"] += 1
self.stats["total_size"] += file_path.stat().st_size
# Track file types
ext = file_path.suffix.lower()
if ext:
self.stats["file_types"][ext] = self.stats["file_types"].get(ext, 0) + 1
# Check for potential issues
if file_path.stat().st_size > 100 * 1024 * 1024: # 100MB
self.stats["issues"].append(f"Large file: {file_path} ({file_path.stat().st_size // 1024 // 1024}MB)")
if file_path.stat().st_size == 0:
self.stats["issues"].append(f"Empty file: {file_path}")
def generate_recommendations(self):
"""Generate recommendations based on analysis."""
if self.stats["total_files"] == 0:
self.stats["recommendations"].append("No files found - check target path")
if len(self.stats["file_types"]) > 20:
self.stats["recommendations"].append("Many file types detected - consider organizing")
if self.stats["total_size"] > 1024 * 1024 * 1024: # 1GB
self.stats["recommendations"].append("Large total size - consider archiving old data")
def generate_report(self) -> str:
"""Generate analysis report."""
report = []
report.append("\n" + "=" * 60)
report.append("ANALYSIS REPORT - database-audit-logger")
report.append("=" * 60)
report.append(f"Target: {self.target_path}")
report.append(f"Generated: {datetime.now().strftime('%Y-%m-%d %H:%M:%S')}")
report.append("")
# Statistics
report.append("📊 STATISTICS")
report.append(f" Total Files: {self.stats['total_files']:,}")
report.append(f" Total Size: {self.stats['total_size'] / 1024 / 1024:.2f} MB")
report.append(f" File Types: {len(self.stats['file_types'])}")
# Top file types
if self.stats["file_types"]:
report.append("\n📁 TOP FILE TYPES")
sorted_types = sorted(self.stats["file_types"].items(), key=lambda x: x[1], reverse=True)[:5]
for ext, count in sorted_types:
report.append(f" {ext or 'no extension'}: {count} files")
# Issues
if self.stats["issues"]:
report.append(f"\n⚠️ ISSUES ({len(self.stats['issues'])})")
for issue in self.stats["issues"][:10]:
report.append(f" - {issue}")
if len(self.stats["issues"]) > 10:
report.append(f" ... and {len(self.stats['issues']) - 10} more")
# Recommendations
if self.stats["recommendations"]:
report.append("\n💡 RECOMMENDATIONS")
for rec in self.stats["recommendations"]:
report.append(f" - {rec}")
report.append("")
return "\n".join(report)
def main():
parser = argparse.ArgumentParser(description="Generates sample audit log entries for various database operations.")
parser.add_argument("target", help="Target directory to analyze")
parser.add_argument("--output", "-o", help="Output report file")
parser.add_argument("--json", action="store_true", help="Output as JSON")
args = parser.parse_args()
print(f"🔍 Analyzing {args.target}...")
analyzer = Analyzer(args.target)
stats = analyzer.analyze_directory()
analyzer.generate_recommendations()
if args.json:
output = json.dumps(stats, indent=2)
else:
output = analyzer.generate_report()
if args.output:
Path(args.output).write_text(output)
print(f"✓ Report saved to {args.output}")
else:
print(output)
return 0 if len(stats["issues"]) == 0 else 1
if __name__ == "__main__":
import sys
sys.exit(main())
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |