Set the DATABASE_CLIENT environment variable to the correct database:
DATABASE_CLIENT=postgres
By default it was using the local data.db file used with SQL lite, and I was wondering why the database was being erased each time I pushed to production.
const client = env('DATABASE_CLIENT', 'sqlite');