Skip Navigation
Show nav
Heroku Dev Center
  • Get Started
  • Documentation
  • Changelog
  • Search
  • Get Started
    • Node.js
    • Ruby on Rails
    • Ruby
    • Python
    • Java
    • PHP
    • Go
    • Scala
    • Clojure
  • Documentation
  • Changelog
  • More
    Additional Resources
    • Home
    • Elements
    • Products
    • Pricing
    • Careers
    • Help
    • Status
    • Events
    • Podcasts
    • Compliance Center
    Heroku Blog

    Heroku Blog

    Find out what's new with Heroku on our blog.

    Visit Blog
  • Log inorSign up
View categories

Categories

  • Heroku Architecture
    • Dynos (app containers)
    • Stacks (operating system images)
    • Networking & DNS
    • Platform Policies
    • Platform Principles
  • Command Line
  • Deployment
    • Deploying with Git
    • Deploying with Docker
    • Deployment Integrations
  • Continuous Delivery
    • Continuous Integration
  • Language Support
    • Node.js
    • Ruby
      • Working with Bundler
      • Rails Support
    • Python
      • Background Jobs in Python
      • Working with Django
    • Java
      • Working with Maven
      • Java Database Operations
      • Working with the Play Framework
      • Working with Spring Boot
      • Java Advanced Topics
    • PHP
    • Go
      • Go Dependency Management
    • Scala
    • Clojure
  • Databases & Data Management
    • Heroku Postgres
      • Postgres Basics
      • Postgres Getting Started
      • Postgres Performance
      • Postgres Data Transfer & Preservation
      • Postgres Availability
      • Postgres Special Topics
    • Heroku Data For Redis
    • Apache Kafka on Heroku
    • Other Data Stores
  • Monitoring & Metrics
    • Logging
  • App Performance
  • Add-ons
    • All Add-ons
  • Collaboration
  • Security
    • App Security
    • Identities & Authentication
    • Compliance
  • Heroku Enterprise
    • Private Spaces
      • Infrastructure Networking
    • Enterprise Accounts
    • Enterprise Teams
    • Heroku Connect (Salesforce sync)
      • Heroku Connect Administration
      • Heroku Connect Reference
      • Heroku Connect Troubleshooting
    • Single Sign-on (SSO)
  • Patterns & Best Practices
  • Extending Heroku
    • Platform API
    • App Webhooks
    • Heroku Labs
    • Building Add-ons
      • Add-on Development Tasks
      • Add-on APIs
      • Add-on Guidelines & Requirements
    • Building CLI Plugins
    • Developing Buildpacks
    • Dev Center
  • Accounts & Billing
  • Troubleshooting & Support
  • Integrating with Salesforce
  • Add-ons
  • All Add-ons
  • PopSQL
PopSQL

This add-on is operated by PopSQL, Inc.

Modern, collaborative SQL editor for your team

PopSQL

Last updated June 10, 2019

The PopSQL add-on is currently in beta.

Table of Contents

  • Provisioning the add-on
  • Connecting to your database
  • Inviting teammates
  • Migrating between plans
  • Resolving a broken connection to Heroku Postgres
  • Removing the add-on
  • Support

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.

Keep reading

  • All Add-ons

Feedback

Log in to submit feedback.

Ziggeo Probely Security Scanner

Information & Support

  • Getting Started
  • Documentation
  • Changelog
  • Compliance Center
  • Training & Education
  • Blog
  • Podcasts
  • Support Channels
  • Status

Language Reference

  • Node.js
  • Ruby
  • Java
  • PHP
  • Python
  • Go
  • Scala
  • Clojure

Other Resources

  • Careers
  • Elements
  • Products
  • Pricing

Subscribe to our monthly newsletter

Your email address:

  • RSS
    • Dev Center Articles
    • Dev Center Changelog
    • Heroku Blog
    • Heroku News Blog
    • Heroku Engineering Blog
  • Heroku Podcasts
  • Twitter
    • Dev Center Articles
    • Dev Center Changelog
    • Heroku
    • Heroku Status
  • Facebook
  • Instagram
  • Github
  • LinkedIn
  • YouTube
Heroku is acompany

 © Salesforce.com

  • heroku.com
  • Terms of Service
  • Privacy
  • Cookies
  • Cookie Preferences