{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT ca.id, ca.file_name, ca.directory, ca.line_count, cq.issues_count, cq.hygiene_score\nFROM code_analysis ca\nLEFT JOIN code_quality cq ON ca.id = cq.analysis_id\nWHERE (ca.file_name = 'Controller.php' AND ca.directory LIKE '%Framework%')\n OR (ca.file_name = 'services.php')\n OR (ca.file_name = 'index.php' AND ca.directory LIKE '%public%')\nORDER BY ca.scanned_at DESC",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"id\": 8018,\n \"file_name\": \"index.php\",\n \"directory\": \"\/var\/www\/dev.campus.systemische-tools.de\/public\",\n \"line_count\": 42,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 7802,\n \"file_name\": \"services.php\",\n \"directory\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\",\n \"line_count\": 380,\n \"issues_count\": 1,\n \"hygiene_score\": 63\n },\n {\n \"id\": 7660,\n \"file_name\": \"Controller.php\",\n \"directory\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Framework\",\n \"line_count\": 288,\n \"issues_count\": 2,\n \"hygiene_score\": 79\n }\n ],\n \"row_count\": 3,\n \"error\": null,\n \"execution_ms\": 0\n}"
}
]
}