Here's a trick for running this against a Heroku PostgreSQL database (here for a Heroku app called "simonwillisonblog"):

    rainfrog --url $(heroku config:get DATABASE_URL -a simonwillisonblog)