{
"event": "PostToolUse",
"tool_name": "Read",
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/mcp-servers\/mcp-db\/tools\/stats_tool.py",
"content": "\"\"\"Stats Tool - Logging-Statistiken\"\"\"\nimport sys\n\nsys.path.insert(0, \"\/opt\/mcp-servers\/mcp-db\")\n\nfrom config import Config\nfrom infrastructure.db_connection import DatabaseConnection\n\n\ndef register_stats_tool(mcp):\n \"\"\"Registriert db_stats Tool\"\"\"\n\n @mcp.tool()\n def db_stats(limit: int = 50) -> dict:\n \"\"\"\n Zeigt letzte Queries aus mcp_log.\n\n Args:\n limit: Anzahl der Einträge (1-100)\n\n Returns:\n Dict mit logs (List[dict])\n \"\"\"\n limit = min(max(limit, 1), 100)\n\n try:\n with DatabaseConnection.get_connection(Config.LOG_DB_NAME) as conn:\n # buffered=True verhindert \"Unread result found\" Fehler\n cursor = conn.cursor(dictionary=True, buffered=True)\n cursor.execute(\n \"\"\"SELECT id, timestamp, client_name, request, status,\n duration_ms, error_message\n FROM mcp_log\n ORDER BY timestamp DESC\n LIMIT %s\"\"\",\n (limit,),\n )\n logs = cursor.fetchall()\n cursor.close()\n\n # Convert datetime objects to strings for JSON serialization\n for log in logs:\n if log.get(\"timestamp\"):\n log[\"timestamp\"] = log[\"timestamp\"].isoformat()\n\n return {\"logs\": logs, \"count\": len(logs)}\n\n except Exception as e:\n return {\"error\": str(e), \"logs\": []}\n",
"numLines": 50,
"startLine": 1,
"totalLines": 50
}
}
}