I'm kinda surprised someone hasn't made a script to grab the new connection string and update the value in a secrets store when it stops working / Heroku rotates it.