Build an inventory report with MCP
Use an external AI client to compare stock quantities with configured minimums. The MCP version asks the client to fetch authorized records and complete pagination before describing the result as a full inventory review.
List inventory items below their configured minimum stock, with item code, unit, on-hand quantity, minimum, and shortfall. Explain the coverage of the result.
Opens an editable draft in Millbase. New here? Create your workspace first; your prompt will be waiting.
When to use it
You want a stock exception report in the AI client where you already work.
What you need
Millbase MCP with access to materials under operations:read, including on_hand and minimum_stock.
What you’ll get
- Low-stock materials compared in their own recorded units.
- A statement of pagination coverage or any limits on the result.
How to use this prompt
- Select Try this prompt to open it in your Millbase composer. Sign up or sign in if needed.
- MCP reads data; it does not submit purchase orders or change your stock.
- Send the prompt and review the returned records, date range, and any missing information.
Use it with Millbase MCP
Connect Millbase MCP to ChatGPT, Claude, or a compatible client, then paste this version. The MCP connection reads authorized records; it does not change workspace data.
Use Millbase MCP. Call list_resources, then query_data for the authorized materials fields: id, code, name, unit, on_hand, minimum_stock, active. Follow pagination to completion or report incomplete coverage. Compare on_hand with minimum_stock locally and list active items below minimum, with the shortfall and unit. Do not modify anything.