{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n CASE \n WHEN issues_json LIKE '%magic_number%' AND issues_json LIKE '%complexity%' THEN 'magic+complexity'\n WHEN issues_json LIKE '%magic_number%' AND issues_json LIKE '%coupling%' THEN 'magic+coupling'\n WHEN issues_json LIKE '%magic_number%' AND issues_json LIKE '%srp%' THEN 'magic+srp'\n WHEN issues_json LIKE '%magic_number%' THEN 'magic_number_only'\n WHEN issues_json LIKE '%complexity%' THEN 'complexity_only'\n WHEN issues_json LIKE '%coupling%' THEN 'coupling_only'\n WHEN issues_json LIKE '%srp%' THEN 'srp_only'\n ELSE 'other'\n END as issue_category,\n COUNT(*) as files,\n SUM(issues_count) as issues\nFROM code_quality \nWHERE issues_count > 0\nGROUP BY issue_category\nORDER BY issues DESC",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"issue_category\": \"magic_number_only\",\n \"files\": 77,\n \"issues\": \"123\"\n },\n {\n \"issue_category\": \"magic+complexity\",\n \"files\": 3,\n \"issues\": \"14\"\n },\n {\n \"issue_category\": \"complexity_only\",\n \"files\": 9,\n \"issues\": \"11\"\n },\n {\n \"issue_category\": \"coupling_only\",\n \"files\": 11,\n \"issues\": \"11\"\n },\n {\n \"issue_category\": \"magic+coupling\",\n \"files\": 3,\n \"issues\": \"10\"\n },\n {\n \"issue_category\": \"srp_only\",\n \"files\": 3,\n \"issues\": \"3\"\n },\n {\n \"issue_category\": \"magic+srp\",\n \"files\": 1,\n \"issues\": \"2\"\n }\n ],\n \"row_count\": 7,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}