topic Querying Hubspot Database with SQL in APIs & Integrations

Querying Hubspot Database with SQL

JakeRubin — Thu, 22 Aug 2019 22:57:21 GMT

Hi all,

New to Hubspot. This is definitely going to be a total n00b question but whatever, I'm stuck and could use some help.

Simply put I just want to query the hubspot database with SQL. It honestly doesn't matter what the program is; I have them all - I'm on a Mac. SQL Developer, MySQL, Azure Data Studio, Sequel Pro.

All I want to do is 1: Connect to my companies Hubspot Data with one of those programs.

I have spent 6-7 hours and it looks like there are all kinds of services that are trying to reinvent the wheel here and make us pay an extra $100-300 a month (on top of the $1200 for the pro version of Hubspot).

It cannot be this difficult, can anyone help me out?

Re: Querying Hubspot Database with SQL

Willson — Fri, 23 Aug 2019 10:18:47 GMT

Hey @JakeRubin

I've just been reviewing this now and can see that you've partnered with our Support Team in relation to this - Do you still require any assistance with your initial query?

Thanks,

Matt

Re: Querying Hubspot Database with SQL

IsaacTakushi — Fri, 23 Aug 2019 15:57:21 GMT

Hey, @JakeRubin.

It sounds like you want to directly query your HubSpot companies data with SQL from an application like MySQL.

Unfortunately, it isn't possible to directly interact with HubSpot tables in this way. You'll have to create your own tables and populate them with the desired data via our APIs. Services like Hull do this for you so you don't have to build tables from scratch.

As my support colleague Dwi suggests in ticket 2682507, you can pull company data from your account using the Companies API. More specifically, the Get all companies endpoint is probably what you'll want to use. Be sure to specify any properties you want returned with properties query parameters.

Apologies for the confusion. Please let us know if we can clarify further.

Re: Querying Hubspot Database with SQL

johnelmer — Sun, 28 Mar 2021 15:47:14 GMT

I know this is an older thread, but I wanted to alert the community that there is now a HubSpot App in the marketplace for users who want to use SQL queries to pull data from their HubSpot database. The app is called MS SQL Server for HubSpot. This integration pulls data out of HubSpot using a set of prebuilt API connectors. HubSpot data is then stored in an Azure SQL data warehouse, and automatically refreshed on a regularly scheduled basis. Using this solution, you can freely query your HubSpot data without having to write any APIs or use expensive customer data platforms like Hull. Users can connect this SQL Server data warehouse to apps like Klipfolio, BI software and more.

Re: Querying Hubspot Database with SQL

PamCotton — Wed, 15 Jul 2020 20:33:52 GMT

Thank you for sharing this information @johnelmer this is a great resource!

Pam

Re: Querying Hubspot Database with SQL

CEstrada — Tue, 16 Mar 2021 16:57:58 GMT

Hello,

Good afternoon, I have a query, I hope you can help me.
I would like to know if there is a way to update a field in a table from lowercase to uppercase using a query or from the crm portal.
I'd appreciate your help..

Thanks!!

Re: Querying Hubspot Database with SQL

BBrown97 — Wed, 01 Jun 2022 16:04:25 GMT

Hello! You can connect to your companies HubSpot Data with Azure MySQL via Skyvia. I usually use it because that does not require coding and I can load 10000 records per month for free. With Skyvia I can easily perform bi-directional sync of Azure MySQL and HubSpot. When performing the HubSpot - Azure MySQL sync periodically, Skyvia does not load all the data each time. It tracks changes in the synchronized data sources and performs only necessary data changes. By the way, Skyvia is a partner of HubSpot. You can check it out on the HubSpot marketplace.

Re: Querying Hubspot Database with SQL

AlbertBer — Thu, 24 Jul 2025 14:27:13 GMT

I’ve had to tackle this exact scenario. There are a few ways to approach it, but I found that trying to build a custom solution with APIs can get complicated quickly, especially when you want everything to stay in sync automatically.

What ended up working for me was using a dedicated integration service, like Skyvia. It connects HubSpot to PostgreSQL without much setup, and you can map the form data however you need. You can check it here.

Re: Querying Hubspot Database with SQL

RubenBurdin — Wed, 10 Sep 2025 17:34:47 GMT

Hi @JakeRubin , I get the frustration you’d think querying HubSpot data with SQL directly would be trivial.

But HubSpot still doesn’t expose its backend tables for raw SQL access. The supported way remains pulling via the CRM APIs. Current link for 2025:

(https://developers.hubspot.com/docs/guides/crm/understanding-the-crm )

Which means creating your own tables in Postgres/MySQL/etc. and then syncing. That’s why marketplace apps and services like Skyvia or Datawarehouse.io exist: they essentially automate that pipeline for you.

What’s changed since 2023 is that two-way sync platforms have matured. Instead of cobbling together API calls or batch exports, you can now mirror HubSpot objects into a database and keep them live-updated, while still being able to write back changes.

That means you can open up Sequel Pro or Azure Data Studio, run standard SQL queries, and know they’re always reflecting the latest HubSpot state and even push updates back in without fighting API pagination or rate limits.

This is exactly the gap Stacksync was designed to fill. In 2025, teams use it to keep HubSpot, Postgres, and ERPs in bidirectional sync with millisecond latency, so you query with SQL as if HubSpot were just another table in your warehouse (https://stacksync.com).

Instead of reinventing the wheel with custom connectors, you get real-time SQL access plus writes that flow back into HubSpot automatically. If SQL access to HubSpot is what’s holding you up, Stacksync makes that a solved problem.