HubSpot operator guide

HubSpot HubSQL: SQL Access to Your CRM Data (Private Beta)

HubSQL is HubSpot’s SQL query layer for CRM data.

Published September 10, 2026Reviewed October 23, 20262 min read7 chapters
The operating sequence

Follow the flow. Keep the checkpoints.

  1. 01CRM objects
  2. 02SQL query
  3. 03Joined results
  4. 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.

  1. 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.
  2. Use the documented POST query endpoint and SQL request body. Read the supported syntax before assuming a full database dialect is available.
  3. Handle pagination and null values explicitly. Check returned values and totals against known CRM records before building a report around the result.
  4. 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.

Put the guide into practice

Turn this guide into a working HubSpot system.

Tell us what you want to improve. We’ll help you choose the right starting point and plan the implementation.

Talk about your HubSpot data