Any way to backup a database to local automatically with API?

Baserow can both export and import and you will be allowed to do that with self-hosted Baserow without any issue. We are just being careful for the time being with any imports done in baserow.io for data integrity and security reasons. It is planned to be supported too but the import logic will need to be made more robust before we allow that.