Get started

InsightsWhy AI built for work

Inventory right now: does the AI chatbot know today's count?

The chatbot reads last month's number

A sales rep asks the company's AI chatbot, "How many units of product A do we have in stock right now?" The chatbot finds the inventory report posted at the end of last month and answers with the number in it. The sentence sounds confident. The number is a month old.

Nothing is broken. Documents are all the chatbot can read, so it pulled the number from the most recent one. Today's inventory isn't in a document; it's in the database behind your business systems. When a question asks for a number, OwlAI queries the connected database on the spot and answers from that.

A document stops on the day it was written

Most of these chatbots answer through document search. They find passages that look like the question, hand them to the AI, and the AI writes its answer from those passages. The industry calls this RAG (retrieval-augmented generation). For knowledge that rarely changes, such as policies, procedures, and product descriptions, it works quite well.

The catch is that a document is frozen at the moment it was written. Numbers that move every day, such as inventory, orders, and receivables, are already out of date when they land in a document. A document-search AI can know only the latest number someone happened to write down.

A slightly different question is enough to stop it. If the report has only totals by branch, "last week's return rate at the Seoul branch" isn't in any document. That number exists only after someone re-aggregates the source data.

Answers to "how many" and "how much" live in the database

Many of the questions people ask at work start with "how much," "how many," or "who has the most." Their answers sit in the databases of your business systems. Until now, someone pulled the data out of the system and organized it in Excel, and it took days for the result to come back as a report.

Same inventory question, two answers: last month's report vs. today's database
Figure 1. Same inventory question, two answers: last month's report vs. today's database

Numbers come from the database, criteria from documents

OwlAI uses both document search and database queries as tools, and its AI decides which one a question needs. A policy question gets a document search, a question about numbers gets a direct query against the connected database, and a question that needs both gets both. Ask "How many orders qualify for return this week under our return policy?" and it finds the criteria in the policy document, then queries the order data with those criteria.

The database query runs fresh for every question, so the answer reflects the data at the moment you asked. Results come back as a table you can copy or download as an Excel file. To see which queries it ran, expand Thinking above the answer.

OwlAI does not change your data. It only reads the connected databases, and it queries only the databases an administrator has allowed for each role. Databases connected through OwlDB can be opened table by table. This series covers that in detail in “Put AI on the production database, and security asks three questions”.

Questions no longer wait for the reporting cycle

What changes is the time it takes to get a number in hand. Business staff ask for the number they need on the spot, then ask again with different conditions. Data staff get fewer simple extraction requests. Executives see current numbers even between regular reports.

Curated reports are still needed. But a one-line question like "How many do we have right now?" shouldn't have to wait for the next one. If you're evaluating this, start by checking how many of the questions your chatbot actually gets ask for numbers, and which databases hold those numbers.