{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n SUM(issues_count) as total_issues,\n SUM(hardcoded_count) as total_hardcoded,\n SUM(warnings_count) as total_warnings,\n AVG(hygiene_score) as avg_hygiene_score,\n COUNT(*) as files_with_issues\nFROM code_quality cq\nJOIN code_analysis ca ON cq.analysis_id = ca.id\nWHERE ca.scan_id = (SELECT MAX(scan_id) FROM code_analysis)\nAND cq.issues_count > 0",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"total_issues\": \"140\",\n \"total_hardcoded\": \"0\",\n \"total_warnings\": \"33\",\n \"avg_hygiene_score\": \"82.5443\",\n \"files_with_issues\": 79\n }\n ],\n \"row_count\": 1,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}