You can analyse your PrestaShop store without installing anything on it. BeQuery connects to your MySQL database with a read-only user, clones it to an isolated PostgreSQL copy, and runs every dashboard, report and query there — so your shop stays fast and untouched.
A read-only database user is all it takes — we even generate the GRANT for you. Nothing is installed in your PrestaShop.
Heavy joins on ps_order_detail run on the clone, not on the database serving your customers during business hours.
Revenue, profit, restock, LTV and cohorts out of the box — and the freedom to ask anything in plain English or write your own SQL.
Every sync is integrity-checked, and the result is shown on your dashboard.
Correct — BeQuery connects to your MySQL database directly with a read-only user. No module, no plugin, no code on your shop.
Any version whose data lives in MySQL — 1.6, 1.7, 8.x and 9.x all use the core tables BeQuery understands.
Syncs read in bounded batches, usually overnight. All analytics then run on the clone, so your shop never sees a reporting query.
Free tier, no credit card, setup in 5 minutes. Production is never touched.
Start free