鱼皮AI导航
鱼皮AI导航
  • 主页
  • 社区
  • AI工具
  • AI知识库
  • AI提示词
  • MCP
  • Skills
  • AI学习资源
  • AI资讯
  • GitHub开源
登录/注册

database-audit-logger

实现数据库操作的全链路审计追踪,支持通过触发器、应用层埋点、变更数据捕获或日志解析等方式记录数据修改行为,自动生成基础审计表结构,并根据合规要求或调试需求推荐适配方案。

数据与分析数据库
访问 GitHub
文档Skills.MD
name
implementing-database-audit-logging
description
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.
allowed-tools
Read, Write, Edit, Grep, Glob, Bash
version
1.0.0

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 audit table schema.
  3. Assist in selecting a strategy that aligns with compliance requirements (e.g., CDC for real-time monitoring).

Best Practices

  • Strategy Selection: Choose the audit logging strategy that best suits your application's needs and performance requirements. Trigger-based auditing can impact performance, while CDC might require more complex infrastructure.
  • Data Sensitivity: Consider the sensitivity of the data being audited and implement appropriate security measures to protect the audit logs.
  • Retention Policy: Define a clear retention policy for audit logs to manage storage and comply with regulatory requirements.

Integration

This skill can be used in conjunction with other database management plugins to automate the creation of triggers or configure CDC pipelines. It also integrates with logging and monitoring tools to provide a centralized view of database activity.

数据与分析
数据库

快捷安装

复制到终端去安装 Skill

npxskillsaddjeremylongshore/claude-code-plugins-plus-skills--skill"database-audit-logger"
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
🔥热门工具
朱雀AI检测朱雀AI检测
朱雀AI检测助手朱雀AI检测助手
LovartLovart
老鱼简历老鱼简历
WritePass官网WritePass官网
面多多面多多
CursorCursor
星月写作星月写作
朱雀AI检测助手朱雀AI检测助手
零感AI零感AI
Skills 推荐
definition-of-done-generator
自动生成项目完成标准的规范定义与配置文件,提供符合企业级工作流要求的最佳实践指导,输出可直接投入生产环境的代码和验证结果,适用于需要标准化流程审批、合规审查及跨系统集成的复杂项目管理场景。
sagemaker-endpoint-deployer
自动化部署机器学习模型至云端服务端点,支持从配置生成到生产验证的全流程,适用于模型上线、服务监控与推理优化等场景,确保部署方案符合工业级标准。
docx
支持专业级 Word 文档的全生命周期处理,包括从零创建结构化文档、精准编辑内容、管理修订痕迹与批注、提取纯文本或原始 XML 数据、转换为 PDF 或图像用于视觉分析,适用于法律、学术及企业场景下的高保真文档协作与自动化处理。
skills-search
提供对 Claude Code 技能生态的全周期管理能力,支持按功能关键词检索技能、查看详细信息、安装或卸载指定技能,并区分用户级与项目级作用域,覆盖发现、评估、部署及维护各环节。
moai-foundation-core
构建高质量、可扩展的AI开发工作流,通过领域驱动设计与模块化架构实现需求规范先行,结合自动化质量门禁、精细化上下文管理与渐进式知识呈现,在保障安全与可维护性的同时提升开发效率与协作清晰度。