io.github.shahidla/cds-db-nlquery-mcp

Using the SAP CAP data model, query each customer's total orders, total amount, and latest order time in the last 30 days, then return the top 20 sorted by total amount descending.

Returns joined query results with customer-level order aggregates and the top 20 ranked records.

Query products whose current stock is below safety stock and whose sales were high in the last 14 days. Join product, inventory, and sales detail tables, and output product name, current stock, safety stock, and 14-day sales.

Generates cross-entity joined results identifying potential stockout items with key inventory and sales metrics.

Aggregate this quarter's revenue, order count, and average order value by region, joining customer, order, and region entities, and identify regions with year-over-year revenue decline.

Outputs region-level aggregated analysis and flags declining regions for further investigation.