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

Connecting to ClickHouse

  1. Click Manage Connections in the top center of the app.
  2. Click New Connection in the Manage Connections modal in PopSQL. alt text
  3. For Nickname, enter something a descriptive name for your connection, like Acme Production.
  4. For Type, choose ClickHouse
  5. For Hostname, enter the hostname of your database server.
  6. For Port, use the default 8123, or enter the HTTP port used by your server.
  7. For Database, enter the name of your database.
  8. For Username and Password, enter the username and password for ClickHouse. These are optional.
  9. Hit Connect and you're all set!

alt text

Happy querying! 🍭

Ready for a modern SQL editor?