{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT ca.file_path, cq.hygiene_score, cq.issues_count, cq.factor_scores\nFROM code_analysis ca\nJOIN code_quality cq ON cq.analysis_id = ca.id\nWHERE ca.file_path LIKE '%\/pipeline\/db%'\nORDER BY ca.file_path",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_core.py\",\n \"hygiene_score\": 100,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":100,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_documents.py\",\n \"hygiene_score\": 95,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":74,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_logging.py\",\n \"hygiene_score\": 100,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":100,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_prompts.py\",\n \"hygiene_score\": 100,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":100,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_queue.py\",\n \"hygiene_score\": 100,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":100,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db_semantic.py\",\n \"hygiene_score\": 91,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":100,\\\"loc\\\":57,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n },\n {\n \"file_path\": \"\/var\/www\/scripts\/pipeline\/db.py\",\n \"hygiene_score\": 90,\n \"issues_count\": 0,\n \"factor_scores\": \"{\\\"dependencies\\\":60,\\\"loc\\\":100,\\\"methods\\\":100,\\\"secrets\\\":100,\\\"classes\\\":100,\\\"magic_numbers\\\":100}\"\n }\n ],\n \"row_count\": 7,\n \"error\": null,\n \"execution_ms\": 2\n}"
}
]
}