Data migration for external reporting purposes

I’m just looking for any best practices or processes to automatically migrate the entire database and schema from discourse to another database for reporting purposes. I’m thinking of just using the data explorer to expose each table as an API but I’m wondering if anyone else has any suggestions for what could be done that could be simpler.