Safe analytics for PrestaShop · WooCommerce · Magento

Know your store cold.
Never touch production.

BeQuery clones your MySQL database to a verified, isolated copy — then the answers come to you: ready-made dashboards, scheduled reports, alerts and an AI weekly digest. Flat monthly price, zero load on your shop.

Free tier No credit card Read-only — never writes to your shop
app.bequery.pro
BeQuery Insights: revenue, orders and restock dashboards built automatically from your store data

In production — a real store, synced every night

108M+

rows synced

567

tables mirrored

~28 min

nightly full sync

100%

integrity-verified

NewInsight dashboards, scheduled reports, business alerts and an AI weekly digest just shipped.See what's new

Built for teams running MySQL in production

PrestaShopWooCommerceMagentoWordPressLaravelDrupal

Analytics on production is dangerous

Heavy queries slow down your app. One wrong JOIN can lock tables and take your site offline. Your team needs data access, but not at the cost of uptime.

Production risk

Complex analytics queries compete with user traffic, causing slowdowns and potential downtime.

Limited access

Security policies prevent most team members from getting direct database access. Data stays siloed.

Expensive alternatives

Traditional cloud warehouses charge per query, leading to unpredictable monthly bills and budget anxiety.

From MySQL to insights in 5 minutes

No ETL pipelines. No data engineering. Just connect and query.

MySQLyour production DBverified syncintegrity-checked, read-onlyCloneisolated PostgreSQL📊 dashboards📬 reports🔔 alerts
01

Connect your MySQL

Enter your credentials. We test the connection instantly. Select which tables you need — your data, your choice.

02

Automatic sync

BeQuery clones your selected tables to an isolated PostgreSQL environment. Schedule hourly, daily, or weekly syncs.

03

Query freely

Use our SQL editor with syntax highlighting, schema explorer, saved queries, and CSV export. Zero impact on production.

The answers come to you

Connect a database and BeQuery does the rest: dashboards built for your platform, reports in your inbox, alerts when numbers move — plus a full SQL editor when you want to dig deeper.

New

Insight dashboards, zero SQL

BeQuery detects PrestaShop or WooCommerce and builds the answers automatically: revenue vs last period, top products, what to restock before it runs out, declining products, top customers.

New

Reports that arrive by themselves

Schedule any saved query and its results land in your inbox — daily or weekly, to whoever needs them. The Monday numbers, delivered before anyone asks.

New

Business alerts

Get an email when a number crosses a threshold: today's orders too low, a bestseller almost out of stock. Checked every hour on fresh data.

New

AI weekly digest

Every Monday, a plain-language story of your store's week — what grew, what dropped, what needs attention. Real numbers, no dashboard-digging.

New

Verified data you can trust

After every sync we verify the clone against the source and show you the result. Integrity checks aren't a promise — they're on your dashboard.

AI

Ask AI — plain English to SQL

Describe what you want in English or Italian. AI reads your schema, writes the query, and self-checks it against the database before you run it. No SQL needed.

Charts on every result

Turn any query into a bar, line, or pie chart in one click. Built for the non-technical people on your team, not just the SQL writers.

AI

MySQL → PostgreSQL translator

Paste a MySQL query, get valid PostgreSQL — DATE_FORMAT, GROUP_CONCAT, backticks, LIMIT x,y, all handled.

Ready-made query templates

Top products, abandoned carts, customer LTV for PrestaShop, WooCommerce and Magento — run them on day one.

Professional SQL editor

Monaco editor with live linting, inline error hints, a schema explorer and query history.

Complete tenant isolation

Each team gets its own PostgreSQL schema, cryptographically separated from everyone else.

Scheduled & real-time syncs

Weekly, daily, hourly — or near real-time, about every minute. Your clone stays fresh with zero manual work.

Team collaboration

Invite your team across 5 roles — Owner, Admin, Developer, Editor, Viewer — with granular permissions.

AES-256 encrypted credentials

Database credentials encrypted at rest with AES-256-GCM. Plaintext passwords are never stored.

Automatic type mapping

