{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT ca.file_path, cq.hygiene_score, cq.issues_count\nFROM code_quality cq\nJOIN code_analysis ca ON ca.id = cq.analysis_id\nWHERE cq.issues_count >= 3\n AND ca.file_path LIKE '\/var\/www\/dev.campus%'\nORDER BY cq.issues_count DESC\nLIMIT 10",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/CodeAnalysis\/CodeQualityChecker.php\",\n \"hygiene_score\": 72,\n \"issues_count\": 12\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/View\/chat\/index.php\",\n \"hygiene_score\": 73,\n \"issues_count\": 8\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/View\/semantic-explorer\/entitaeten\/show.php\",\n \"hygiene_score\": 95,\n \"issues_count\": 5\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/View\/content-pipeline\/show.php\",\n \"hygiene_score\": 87,\n \"issues_count\": 5\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Controller\/Api\/ExplorerController.php\",\n \"hygiene_score\": 93,\n \"issues_count\": 5\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Chat\/StreamingChatMessageUseCase.php\",\n \"hygiene_score\": 64,\n \"issues_count\": 4\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Docs\/Doc2VectorPipeline.php\",\n \"hygiene_score\": 96,\n \"issues_count\": 4\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/View\/content-pipeline\/run-status.php\",\n \"hygiene_score\": 84,\n \"issues_count\": 4\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Taxonomy\/GetTaxonomyOverviewUseCase.php\",\n \"hygiene_score\": 96,\n \"issues_count\": 4\n },\n {\n \"file_path\": \"\/var\/www\/dev.campus.systemische-tools.de\/src\/UseCases\/Pipeline\/PipelineRunStatusUseCase.php\",\n \"hygiene_score\": 97,\n \"issues_count\": 3\n }\n ],\n \"row_count\": 10,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}