PopSQL

This add-on is operated by PopSQL, Inc.

Modern, collaborative SQL editor for your team

PopSQL

Last updated 10 June 2019

The PopSQL add-on is currently in beta.

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.

  1. Visit the PopSQL web app at app.popsql.com.
  2. In the top center of the page, click Manage Connections.

  3. 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:url command. Note that Heroku Postgres credentials can change without notice.

  4. If you restrict database access to a list of trusted IPs, you need to add PopSQL’s static IPs to it: 23.20.131.72 and 54.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.

Feedback

Log in to submit feedback.