AI Connector - Available tools | AGR Knowledge Base

The AGR AI Connector is AGR's MCP server. MCP (Model Context Protocol) is an open standard that lets AI tools such as Claude connect to other systems. The connector gives your AI tool a set of connector tools: small, specific functions such as search items or explain order line quantity. When you ask a question, your AI tool chooses the connector tools it needs, often several, and uses them to get the answer from AGR. For example, to answer "Why is AGR suggesting 120 units of item X?" it may first look up the order, then ask AGR to explain the quantity on that order line.

This article lists every connector tool that's currently available, what each one is for, example questions, and the limits worth knowing. To connect your AI tool to AGR, follow the steps in AGR - AI Connector.

📌 Before you start

You don't need to know the connector tool names. Ask in plain language. The names are useful when you want to steer your AI tool or report a problem to us.
All connector tools are read-only. Your AI tool can read your AGR data but can't create, confirm or change anything in AGR.
Your AGR permissions apply. You can only see data through the connector that your AGR role already lets you see.

🗂️ Connector tools by area

Use this table to check whether your AI tool can reach a type of AGR data before you rely on it.

Area	Tools
Lookup tools	`GetAllLocations`, `GetAllVendors`, `GetUsers`, `GetItemId`, `GetItemIds`, `GetColumns`, `GetOrderColumns`, `GetArchivedOrderColumns`, `GetItemActivityPropertyTypes`
Items	`SearchItems`, `CountItems`, `GetItem`, `GetAllItemsForItemNo`, `GetItemHistoryLog`
Sales history, forecast and demand	`GetItemSaleHistory`, `ExplainItemSaleHistory`, `ExplainItemDemand`, `GetSalesPlansByItemIds`, `GetPromotionsByItemIds`, `GetEstimatedFutureOrdersAndDeliveries`
Orders	`SearchOrders`, `CountOrders`, `GetOrders`, `GetOrderIdsByStatus`, `GetOrderById`, `GetOrderLinesByOrderIds`, `GetOrderLinesById`, `ExplainOrderLineQuantity`, `GetOrderActivityLogs`
Archived orders	`SearchArchivedOrders`, `CountArchivedOrders`, `GetArchivedOrderLinesByOrderIds`
Scheduled orders	`GetScheduledOrders`, `GetScheduledOrder`
Undelivered and open sales orders	`GetUndeliveredOrders`, `GetOpenSalesOrders`
Reports	`GetReports`, `GetReport`
Data refresh	`GetDataRefreshHistory`

🧰 Available connector tools

Lookup tools

These connector tools find the IDs, names and column definitions that other tools need. Your AI tool usually calls them first, behind the scenes.

Tool	What it's for	Example questions	Limits and notes
`GetAllLocations`	Lists all locations with their ID, number, name and type (Vendor, Warehouse or Store).	Which locations do we have in AGR? List all our warehouses.	Used to turn a location name into the ID other connector tools need.
`GetAllVendors`	Lists all vendors with their ID, number and name.	List all vendors in AGR. What is the vendor number for vendor X?	Used to turn a vendor name into the ID other connector tools need.
`GetUsers`	Lists the users in your AGR environment.	Who has access to AGR?	Used to show user names, rather than IDs, in item history and order activity.
`GetItemId`	Finds the item ID for an item number at a specific location.	Get the item ID for BIKE-001 at warehouse 01.	Requires both the item number and the location.
`GetItemIds`	Finds the item IDs for an item number across all locations.	Find item BIKE-001 in every location.	—
`GetColumns`	Lists the item columns you can filter on, with their caption, description and type.	Which item columns can I filter on?	—
`GetOrderColumns`	Lists the columns for live orders, including the accepted values for columns such as status and exceptions.	Which order exceptions can I filter by?	—
`GetArchivedOrderColumns`	Lists the columns available for archived orders.	Which columns are available for archived orders?	A smaller set than for live orders. Planning columns such as stock, cost and lead time aren't stored for archived orders.
`GetItemActivityPropertyTypes`	Lists the change categories you can use to filter item history.	What kinds of changes can I filter item history by?	—

Items

Find items, count them, and see the full detail and history of a single item.

