wp_postmeta is where analytics queries go to die. BeQuery clones your WooCommerce database to an isolated PostgreSQL copy and answers the questions your wp-admin reports can't.
Orders as posts, totals as meta rows: real questions need joins that crush MySQL. We run them on the clone, in PostgreSQL, with proper indexes.
Analytics plugins add load, tables and attack surface to the same server that's serving customers. BeQuery adds nothing to WordPress — it connects to the database directly.
The built-in analytics can't answer restock velocity, customer LTV or category margins. With BeQuery it's a saved query — or a card that's already there.
Connect and BeQuery recognises WooCommerce, then builds these automatically:
The insight pack reads the classic post-based schema today (the vast majority of stores). HPOS stores can use the full SQL editor and AI on the lookup tables — HPOS-native cards are on the roadmap.
No. BeQuery connects to your MySQL database directly with a read-only user — nothing is added to WordPress.
Syncs read in bounded batches over one connection, typically overnight. All analytics then run on the clone — your WordPress never sees a reporting query again.
Prefer SQL? These templates run on your clone from day one.
Best-selling WooCommerce products by quantity, from the order line items.
WooCommerce revenue grouped by month from completed and processing orders.
Rank WooCommerce customers by total spend across their paid orders.
Free tier, no credit card, read-only access — we even generate the MySQL GRANT statement for you.
Start free