AIAI Reports
3.0For Magento 2.4 and Adobe Commerce

Ask your store's database
in plain English.

Your team types a question in the Magento admin, like "why isn't this product showing?" or "orders by country last month", and gets a checked answer or a downloadable table in seconds. No developer ticket.

  • Read-only by design
  • Your own AI key, about $0.11 a question
  • Every query logged
Illustration with sample data. In your store it lives under Reports › AI SQL Reports.
Works with Magento Open Source 2.4 Adobe Commerce 2.4 Anthropic Claude OpenAI Google Gemini
01 / The product

Questions in. Checked answers out.

One box in the admin for anyone you trust with the data: merchandisers, customer service, finance and developers. Pick a written answer or a table, and a quality level per question.

Answer mode

Every answer shows its work.

Open Details under any answer to see exactly what happened. Nothing is hidden, so your team can trust the result or spot a wrong assumption.

  • How it read your question, in plain words
  • What it looked up first: the real store view, SKU or category
  • The exact SQL it ran, read-only
  • Thorough double-checks tricky answers before you see them
Illustration with sample data
Table + CSV

A table when you need the rows.

Choose Table + CSV and it runs one query and gives you the rows, ready to download. No rows are ever sent to the AI in this mode.

  • Download CSV for spreadsheets and reports
  • Save as report and re-run it on today's data later
  • Saved reports cost nothing: no AI call when you re-run
Illustration with sample data
AI Knowledge

It learns how your store works.

A snapshot of your installation is built automatically: every table, attribute, store view and the module that owns it. Then you add what the database can't tell.

  • Business rules in plain words, like "revenue means invoiced orders"
  • 👍 approves an answer as an example for similar questions
  • Test a question to see what the AI would be told, with no AI call
Illustration with sample data
Usage and budget

Costs you can see, and cap.

You pay your AI provider directly, so the module shows what every question costs and who's asking. Set a monthly budget and a daily limit per person if you want a hard stop.

  • Quick, Standard or Thorough per question
  • Today, this month and all-time spend, per person
  • Prompt caching and re-used answers keep it low
Illustration with sample data
02 / What teams ask

If it's in the database, just ask.

Product visibility, stock, orders, customers and store setup. A few of the questions it answers every day:

CatalogWhy is SKU 24-MB01 not showing in the Outdoor store view? OrdersOrders and revenue by country last month CustomersCustomers who ordered 3+ times but not since June CatalogWhich enabled products have no image? SetupWhich attributes are set per store view? OrdersOrders still pending payment after 2 days CatalogProducts in Sale with no special price
OrdersTop 20 coupon codes this quarter CatalogOut-of-stock products that are still visible CustomersNew customers per website this year SetupWhich modules add columns to sales_order? OrdersAverage order value per store view in October CatalogConfigurable products with a disabled child SetupWhich cron jobs failed today?
03 / How it works

Running in about 15 minutes.

No new servers and no data leaving your control, except the questions you send to your own AI provider.

01

Install

One Composer command with your licence key, plus a read-only MySQL user your database admin creates. The docs walk you through it.

02

It learns your store

A snapshot of your tables, attributes, store views and modules builds itself in seconds, then refreshes every week.

03

Ask

Anyone you give access to opens Reports › AI SQL Reports and asks. Answers usually take 5 to 40 seconds.

04 / Built for real stores

It knows your store, not just Magento.

Generic AI-to-SQL tools break on real installations: custom attributes, third-party tables, columns added to core tables, brands as store views, rules that live in code. AI Reports is built for exactly that.

Store snapshot

Websites, store views, every attribute with its options, every table and column, and which module owns it. Rebuilt weekly and after changes.

Your business rules

Write down what the database can't tell, like "visibility depends on customer group". The AI treats your rules as authoritative.

Checks before it guesses

Before writing a query, it looks up the real store view, SKU, category or column values, so filters match what exists.

Two modes

Answer explains what it found, with evidence. Table + CSV runs one query and gives you the rows to download.

Learns with approval

A 👍 turns an answer into an example. The same question asked again re-runs the approved query with no AI cost.

Costs under control

Quick, Standard or Thorough per question. Prompt caching, a monthly budget, a daily limit per person, and saved reports that cost nothing to re-run.