Tool	What it's for	Example questions	Limits and notes
`SearchItems`	Finds items that match one or more column criteria and returns their item number, name and location.	Show me all AA-classified items. Which items are overstocked at location 01? Find items with Risk of Stockout.	Returns 50 items by default. Ask for a count to get the total. Text columns match partial text. Number columns support comparisons and ranges. Date columns can't be used as filters.
`CountItems`	Counts the items that match one or more column criteria.	How many items are overstocked? How many items have no stock?	Counts the primary order route for each item by default.
`GetItem`	Returns full detail for one item: stock, stock health, replenishment settings, safety stock, forecast snapshot, sales totals, ABC classification, BOM, service level, scheduled orders, stock expiry and custom columns.	What are the lead time and safety stock for item X at warehouse 01? What is the stock health of item X? Is item X a BOM component?	Returns current values only, not period-by-period figures. Doesn't include sales plan or promotion values. See Sales history, forecast and demand.
`GetAllItemsForItemNo`	Returns the same item number in every location.	What is the current stock of item X across all locations?	Returns up to 50 locations by default.
`GetItemHistoryLog`	Returns the item's history, as shown in Item history in AGR: ABC classification changes, order generation, item setting changes, sales plan changes and more, with who made each change and when.	Who changed the lead time on item X? Show the ABC classification changes for item X this year.	Returns the 50 most recent entries by default. Can be filtered by change category and by user.

Sales history, forecast and demand

See historical sales, understand where the figures come from, and look ahead at forecast, sales plans, promotions and the purchase plan.

Tool	What it's for	Example questions	Limits and notes
`GetItemSaleHistory`	Returns an item's sale history at one location, by week or month.	Show monthly sales for item X at location 01 for the last two years.	Returns 24 periods by default, up to five years (60 months or 260 weeks). Daily figures aren't available. Shows the sale displayed in AGR, which can include adjustments, so it may differ from your ERP. Periods with no sale are left out. The current period is period-to-date.
`ExplainItemSaleHistory`	Explains which source produced the sale AGR shows in each period: Adjusted Sale, Connected Sale, Bridged Stockout Sale, Smoothed Promo Sale, Customer Breakdown Sale, Legacy Sale or Actual Sale.	Why does AGR's sale history for item X differ from our ERP? Was last March's sale for item X adjusted? Why did sales for item X spike in June?	By week or month. 24 periods by default, up to five years. Doesn't say which connected item supplied a Connected Sale. Check the Connected Items page in AGR.
`ExplainItemDemand`	Breaks down, month by month, how total demand is built: statistical forecast, forecast override, sales plan, promotions, sales orders, BOM demand and distribution demand.	Why is total demand for item X higher than the forecast? Is a forecast override applied to item X? How much BOM demand does item X have?	Monthly figures only, so not suited to questions about a specific order period.
`GetSalesPlansByItemIds`	Returns the statistical forecast, forecast overrides and sales plan per period for one or more items.	What is the forecast for item X for the next 12 months? Which months have a forecast override for item X?	By day, week or month. Returns the next 6 periods by default. Values are totals across all customer groups. The current period is shown in two parts: the days already passed and the days still to come.
`GetPromotionsByItemIds`	Returns planned promotion demand per period for one or more items.	Are any promotions planned for item X in the next six months?	Returns upcoming periods only by default. Ask for past periods if you need them. The current period is shown in two parts, as above.
`GetEstimatedFutureOrdersAndDeliveries`	Returns the purchase plan for one item: Estimated Future Orders (when AGR expects you to order) and Estimated Future Deliveries (when those orders should arrive).	When does AGR expect we need to order item X next? What deliveries are expected for item X over the next six months?	One item at a time. By day, week or month. Quantities are in the item's base unit.

Orders

Find and count live orders, look inside them, see why a quantity was suggested, and see who changed what.

