{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n REPLACE(ca.file_path, '\/var\/www\/', '') 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.issues_count > 0 \n AND ca.file_path LIKE '%\/pipeline\/%'\n AND ca.file_path NOT LIKE '%test%'\nORDER BY cq.issues_count DESC",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"file\": \"scripts\/pipeline\/vision.py\",\n \"score\": 62,\n \"issues\": 4\n },\n {\n \"file\": \"scripts\/pipeline\/analyzers\/entity_extractor.py\",\n \"score\": 53,\n \"issues\": 4\n },\n {\n \"file\": \"scripts\/pipeline\/enrich.py\",\n \"score\": 89,\n \"issues\": 4\n },\n {\n \"file\": \"dev.campus.systemische-tools.de\/src\/UseCases\/Pipeline\/PipelineRunStatusUseCase.php\",\n \"score\": 97,\n \"issues\": 3\n },\n {\n \"file\": \"scripts\/pipeline\/generators\/content_generator.py\",\n \"score\": 60,\n \"issues\": 3\n },\n {\n \"file\": \"scripts\/pipeline\/db.py\",\n \"score\": 67,\n \"issues\": 2\n },\n {\n \"file\": \"scripts\/pipeline\/pipeline.py\",\n \"score\": 57,\n \"issues\": 2\n },\n {\n \"file\": \"scripts\/pipeline\/generate_semantics.py\",\n \"score\": 96,\n \"issues\": 2\n },\n {\n \"file\": \"scripts\/pipeline\/chunk.py\",\n \"score\": 84,\n \"issues\": 2\n },\n {\n \"file\": \"scripts\/pipeline\/chat.py\",\n \"score\": 84,\n \"issues\": 2\n },\n {\n \"file\": \"scripts\/pipeline\/web_generate.py\",\n \"score\": 84,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/analyzers\/statement_analyzer.py\",\n \"score\": 79,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/generate.py\",\n \"score\": 75,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/generators\/__init__.py\",\n \"score\": 75,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/generators\/persistence.py\",\n \"score\": 99,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/semantic_chunk\/ollama_service.py\",\n \"score\": 97,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/knowledge.py\",\n \"score\": 75,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/knowledge\/llm_service.py\",\n \"score\": 84,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/protokoll.py\",\n \"score\": 99,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/semantic_chunk_analyzer.py\",\n \"score\": 75,\n \"issues\": 1\n },\n {\n \"file\": \"scripts\/pipeline\/semantic_chunk\/analyzers.py\",\n \"score\": 96,\n \"issues\": 1\n }\n ],\n \"row_count\": 21,\n \"error\": null,\n \"execution_ms\": 2\n}"
}
]
}