Follow the flow. Keep the checkpoints.
- 01CRM objects
- 02SQL query
- 03Joined results
- 04Analysis
What it does and who can use it
HubSQL is HubSpot’s SQL query layer for CRM data. It remains in private beta, but HubSpot now publishes an endpoint guide covering queries, supported data sources, authentication, pagination, and permissions. This replaces the earlier launch-era assumption that those details were undocumented.
Request beta access through the link in HubSpot’s developer guide. OAuth, static-auth tokens, and service keys are documented; required scopes depend on the queried objects.
Pricing and access checks
The reviewed technical guide is not a pricing commitment. Confirm eligibility and commercial terms for your account before depending on the beta.
How we would implement it
The following is Hubjoy’s recommended implementation approach.
- Choose a question you can validate independently, such as a filtered deal list. Identify the object properties and the user who should be allowed to see them.
- Use the documented POST query endpoint and SQL request body. Read the supported syntax before assuming a full database dialect is available.
- Handle pagination and null values explicitly. Check returned values and totals against known CRM records before building a report around the result.
- Test permissions with the intended authentication mode. HubSpot documents OAuth property restrictions, while static auth and service keys do not enforce those per-user property restrictions.
What to watch in practice
For an initial pilot, we would keep an existing report as the comparison and fallback. Define expected record counts and investigate differences before presenting a result to leadership. Do not expose a broadly privileged query connection to users whose normal CRM access is narrower. A convenient query layer still needs a deliberate access model.
Frequently asked questions
Which data can it query?
The guide documents standard CRM objects, custom and app objects, and events, with supported-source and SQL limitations. Sensitive Data is not supported through this endpoint.
Is it a general-purpose database connection?
No. Implement against HubSpot’s documented query endpoint and supported syntax; do not assume arbitrary SQL statements or write operations.
Where are the API details?
Use the linked HubSQL guide, including its versioned endpoint and beta-access link. The API version label is not a general-availability promise.
Official sources
Product information checked October 23, 2026. Availability, limits, and pricing can change; use these sources and your account’s terms for purchase and implementation decisions.