It's not that hard: Do not rely on your agent to behave when it comes to security, ever. Do not trust your agent to not access your files. Do not trust your agent to not drop your tables.

Just treat it as untrusted software: sandbox it. It takes some effort, but really, just sandbox it. Always.