Tool	What it's for	Example questions	Limits and notes
`SearchOrders`	Finds live orders that match criteria such as status, vendor, location, origin, dates, exceptions or quantities.	Show unconfirmed orders for vendor X. Which orders have the No Demand exception? Which scheduled orders were created this week?	Returns 50 orders by default. One row per order, with quantities summed across its lines. Covers live orders only. For older orders, see Archived orders.
`CountOrders`	Counts live orders that match the same criteria as `SearchOrders`.	How many unconfirmed orders do we have?	Counts orders, not order lines.
`GetOrders`	Lists live orders.	List our current orders.	Returns 50 orders by default.
`GetOrderIdsByStatus`	Lists the IDs of orders with a given status: Unconfirmed, Confirmed or Transferred.	Which orders are confirmed but not yet transferred?	Returns 500 IDs per page by default, up to 1,000.
`GetOrderById`	Returns one order, including its order lines.	Show me order 1234.	—
`GetOrderLinesByOrderIds`	Returns all lines for one or more orders, including the suggested quantity, the quantity being ordered, and a short explanation of how the quantity was calculated.	Which lines in order 1234 were changed by hand? Summarize the lines in orders 1234 and 1235.	Returns 200 lines per page by default, up to 500.
`GetOrderLinesById`	Returns specific order lines by their line ID.	Show me order line 5678.	—
`ExplainOrderLineQuantity`	Gives a step-by-step breakdown of how AGR calculated the suggested quantity for one order line: demand for the order period, stock on hand, undelivered orders, safety stock, min stock, lost sales, min/max logic and rounding.	Why is AGR suggesting 120 units of item X in order 1234? What is driving the quantity up on this order line?	One order line at a time.
`GetOrderActivityLogs`	Shows changes to orders: order creation, line edits (including bulk edits), confirm, unconfirm, transfer and delete, and order setting changes.	Who changed the quantities on order 1234? Which orders did Anna confirm last week?	Needs an order, a user, or both. Returns the 50 most recent entries by default.

Archived orders

Orders move to the archive once they haven't been touched for your retention period (8 days by default). Live and archived orders don't overlap, so to cover all orders your AI tool searches both.

Tool	What it's for	Example questions	Limits and notes
`SearchArchivedOrders`	Finds archived orders that match criteria such as status, vendor, location, origin or dates.	Show scheduled orders for vendor X from last quarter. Which orders did we transfer in March?	Returns 50 orders by default. Planning columns such as stock, cost, lead time and exceptions aren't available for archived orders.
`CountArchivedOrders`	Counts archived orders that match the same criteria.	How many orders did we transfer last month?	Counts orders, not order lines.
`GetArchivedOrderLinesByOrderIds`	Returns the lines of one or more archived orders.	Which lines in archived order 987 were changed by hand?	Returns 200 lines per page by default, up to 500.

Scheduled orders

Tool	What it's for	Example questions	Limits and notes
`GetScheduledOrders`	Lists your scheduled orders with the receiving location, where the order is placed (vendor or internal location), which items are included, and the schedule.	Which vendors have scheduled orders? When are the next scheduled orders for warehouse 01?	Returns 50 scheduled orders by default.
`GetScheduledOrder`	Returns the full setup of one scheduled order.	Show me the setup of scheduled order 12.	—

Undelivered and open sales orders

Tool	What it's for	Example questions	Limits and notes
`GetUndeliveredOrders`	Returns undelivered purchase order lines for a location, an item or a purchase order reference, with the estimated delivery date.	What is on order for item X, and when is it expected? What is still undelivered on PO-10045?	Needs one of: location, item or purchase order reference. Returns 50 lines by default.
`GetOpenSalesOrders`	Returns open sales order lines with the customer, reference, quantity and estimated delivery date.	What open sales orders do we have for customer X? Which sales orders are due for delivery on Friday?	Returns 200 lines by default.

Reports

Tool	What it's for	Example questions	Limits and notes
`GetReports`	Lists the reports you can see, with their name, description, group and whether they are a favorite.	Which reports do I have in AGR? Show my favorite reports.	—
`GetReport`	Returns a report's columns, filters and the items in it.	Show the items in my Overstock report.	Returns 50 rows by default, with more available page by page.

Data refresh

Tool	What it's for	Example questions	Limits and notes
`GetDataRefreshHistory`	Shows recent AGR data refreshes with start time, end time and status, and whether a refresh is running now.	When was AGR data last updated? Did last night's data refresh finish successfully? Why does my data look out of date?	Returns the 10 most recent refreshes by default.

💡 Tips for better answers

Use item and location numbers where you can. For example, "item BIKE-001 at location 01" is faster and more precise than an item name.
Ask why. Follow-up questions such as "Why is demand so high?" or "Where does this sale figure come from?" use the explain connector tools to show how AGR got to a number.
Use AGR's terms. Words like Safety Stock, Stock Health, Forecast Override and Undelivered match how data is labelled in AGR.
Check before you act. Your AI tool writes the answer, not AGR. For decisions about orders, stock or customers, verify the figures in AGR first.

🔄 This list will grow

We're adding new connector tools, including ones that can make changes in AGR. If your AI tool couldn't answer a question you expected it to, let us know what you asked, what you expected, what you got, and which AI tool you used.