This may sound easy for the experienced ones, but will be a major time-waster if you haven’t done something like this before. First things first, Heroku Postgres connection strings are usually set up in an environment variable, if you go to your Heroku app dashboard and click the Settings tab, there’s a section call ‘Config Vars’ and a button called “Reveal Config Vars” inside it, click that button and it will the PostgreSQL environment variable usually it’s DATABASE_URL, at times it can be HEROKU_POSTGRESQL_<SOME_COLOR>_URL. Either way, all you need to do is replicate this environment variable locally