Strapi deletes my collections and singles when restarting the server

Can’t I run in development mode and still use external database? the documention fro Strapi mentions that staging env uses develop command, no? I was also under the impression that you can’t create collections when runing in production mode? I’m pretty sure I saw the table in my postgres db after I created it. I have only configured a postgres database as mentioned above.