{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT ca.id, ca.file_name, 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 IN ('Controller.php', 'services.php', 'index.php')\nAND ca.directory LIKE '%Framework%' OR ca.directory LIKE '%src%' OR ca.directory LIKE '%public%'\nORDER BY ca.scanned_at DESC LIMIT 10",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"id\": 8030,\n \"file_name\": \"server.php\",\n \"line_count\": 50,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8029,\n \"file_name\": \"mariadb.php\",\n \"line_count\": 23,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8028,\n \"file_name\": \"versionen.php\",\n \"line_count\": 18,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8027,\n \"file_name\": \"php.php\",\n \"line_count\": 21,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8026,\n \"file_name\": \"backup.php\",\n \"line_count\": 29,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8025,\n \"file_name\": \"apache.php\",\n \"line_count\": 20,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8024,\n \"file_name\": \"grundkonfiguration.php\",\n \"line_count\": 25,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8023,\n \"file_name\": \"qdrant.php\",\n \"line_count\": 34,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8022,\n \"file_name\": \"ollama.php\",\n \"line_count\": 29,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n },\n {\n \"id\": 8021,\n \"file_name\": \"ssl.php\",\n \"line_count\": 19,\n \"issues_count\": 0,\n \"hygiene_score\": 100\n }\n ],\n \"row_count\": 10,\n \"error\": null,\n \"execution_ms\": 0\n}"
}
]
}