Audit Query

Generate audit-grade records for sensitive SQL operations including approvals, risk outcomes, and execution traces.

rweisssieker-xp 3dcb486 695 B Updated

File contents

Audit Query

Use when

  • User or policy requires immutable evidence trail for governance/compliance.

Workflow

  1. Capture request context, actor, environment, and policy context.
  2. Attach parsed query fingerprint and risk decision.
  3. Record outcomes, anomalies, and deviations.
  4. Produce a signed audit artifact when applicable.

Governance

  • Ensure immutable append-only behavior.
  • Redact secrets and raw sensitive literals in logs.

Output

  • auditEntryId, requestFingerprint, decisionLog, approvalChain, trace

rweisssieker-xp/sqlserver-postgres-plugin/tree/main/plugins/sqlserver-postgres-performance-advisor/skills/audit-query commit 3dcb486b33

Frequently asked questions

npx skillmds@latest add rweisssieker-xp/audit-query