Audit Trail

Audit Trail

Tool	Scope	Parameters	Description
mysql_audit_list_backups	read	limit (default: 10), target (optional string)	List snapshots with optional target filter
mysql_audit_restore_backup	admin	filename, includeData (bool), dryRun (bool)	Restore snapshot DDL+data
mysql_audit_diff_backup	read	filename	Compare snapshot DDL against live schema

Features: mysql_audit_restore_backup supports dryRun: true which returns the DDL that would be executed without actually modifying the database. mysql_audit_diff_backup enables agents to see exact schema drift over time.

Retention

Snapshots are cleaned up automatically during each snapshot capture cycle. The system currently enforces a hardcoded retention policy of 30 days maximum age or 1000 snapshots, whichever is reached first. The oldest snapshots exceeding either limit are deleted first.

---

🔗 Explore Related Topics

• OAuth — Authentication and access control
• Resources — mysql://audit resource details
• Code Mode — Admin scope requirements and native isolated-vm sandbox
• Tool Reference — Full tool list with scope groups