PopSQL

The first SQL editor with built-in dbt Core support

Create dbt macros and models, all within your SQL editor

Join the beta

Eliminate repetitive SQL using macros

Instead of copying/pasting SQL between queries, create reusable snippets of SQL called macros.

Before
select
created_at at time zone ‘utc’ at time zone ‘pdt’
from users
After
select {{ to_pt(‘created_at’) }} from users

Simplify BI queries with data models

Use models to break down long, complicated queries.

Read the docs
Before
with activated_users as (
select
users.id as user_id,
count(orders.id) as num_orders
from users
left join orders on orders.user_id = users.id
group by 1
having count(orders.id) > 0
)
select *
from events e
inner join activated_users au
on au.user_id = e.user_id
After
select *
from events e
inner join {{ ref('activated_users') }} au on au.user_id = e.user_id

Create a data catalog backed by dbt docs

Write table/column descriptions in dbt, and have those descriptions available in PopSQL autocomplete.

Streamline your dbt workflow

Do your entire dbt workflow within PopSQL rather than switching between your code editor, terminal, and SQL editor.

Join the beta program

Our dbt Core™ integration is currently in beta. Sign up now for early access!

dbt, dbt Core, and the dbt logo are trademarks of dbt Labs, Inc.