{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n CASE \n WHEN issues_json LIKE '%magic_number%' THEN 'magic_number'\n WHEN issues_json LIKE '%complexity%' THEN 'complexity'\n WHEN issues_json LIKE '%coupling%' THEN 'coupling'\n WHEN issues_json LIKE '%srp%' THEN 'srp'\n ELSE 'other'\n END as primary_issue,\n COUNT(*) as files,\n SUM(issues_count) as issues\nFROM code_quality \nWHERE issues_count > 0\nGROUP BY primary_issue\nORDER BY issues DESC",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"primary_issue\": \"magic_number\",\n \"files\": 69,\n \"issues\": \"129\"\n },\n {\n \"primary_issue\": \"complexity\",\n \"files\": 9,\n \"issues\": \"11\"\n },\n {\n \"primary_issue\": \"coupling\",\n \"files\": 11,\n \"issues\": \"11\"\n },\n {\n \"primary_issue\": \"srp\",\n \"files\": 3,\n \"issues\": \"3\"\n }\n ],\n \"row_count\": 4,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}