{
"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 '%\/mcp-servers\/%'\n AND ca.file_path NOT LIKE '%test%'\nORDER BY cq.issues_count DESC\nLIMIT 20",
"database": "ki_dev"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"file\": \"mcp-servers\/mcp-tasks\/tools\/task_tools\/crud_tools.py\",\n \"score\": 73,\n \"issues\": 9\n },\n {\n \"file\": \"mcp-servers\/mcp-tasks\/tools\/task_tools\/workflow_tools.py\",\n \"score\": 67,\n \"issues\": 6\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/select_tool.py\",\n \"score\": 83,\n \"issues\": 5\n },\n {\n \"file\": \"mcp-servers\/mcp-tasks\/tools\/task_tools\/list_tools.py\",\n \"score\": 85,\n \"issues\": 5\n },\n {\n \"file\": \"mcp-servers\/mcp-tasks\/tools\/quality_tools.py\",\n \"score\": 84,\n \"issues\": 4\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/describe_tool.py\",\n \"score\": 91,\n \"issues\": 4\n },\n {\n \"file\": \"mcp-servers\/mcp-tasks\/domain\/contracts.py\",\n \"score\": 89,\n \"issues\": 4\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/delete_tool.py\",\n \"score\": 91,\n \"issues\": 4\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/tables_tool.py\",\n \"score\": 95,\n \"issues\": 3\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/insert_tool.py\",\n \"score\": 92,\n \"issues\": 3\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/update_tool.py\",\n \"score\": 92,\n \"issues\": 3\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/databases_tool.py\",\n \"score\": 95,\n \"issues\": 3\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/stats_tool.py\",\n \"score\": 98,\n \"issues\": 2\n },\n {\n \"file\": \"mcp-servers\/mcp-contracts\/tools\/contract_tools\/contract_reporter.py\",\n \"score\": 83,\n \"issues\": 2\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/tools\/execute_tool.py\",\n \"score\": 88,\n \"issues\": 2\n },\n {\n \"file\": \"mcp-servers\/mcp-tasks\/tools\/task_tools\/execute_tool.py\",\n \"score\": 86,\n \"issues\": 2\n },\n {\n \"file\": \"mcp-servers\/mcp-db\/domain\/query_contract.py\",\n \"score\": 99,\n \"issues\": 1\n },\n {\n \"file\": \"mcp-servers\/mcp-contracts\/validators\/contract_validator.py\",\n \"score\": 73,\n \"issues\": 1\n },\n {\n \"file\": \"mcp-servers\/mcp-contracts\/tools\/contract_tools\/contract_validator.py\",\n \"score\": 89,\n \"issues\": 1\n },\n {\n \"file\": \"mcp-servers\/mcp-contracts\/tools\/contract_tools\/__init__.py\",\n \"score\": 75,\n \"issues\": 1\n }\n ],\n \"row_count\": 20,\n \"error\": null,\n \"execution_ms\": 0\n}"
}
]
}