{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n COUNT(*) as total_files,\n ROUND(AVG(q.hygiene_score), 1) as avg_score,\n SUM(q.issues_count) as total_issues,\n SUM(CASE WHEN q.hygiene_score >= 90 THEN 1 ELSE 0 END) as excellent,\n SUM(CASE WHEN q.hygiene_score >= 70 AND q.hygiene_score < 90 THEN 1 ELSE 0 END) as good,\n SUM(CASE WHEN q.hygiene_score < 70 THEN 1 ELSE 0 END) as needs_work\nFROM code_quality q\nJOIN code_analysis a ON q.analysis_id = a.id\nWHERE a.scanned_at = (SELECT MAX(scanned_at) FROM code_analysis)",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"total_files\": 554,\n \"avg_score\": \"94.7\",\n \"total_issues\": \"116\",\n \"excellent\": \"445\",\n \"good\": \"89\",\n \"needs_work\": \"20\"\n }\n ],\n \"row_count\": 1,\n \"error\": null,\n \"execution_ms\": 3\n}"
}
]
}