05 / Measured

Tested on a real, complicated store.

An Adobe Commerce 2.4.8 installation with more than 700 modules, content staging, multi-source inventory, B2B and over 30 store views. Nine real questions with known answers, covering product visibility, stock, orders and store setup.

9 of 9answered correctly
$0.11average cost per question
6–39 stime per answer
0writes to the database

Standard preset, Claude Opus 5.5, November 2026. Your results depend on your store and your questions. The module includes the same test runner, so you can measure on your own data.

06 / Safe by design

Read-only, at every layer.

It runs AI-written SQL against production, so safety never rests on a single check.

Anyone with access reads every non-blocked table across all websites, so grant it only to roles that may see that data.

  • A separate read-only MySQL user, set only in env.php, plus a forced read-only session.
  • One SELECT per query. Comments, multiple statements, variables, system schemas and file functions are rejected.
  • Credential tables are never readable, such as admin users, tokens, API keys, payment tokens and config. The AI is never told they exist.
  • Row limits and a statement timeout on every query.
  • Personal and payment data is masked in anything sent back to the AI. Table + CSV mode sends no rows at all.
  • Full audit log of every question, query, user, token count and cost.
  • Your AI key, your data. Questions go straight from your server to your AI provider. We never see them.
Gaurav Harsh
07 / Who's behind it

Built by a Magento developer, not a sales team.

Hi, I'm Gaurav Harsh. I work as a Magento and Adobe Commerce developer at an agency, on large stores with hundreds of modules. I built AI Reports because the same questions kept landing on developers: why isn't this product showing, which products have no image, what sold best last month.

It started as a free open-source module, and version 2 still is. When you email, you're talking to the person who wrote the code.

08 / Pricing

Simple yearly pricing, per store.

Staging, test and local copies are included. If you stop renewing, you keep every version you received, forever.

Open Source
Magento Open Source, one store
$399 / year
  • One production installation
  • All features and updates
  • Business rule packs
  • E-mail support
Buy
Agency
For agencies managing client stores
$2,499 / year
  • Up to 10 production installations
  • Any edition
  • All features, updates and rule packs
  • Priority e-mail support
Buy
14-day money-back guaranteeNot right for your store? E-mail us within 14 days for a full refund.

Prices in USD, before tax. Checkout is handled by Polar, which also handles VAT and sales tax. AI usage is billed by your AI provider, not by us.

09 / Questions

Good questions, answered.

Can I try it before buying?

Yes. Ask for a free 14-day trial key and install it on your store, or try the free open-source version 2 on GitHub. Every plan also comes with a 14-day money-back guarantee.

What if it doesn't work for our store?

E-mail us within 14 days of buying and you get a full refund, no questions asked. We'd still like to hear what went wrong, because that's how the product gets better.

Does my store data go to you?

No. Questions, queries and results go from your server to the AI provider you choose, under your own account. The only call to us is a daily licence check that sends the licence key, your domain and the module and Magento versions.

What does the AI usage cost?

On our test store a question averaged $0.11 with Claude Opus 5.5, from $0.04 for simple counts to $0.37 for a full "why isn't this showing" diagnosis. The Quick preset costs about half. Saved reports and re-used approved answers cost nothing.

Which AI providers work?

Anthropic (recommended), OpenAI, Google Gemini, or any OpenAI-compatible endpoint. You pick a model for each quality preset.

Can it change or delete data?

No. It connects as a separate MySQL user that only has SELECT, forces a read-only session, and rejects anything that isn't a single SELECT before it reaches the database.

Can I use one licence on staging and production?

Yes. One key works on every environment. Local, test and staging domains, including Adobe Commerce Cloud integration and staging environments, never count towards your limit; only production stores do.

What happens if I don't renew?

Everything keeps working. You keep every version released while your plan was active, and Composer can still install them. You stop getting new versions, rule packs and support until you renew.

What are the requirements?

Magento Open Source or Adobe Commerce 2.4 on PHP 8.2 or 8.3, MySQL or MariaDB, and an API key from an AI provider. Tested on Adobe Commerce 2.4.8 with MariaDB 10.6.

Give your team the answers.

Install it in about 15 minutes, keep your data on your server, and stop writing tickets for simple questions.