List every table in the store database with its row count. Start here when exploring.

Show the column definitions and three sample rows for one table.

Find products by keyword, category, price range or stock availability.

Look up a customer by id, email or partial name, and return their orders with line items already joined.

Aggregate sales over a date range, grouped by month, product category, brand, customer prefecture or order status. Cancelled orders are excluded unless grouping by status.

Rank products by revenue, units sold or average review rating over a date range.

Full-text search over review bodies. Returns matching reviews with the product they are about. Use this for questions about what customers say ("どの商品で破損の報告が多い?"), as opposed to search_products which only matches product names.

Insert a new review row for a product. This modifies the database.