Protokoll #28554

{
    "event": "PreToolUse",
    "tool_name": "mcp__mcp-db__db_select",
    "tool_input": {
        "query": "SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_KEY\nFROM information_schema.COLUMNS \nWHERE TABLE_SCHEMA = 'ki_content' \nAND TABLE_NAME IN ('documents', 'document_pages', 'taxonomy_terms', 'ontology_classes', 'statements')\nORDER BY TABLE_NAME, ORDINAL_POSITION",
        "database": "ki_content"
    }
}

{
    "tool_response": [
        {
            "type": "text",
            "text": "{\n  \"status\": \"success\",\n  \"data\": [\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"PRI\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"source_path\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"UNI\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"folder_path\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"filename\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"mime_type\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"file_hash\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"file_size\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"language\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"imported_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"processed_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"status\",\n      \"DATA_TYPE\": \"enum\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"semantic_status\",\n      \"DATA_TYPE\": \"enum\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"error_message\",\n      \"DATA_TYPE\": \"text\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"documents\",\n      \"COLUMN_NAME\": \"authority_score\",\n      \"DATA_TYPE\": \"float\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"PRI\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"document_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"page_number\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"image_path\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"text_content\",\n      \"DATA_TYPE\": \"text\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"vision_analysis\",\n      \"DATA_TYPE\": \"longtext\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"ocr_applied\",\n      \"DATA_TYPE\": \"tinyint\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"token_count\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"document_pages\",\n      \"COLUMN_NAME\": \"created_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"PRI\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"name\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"UNI\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"parent_class_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"description\",\n      \"DATA_TYPE\": \"text\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"properties\",\n      \"DATA_TYPE\": \"longtext\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"ontology_classes\",\n      \"COLUMN_NAME\": \"created_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"PRI\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"subject_entity_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"predicate\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"object_entity_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"object_literal\",\n      \"DATA_TYPE\": \"text\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"chunk_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"confidence\",\n      \"DATA_TYPE\": \"float\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"status\",\n      \"DATA_TYPE\": \"enum\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"created_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"statements\",\n      \"COLUMN_NAME\": \"updated_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"PRI\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"name\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"slug\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"NO\",\n      \"COLUMN_KEY\": \"UNI\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"parent_id\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"description\",\n      \"DATA_TYPE\": \"text\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"depth\",\n      \"DATA_TYPE\": \"int\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"path\",\n      \"DATA_TYPE\": \"varchar\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"MUL\"\n    },\n    {\n      \"TABLE_NAME\": \"taxonomy_terms\",\n      \"COLUMN_NAME\": \"created_at\",\n      \"DATA_TYPE\": \"datetime\",\n      \"IS_NULLABLE\": \"YES\",\n      \"COLUMN_KEY\": \"\"\n    }\n  ],\n  \"row_count\": 47,\n  \"error\": null,\n  \"execution_ms\": 1\n}"
        }
    ]
}