{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT \n SUM(CASE WHEN has_desc = 0 AND has_ks = 0 AND has_ec = 0 THEN 1 ELSE 0 END) as komplett_leer,\n SUM(CASE WHEN has_desc = 1 AND has_ks = 1 AND has_ec = 1 THEN 1 ELSE 0 END) as komplett_voll,\n SUM(CASE WHEN has_desc = 1 AND has_ks = 0 THEN 1 ELSE 0 END) as desc_aber_keine_ks,\n SUM(CASE WHEN has_desc = 0 AND has_ks = 1 THEN 1 ELSE 0 END) as ks_aber_keine_desc,\n COUNT(*) as total\nFROM (\n SELECT \n e.id,\n CASE WHEN e.description IS NOT NULL AND LENGTH(e.description) > 50 THEN 1 ELSE 0 END as has_desc,\n CASE WHEN eks.entity_id IS NOT NULL THEN 1 ELSE 0 END as has_ks,\n CASE WHEN ec.entity_id IS NOT NULL THEN 1 ELSE 0 END as has_ec\n FROM entities e\n LEFT JOIN (SELECT DISTINCT entity_id FROM entity_knowledge_semantics) eks ON e.id = eks.entity_id\n LEFT JOIN (SELECT DISTINCT entity_id FROM entity_classifications) ec ON e.id = ec.entity_id\n) sub",
"database": "ki_content"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"komplett_leer\": \"12\",\n \"komplett_voll\": \"189\",\n \"desc_aber_keine_ks\": \"48\",\n \"ks_aber_keine_desc\": \"0\",\n \"total\": 461\n }\n ],\n \"row_count\": 1,\n \"error\": null,\n \"execution_ms\": 1\n}"
}
]
}