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
It's disabled in the Outdoor store view only.
- Enabled by default, but a store-view override sets status = Disabled for Outdoor (store 3).
- It's in the right website and in stock, so the override is the only blocker.
- Fix: remove the store-view override, or set it to Enabled.
| Country | Orders | Revenue | Avg. order |
|---|---|---|---|
| United States | 1,284 | $162,410 | $126.49 |
| Canada | 412 | $49,870 | $121.04 |
| United Kingdom | 236 | $28,115 | $119.13 |
| Germany | 171 | $21,960 | $128.42 |
| Australia | 98 | $12,904 | $131.67 |
1,942 new customer accounts in October 2026, up 12% on September (1,734).
- Counted by account creation date, across all websites.
- Guest checkouts aren't included.
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.
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
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
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
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
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:
Running in about 15 minutes.
No new servers and no data leaving your control, except the questions you send to your own AI provider.
Install
One Composer command with your licence key, plus a read-only MySQL user your database admin creates. The docs walk you through it.
It learns your store
A snapshot of your tables, attributes, store views and modules builds itself in seconds, then refreshes every week.
Ask
Anyone you give access to opens Reports › AI SQL Reports and asks. Answers usually take 5 to 40 seconds.
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.
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.
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.
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.
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.
Simple yearly pricing, per store.
Staging, test and local copies are included. If you stop renewing, you keep every version you received, forever.
Launch offer: 50% off your first year on every plan, until 31 December 2026 (11:59 PM India time). Applied automatically at checkout.
- One production installation
- All features and updates
- Business rule packs
- E-mail support
- Content staging and B2B support
- One production installation
- All features, updates and rule packs
- Priority e-mail support
- Up to 10 production installations
- Any edition
- All features, updates and rule packs
- Priority e-mail support
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.
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.