Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

Cloud and Direct Connections

PopSQL offers two types of connections, cloud and direct. Both connection types can be shared with your team.

Cloud connections

Cloud connections are where PopSQL serves as the middleman and our servers connect to your database. This is the default and recommended setup in PopSQL because it unlocks several benefits:

  1. Teammates will easily be able to start using PopSQL without spending hours/days hunting for database credentials
  2. You'll be able to use our web app @ app.popsql.com
  3. You'll be able to use scheduled queries and scheduled dashboards

You can use cloud connections in the web app and the desktop app.

Direct connections

Direct connections are where your computer connects directly to your database, and your database credentials such as username and password stay local on your computer. For example, if your workplace requires a VPN to reach your database, you would want to use a direct connection. Direct connections can only be used in the desktop app.

When you share a direct connection with your team, then the details such as host, port, database, SSH, and SSL will be saved to our servers and shared with your team, but each user will be required to put in their own credentials, which is stored only on their local computer.

Enterprise

Enterprise customers have additional options for connections, such as OAuth for BigQuery and Snowflake and AWS IAM for PostgreSQL and Redshift. Please contact us if you're interested.

Security

For information on security, please visit our Security page.

Ready for a modern SQL editor?