PopSQL
Last updated June 10, 2019
The PopSQL add-on is currently in beta.
Table of Contents
PopSQL is a modern SQL editor for teams. It’s an easy way for your team to write SQL queries, share their results, and visualize data.
PopSQL supports PostgreSQL (including Heroku Postgres), MySQL, and Amazon Redshift databases, along with other data stores that support the ODBC standard.
Provisioning the add-on
PopSQL can be attached to a Heroku application via the CLI:
A list of all plans available can be found here.
$ heroku addons:create popsql
-----> Adding popsql to sharp-mountain-4005... done, v18 (free)
When provisioning is complete, visit your app’s Resources tab in the Heroku Dashboard and click on PopSQL to log in via SSO.
You can also log in via SSO with the Heroku CLI:
$ heroku addons:open popsql
After you log in via SSO, visit app.popsql.com to begin using PopSQL.
Connecting to your database
PopSQL needs to connect to your database so you can write and share queries.
- Visit the PopSQL web app at app.popsql.com.
- In the top center of the page, click Manage Connections.
Create a new connection and enter your database host, username, password, and any other relevant credentials.
If you are connecting to a Heroku Postgres database, these credentials are available from your database’s Settings tab at data.heroku.com. Alternatively, you can fetch them with the
heroku pg:credentials:urlcommand. Note that Heroku Postgres credentials can change without notice.If you restrict database access to a list of trusted IPs, you need to add PopSQL’s static IPs to it:
23.20.131.72and54.211.234.135. If you’d prefer to query databases directly from your computer instead of via PopSQL servers, please download the PopSQL desktop app.
Inviting teammates
To invite teammates, visit app.popsql.com, click Preferences in the top left, and then click Invite People in the menu that appears.
Migrating between plans
To add additional seats to your PopSQL plan, use the heroku addons:upgrade command to upgrade:
$ heroku addons:upgrade popsql:newplan
-----> Upgrading ADDON-SLUG:newplan to sharp-mountain-4005... done, v18 ($49/mo)
Your plan has been updated to: ADDON-SLUG:newplan
Resolving a broken connection to Heroku Postgres
If PopSQL suddenly can’t connect to your Heroku Postgres database, it’s likely that Heroku updated your database’s URL and credentials as part of routine maintenance. See your database’s Settings tab at data.heroku.com and confirm that the credentials listed there match the credentials you’ve provided to PopSQL.
Removing the add-on
You can remove PopSQL via the CLI:
This will destroy all associated data and cannot be undone!
$ heroku addons:destroy popsql
-----> Removing ADDON-SLUG from sharp-mountain-4005... done, v20 (free)
Support
Any support-related issues should be submitted via one of the Heroku Support channels. Other product feedback is welcome at support@popsql.com or via the Feedback button in the app.