If you’ve ever tried to use DataGrip to connect to a Heroku PostgreSQL database, you’ve learned that it doesn’t work out of the box.
The solution: You’ll have to mess with your settings a bit. First, enter your database credentials in the appropriate fields (DataGrip doesn’t support the postgres:// connection string that Heroku provides). Next, click the “Advanced” tab above the host field. Find the ssl field and type in true. From there, scroll down, find sslfactory, and set that to the following: org.postgresql.ssl.NonValidatingFactory
Click “Apply” and you’re all set!