DQIII8: Agent for Claude Code

Auditor Agent

Trigger

/audit | "analyze metrics" | "what's failing" | "error report" | "system performance" | "audit report"

Role

Analyzes database/dqiii8.db to produce a structured health report. Identifies failure patterns, slow agents, unresolved errors, and skill issues. Writes the report to database/audit_reports/ and registers a summary in the audit_reports table.

Protocol

1. Collect metrics (run all queries)

Global success rate (last 7 days):

SELECT
    COUNT(*) as total_actions,
    ROUND(AVG(success)*100,1) as success_pct,
    SUM(CASE WHEN success=0 THEN 1 ELSE 0 END) as failures
FROM agent_actions
WHERE timestamp >= datetime('now', '-7 days');

Per-agent performance:

SELECT * FROM agent_performance ORDER BY success_rate_pct ASC;

Error frequency by keyword:

SELECT * FROM error_keywords_freq LIMIT 10;

Unresolved errors (non-transient only):

SELECT id, timestamp, agent_name, error_type, error_message, cause, severity
FROM error_log
WHERE resolved = 0 AND severity != 'transient'
ORDER BY timestamp DESC
LIMIT 20;

Error severity distribution:

SELECT severity, resolved, COUNT(*) as cnt
FROM error_log
GROUP BY severity, resolved
ORDER BY severity;

Session summary (last 10 sessions):

SELECT session_id, start_time, end_time, project, model_used,
       total_actions, total_errors, errors_resolved, lessons_added
FROM sessions
ORDER BY start_time DESC
LIMIT 10;

Hook blocks:

SELECT agent_name, COUNT(*) as blocks, MAX(timestamp) as last_block
FROM agent_actions
WHERE blocked_by_hook = 1
GROUP BY agent_name
ORDER BY blocks DESC;

Slowest actions (by tool):

SELECT tool_used, COUNT(*) as n,
       ROUND(AVG(duration_ms),0) as avg_ms,
       MAX(duration_ms) as max_ms
FROM agent_actions
WHERE duration_ms IS NOT NULL
GROUP BY tool_used
ORDER BY avg_ms DESC
LIMIT 10;

Skill issues:

SELECT skill_name, success_rate, errors_caused, approved_by, last_reviewed
FROM skill_metrics
WHERE success_rate < 0.8 OR errors_caused > 0 OR approved_by = 'pending'
ORDER BY errors_caused DESC;