Query HubSpot
like a database
Write SQL-like queries against your HubSpot portals. Filter contacts, companies and deals — with joins, associations and real-time cost estimates.
SELECT name, domain, email, amount
FROM company
WHERE annualrevenue > 1000000
WITH INNER ASSOCIATED deal AS top_deals
WHERE dealstage = 'closedwon'
TAKE 3 ORDER BY MAX amount
WITH ASSOCIATED contact ON LABELS 'decision maker' AS key_contacts
WHERE email HAS_PROPERTYEverything your RevOps team needs
⚡
SQL-like syntax
Familiar query language with HubSpot-native concepts: filterGroups, associations, labels.
🔗
Association joins
LEFT OUTER and INNER joins across contacts, companies, deals — with edge label filtering.
📊
Transparent billing
Every query shows objects processed, returned and billed before you confirm execution.