{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n REPLACE(ca.file_path, '\/var\/www\/dev.campus.systemische-tools.de\/', '') as file,\n cq.hygiene_score as score,\n cq.issues_count as issues\nFROM code_quality cq\nJOIN code_analysis ca ON cq.analysis_id = ca.id\nWHERE cq.hygiene_score < 80 \nORDER BY cq.hygiene_score ASC \nLIMIT 15",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"file\": \"\/var\/www\/scripts\/pipeline\/analyzers\/entity_extractor.py\",\n \"score\": 53,\n \"issues\": 4\n },\n {\n \"file\": \"\/var\/www\/mcp-servers\/mcp-db\/test_all_functions.py\",\n \"score\": 54,\n \"issues\": 5\n },\n {\n \"file\": \"\/var\/www\/scripts\/pipeline\/pipeline.py\",\n \"score\": 57,\n \"issues\": 2\n },\n {\n \"file\": \"src\/UseCases\/Chat\/ManageChatSessionsUseCase.php\",\n \"score\": 59,\n \"issues\": 2\n },\n {\n \"file\": \"src\/Domain\/Entity\/TaskResult.php\",\n \"score\": 60,\n \"issues\": 2\n },\n {\n \"file\": \"\/var\/www\/scripts\/pipeline\/generators\/content_generator.py\",\n \"score\": 60,\n \"issues\": 3\n },\n {\n \"file\": \"src\/Domain\/Entity\/Task.php\",\n \"score\": 60,\n \"issues\": 2\n },\n {\n \"file\": \"\/var\/www\/mcp-servers\/mcp-contracts\/tools\/contract_tools.py\",\n \"score\": 61,\n \"issues\": 1\n },\n {\n \"file\": \"\/var\/www\/mcp-servers\/mcp-db\/comprehensive_test.py\",\n \"score\": 62,\n \"issues\": 8\n },\n {\n \"file\": \"\/var\/www\/scripts\/pipeline\/vision.py\",\n \"score\": 62,\n \"issues\": 4\n },\n {\n \"file\": \"\/var\/www\/scripts\/pipeline\/extract.py\",\n \"score\": 63,\n \"issues\": 0\n },\n {\n \"file\": \"src\/Domain\/Entity\/TaskAssignment.php\",\n \"score\": 63,\n \"issues\": 1\n },\n {\n \"file\": \"src\/UseCases\/Chat\/StreamingChatMessageUseCase.php\",\n \"score\": 64,\n \"issues\": 4\n },\n {\n \"file\": \"src\/Domain\/Entity\/ChatMessage.php\",\n \"score\": 64,\n \"issues\": 1\n },\n {\n \"file\": \"\/var\/www\/mcp-servers\/mcp-tasks\/infrastructure\/task_repository.py\",\n \"score\": 66,\n \"issues\": 0\n }\n ],\n \"row_count\": 15,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}