Changelog — v3.1.0

Released: 2026-05-22

This release delivers Phase B: Core Roadmap Extensions — completing all 13 interactive dashboard tabs and 29 premium server-driven diagnostic profilers. The package now includes a fully-featured, offline-ready, real-time SPA dashboard, server-side memory profiling, and live PHPUnit test execution.

---

🚀 New Features

Database & Query Intelligence

• Visual SQL EXPLAIN Query Analyzer — 🔬 Explain button per query renders index scan execution plans
• Duplicate & Redundant Query Detector — flags identical SQL statements and suggests caching strategies
• Interactive SQL Playground — safe SELECT-only terminal inside the dashboard (max 50 rows)
• SQL Database Index Advisor — heuristic WHERE/JOIN column analysis with migration code snippets
• Mail Sandbox & Event Payload Serializer — captures, renders, and records outgoing emails and background queues
• Off-line Operations — local Vue.js and Tailwind CSS distribution support with zero remote script queries

Async & Side-Effect Telemetry

• Queue Job & Event Payload Serializer — captures and renders dispatched events/jobs with full payloads
• Outgoing Mail Sandbox — intercepts Mailables, saves HTML previews, renders them in-dashboard
• Cache Hit/Miss Monitor — tracks get/put/forget with keys, TTLs, byte sizes
• Eloquent Model Lifecycle Tracker — logs all Eloquent observer events per request

Visual Profiling & Timelines

• DevTools-Style Timeline Waterfall — proportional Gantt chart: Boot → DB → Spans → HTTP
• Interactive Blade Template Composition Tree — visual layout nesting flowchart per request
• Live PHP Memory Flame-Graph — real memory_get_peak_usage() layered allocation breakdown
• Outgoing Latency Radar — DB vs app overhead ratio performance meters

Environment, Security & DevOps

• Livewire Hydration State Tracker — discrete JSON state dumps for Livewire component updates
• Dev Environment Configuration Shield — TCP socket checks for Redis/SMTP at artisan serve
• Cookie & CSRF Token Debugger — 419 Page Expired root cause analyzer
• .env vs .env.example Diff Audit — side-by-side missing key comparison grid
• Category Tag Filtering (?_debug_tag=x) — URL-tagged request scoping in sidebar
• Composer Security Dependency Auditor — CVE advisory scan of composer.lock
• Git Branch Code Correlation Analyzer — active branch badge + uncommitted file warnings

Dashboard & Streaming

• Real-time SSE Log Streaming — persistent EventSource stream (/_agent_debug/sse) with AJAX fallback
• Outgoing API Mock Interceptor — full UI rule builder for Http::fake() JSON stubs, persisted to disk
• Browser-Based PHPUnit Test Runner — one-click in-dashboard test suite executor with streaming output
• Artisan Quick-Console — cache:clear, route:clear, debug-clean from the dashboard header

Artisan Commands

• agent:debug-record — exports debug session as a portable .md or .json bundle
• agent:debug-tail — live Termwind-styled CLI stream viewer

---

🛠️ Technical Improvements

• Replaced timed AJAX polling loop with persistent EventSource SSE stream in Vue.js dashboard
• Memory profiler uses real PHP heap metrics (memory_get_peak_usage(true)) weighted by subsystem activity
• Blade views composition parser updated to correctly handle multi-section log blocks
• Mock interceptor rules persisted to storage/logs/agent-debugger/mocks.json, applied via Http::fake() at boot

---

🧪 Testing

• All 28 feature tests pass with 112 assertions — 100% green
• Orchestra Testbench 9.x compatibility maintained
• Zero external JS/CSS dependencies added

---

📋 Dashboard Tabs (Complete List)

Tab	Trigger Condition
📜 Execution Log	Always
🗃️ Database Queries	When queries are present
⏱️ Timeline Waterfall	Always
📢 Events & Jobs	When events/jobs are dispatched
🗺️ Blade Views	When view compositions are captured
📦 Inertia Properties	On Inertia requests
🔌 Livewire Properties	On Livewire requests
🗂️ Cache Monitor	When cache actions are logged
🔄 Eloquent Events	When model observers fire
📧 Outgoing Mail	When emails are intercepted
📊 Memory Allocations	Always
🎭 Outgoing API Mocks	Always
🧪 PHPUnit Runner	Always