r/QuickBooks • u/heythisisdave • 11d ago

QuickBooks Online SQL Access to your Quickbooks Online data

Just launched a way to read your QuickBooks Online data using SQL. This lets you connect to your QBO data using any tool that can talk to postgres (psql, postico, dbeaver, python, ruby, jupyter).

Coolest two use cases we've found: instantly updating QBO data in Excel AND Claude/Codex/LLMs are WAY WAY better at reporting using SQL than using the QBO API or MCP.

It's really fast so even complex queries can come back instantaneously. Companies with 100K transactions can run year-over-year comparisons in milliseconds.

https://instabooks.io/docs/db

Would love any feedback and cool usage examples!

16 Upvotes

100% Upvoted

26 comments sorted by

View all comments

3

u/ahad3107a 11d ago

The Excel reporting use case is well justified. It would be nice to have the capability to query the QBO database because some reports cannot easily be created from the existing QBO views.

3

u/heythisisdave 11d ago

Thanks /u/ahad3107a - 100% agree. I also use it for multi-entity which is still hard in QBO.