Protokoll #27461

{
    "event": "PreToolUse",
    "tool_name": "mcp__mcp-db__db_select",
    "tool_input": {
        "query": "SELECT \n    ca.file_path,\n    cq.hygiene_score,\n    cq.issues_count,\n    cq.factor_scores\nFROM code_quality cq\nJOIN code_analysis ca ON cq.analysis_id = ca.id\nWHERE cq.hygiene_score < 90\nORDER BY cq.hygiene_score ASC\nLIMIT 15",
        "database": "ki_dev"
    }
}

{
    "tool_response": [
        {
            "type": "text",
            "text": "{\n  \"status\": \"success\",\n  \"data\": [\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/analyzers\/entity_extractor.py\",\n      \"hygiene_score\": 45,\n      \"issues_count\": 2,\n      \"factor_scores\": \"{\\\"dependencies\\\":10,\\\"loc\\\":0,\\\"methods\\\":40,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":90}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/mcp-servers\/mcp-db\/test_all_functions.py\",\n      \"hygiene_score\": 53,\n      \"issues_count\": 4,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":0,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":80}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/pipeline.py\",\n      \"hygiene_score\": 55,\n      \"issues_count\": 2,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":0,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/ManageChatSessionsUseCase.php\",\n      \"hygiene_score\": 57,\n      \"issues_count\": 1,\n      \"factor_scores\": \"{\\\"dependencies\\\":60,\\\"loc\\\":35,\\\"methods\\\":0,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/mcp-servers\/mcp-db\/comprehensive_test.py\",\n      \"hygiene_score\": 58,\n      \"issues_count\": 5,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":34,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":60}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/vision.py\",\n      \"hygiene_score\": 60,\n      \"issues_count\": 4,\n      \"factor_scores\": \"{\\\"dependencies\\\":10,\\\"loc\\\":30,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":60}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/mcp-servers\/mcp-contracts\/tools\/contract_tools.py\",\n      \"hygiene_score\": 61,\n      \"issues_count\": 1,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":31,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/generators\/content_generator.py\",\n      \"hygiene_score\": 61,\n      \"issues_count\": 2,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":33,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":90}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Domain\/Entity\/TaskAssignment.php\",\n      \"hygiene_score\": 63,\n      \"issues_count\": 1,\n      \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":15,\\\"methods\\\":0,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/extract.py\",\n      \"hygiene_score\": 63,\n      \"issues_count\": 0,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":40,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Domain\/Entity\/ChatMessage.php\",\n      \"hygiene_score\": 64,\n      \"issues_count\": 0,\n      \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":0,\\\"methods\\\":20,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/db.py\",\n      \"hygiene_score\": 65,\n      \"issues_count\": 1,\n      \"factor_scores\": \"{\\\"dependencies\\\":40,\\\"loc\\\":0,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/scripts\/pipeline\/quality_test.py\",\n      \"hygiene_score\": 65,\n      \"issues_count\": 4,\n      \"factor_scores\": \"{\\\"dependencies\\\":20,\\\"loc\\\":47,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":60}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/StreamingChatMessageUseCase.php\",\n      \"hygiene_score\": 66,\n      \"issues_count\": 0,\n      \"factor_scores\": \"{\\\"dependencies\\\":60,\\\"loc\\\":10,\\\"methods\\\":70,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    },\n    {\n      \"file_path\": \"\/var\/www\/mcp-servers\/mcp-tasks\/infrastructure\/task_repository.py\",\n      \"hygiene_score\": 66,\n      \"issues_count\": 0,\n      \"factor_scores\": \"{\\\"dependencies\\\":0,\\\"loc\\\":56,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n    }\n  ],\n  \"row_count\": 15,\n  \"error\": null,\n  \"execution_ms\": 6\n}"
        }
    ]
}