Managed to solve it. My problem was that collection type names were to long. For sqlite max length is 128bytes, and for postgres and mysql is 64bytes
EDIT: for anyone looking for heroku alternative (cheaper) and no limit on database, also it supports proxy over cloudflare (orange cloudflare settings)
deploy it on here Railway you will host it for free with database mysql or postgres. you have in start 5$ per month free, and my usage is around 2,1$/month with strapi and postgres database. plus is you verify with card you will get 10$ per month.
also your app will auto-scale if it needs more resource.