MySQL INT, VARCHAR, JSON, ENUM, DATETIME — every type mapped to its PostgreSQL equivalent automatically.

In production

A 108-million-row store runs on BeQuery every night

One of the production PrestaShop stores on BeQuery mirrors its entire database every night — analytics, exports and reporting all run on the clone, and the shop never feels a thing. These are the real numbers from that account.

108M+

rows kept in sync

567

tables, every night

~28 min

full nightly sync

100%

integrity-verified runs

Same store, same 108M rows — three generations of the engine

First engine · serverless, chunked runs

2h 50m

Optimized copy · keyset paging + bulk COPY

~65 min

Today · dedicated always-on infrastructure

~28 min

Integrity verified— every run, checked against the source

Built for MySQL-first teams

For teams running MySQL who need analytics access. Not everyone needs a petabyte-scale data warehouse.

Setup time
5 minutes
vs. Hours to days
Pricing model
Flat monthly or capped usage
vs. Per-query, unbounded
Surprise bills
Never (hard cap protects you)
vs. Common
MySQL support
Native
vs. Requires ETL pipeline
Learning curve
Standard SQL
vs. Custom dialect
Team management
Built-in
vs. Separate IAM setup
Self-serve analytics
Immediate
vs. Needs data engineering

Pricing that scales with your stores

Pick by how many databases you sync and how fresh you need the data. Every plan includes AI query, charts, and exports.

Starter

Free

Try BeQuery on a single store

Get Started
  • Weekly sync
  • 1 database
  • 3 tables
  • 1 seat
  • AI query, charts & CSV export
  • Insight dashboards
  • 1 weekly email report · 1 alert
  • Up to 100k rows (fair use)
Most popular

Pro

€49/month

One store that needs fresh data every day

Start Free Trial
  • Daily sync
  • 3 databases
  • Unlimited tables
  • 5 seats
  • Query history & saved queries
  • Insight dashboards
  • 10 scheduled reports (daily/weekly)
  • 5 business alerts
  • Email support
  • Up to 5M rows (fair use)

Business

€149/month

Agencies and multi-store operations

Start Free Trial
  • Hourly sync
  • 10 databases
  • Unlimited tables
  • 20 seats
  • Custom sync schedules
  • 30 scheduled reports · 20 alerts
  • AI weekly digest
  • Priority support
  • Up to 50M rows (fair use)

Most teams with one PrestaShop or WooCommerce store start on Pro.

Need more scale or real-time?

Scale

€349/month

Real-time data for high-volume operations

  • Real-time sync (~1 min)
  • 25 databases
  • 50 seats
  • 100 scheduled reports · 50 alerts
  • AI weekly digest
  • Dedicated support
  • Up to 250M rows (fair use)
Start Free Trial

Enterprise

€699/month

Maximum capacity, SLA and compliance

  • Real-time sync
  • Unlimited databases & rows
  • Unlimited seats
  • 24/7 dedicated support
  • Custom SLA & DPA
  • SSO & audit logs
Contact Sales
New • Usage-based billing

Or go Pay-as-you-go with BeQuery Cloud

Store unlimited rows. Pay only for what you query — with predictable spending caps that keep your bill safe.

BeQuery Cloud

Perfect for teams with large datasets and variable query volumes.

Base subscription

Platform access + storage engine

€29/mo

Query usage

Metered from the first row

€0.60 / 1M rows

Storage

Per gigabyte per month

€0.025/GB/mo

Try Cloud plan

What's included

  • Unlimited databases, tables, and members
  • Hourly sync · ad-hoc queries anytime
  • Insight dashboards, reports & alerts — never metered
  • Priority support

Budget protection

  • Soft alert by email (default €100)
  • Hard cap that blocks queries (default €500)
  • Live usage dashboard

Why Cloud works for SMB

Transparent pricing

€0.60 per 1M rows read

Budget safe

Hard cap stops charges

No commitment

Cancel or switch any time

Need custom infrastructure or on-premise deployment? Talk to our sales team

Stop risking your production database

Join teams who query their MySQL data safely. Set up in 5 minutes, start getting insights today.