{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n SUM(JSON_LENGTH(JSON_EXTRACT(issues_json, '$[*]'))) as total_issues_detailed,\n SUM(CASE WHEN issues_json LIKE '%magic_number%' THEN \n JSON_LENGTH(JSON_EXTRACT(issues_json, '$[*]')) - \n JSON_LENGTH(REPLACE(issues_json, '\"magic_number\"', '')) \/ LENGTH('\"magic_number\"')\n ELSE 0 END) as approx_magic_issues\nFROM code_quality \nWHERE issues_count > 0",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"total_issues_detailed\": \"174\",\n \"approx_magic_issues\": \"0.0000\"\n }\n ],\n \"row_count\": 1,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}