{
"event": "PreToolUse",
"tool_name": "mcp__mcp-db__db_select",
"tool_input": {
"query": "SELECT tt.id, tt.name, tt.slug, tt.description, COUNT(dt.document_id) as doc_count\nFROM taxonomy_terms tt\nLEFT JOIN document_taxonomy dt ON tt.id = dt.taxonomy_term_id\nGROUP BY tt.id, tt.name, tt.slug, tt.description\nORDER BY doc_count DESC",
"database": "ki_content"
}
}
{
"tool_response": [
{
"type": "text",
"text": "{\n \"status\": \"success\",\n \"data\": [\n {\n \"id\": 9,\n \"name\": \"Prozess\",\n \"slug\": \"prozess\",\n \"description\": null,\n \"doc_count\": 9\n },\n {\n \"id\": 11,\n \"name\": \"Haltung\",\n \"slug\": \"haltung\",\n \"description\": null,\n \"doc_count\": 8\n },\n {\n \"id\": 6,\n \"name\": \"Entwicklung\",\n \"slug\": \"entwicklung\",\n \"description\": null,\n \"doc_count\": 6\n },\n {\n \"id\": 2,\n \"name\": \"Theorie\",\n \"slug\": \"theorie\",\n \"description\": null,\n \"doc_count\": 3\n },\n {\n \"id\": 10,\n \"name\": \"Kontext\",\n \"slug\": \"kontext\",\n \"description\": null,\n \"doc_count\": 3\n },\n {\n \"id\": 1,\n \"name\": \"Methoden\",\n \"slug\": \"methoden\",\n \"description\": null,\n \"doc_count\": 2\n },\n {\n \"id\": 3,\n \"name\": \"Praxis\",\n \"slug\": \"praxis\",\n \"description\": null,\n \"doc_count\": 2\n },\n {\n \"id\": 4,\n \"name\": \"Kommunikation\",\n \"slug\": \"kommunikation\",\n \"description\": null,\n \"doc_count\": 1\n },\n {\n \"id\": 7,\n \"name\": \"Coaching\",\n \"slug\": \"coaching\",\n \"description\": null,\n \"doc_count\": 1\n },\n {\n \"id\": 5,\n \"name\": \"Organisation\",\n \"slug\": \"organisation\",\n \"description\": null,\n \"doc_count\": 0\n },\n {\n \"id\": 8,\n \"name\": \"Therapie\",\n \"slug\": \"therapie\",\n \"description\": null,\n \"doc_count\": 0\n }\n ],\n \"row_count\": 11,\n \"error\": null,\n \"execution_ms\": 0\n}"
}
]
}