Audit Trail

Audit Trail

| ---------------------------- | -------------------- | | mysql_drop_table | Table DDL (+data) | | mysql_optimize_table | Table DDL | | mysql_repair_table | Table DDL | | mysql_import_data | Table DDL (+data) | | mysql_drop_schema | Schema object list | | mysql_drop_view | View DDL | | mysql_drop_partition | Table DDL | | mysql_doc_drop_collection | Collection schema |

Backup Management Tools

Three MCP tools provide agent access to backup snapshots:

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