get_products
Find products by exact category, stock availability, and price bounds. Apply min/max price and inStock filters to get matching items.
Instructions
List products. category must be an existing product category (validated against the DB). inStock filters to stock_quantity > 0. minPrice/maxPrice filter by price. Sorted by id by default.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows to return. | |
| offset | No | Number of rows to skip. | |
| inStock | No | When true, only return products with stock_quantity > 0. | |
| category | No | Exact product category. Must match one of the existing distinct categories in the database. | |
| maxPrice | No | Only products with price <= this value. | |
| minPrice | No | Only products with price >= this value. |