query_database
Run read-only SELECT or WITH queries with parameter placeholders to inspect and analyze shop data. Use pagination to navigate results when more pages exist.
Instructions
Execute one parameterized read-only SELECT or WITH ... SELECT statement. Use ? placeholders and params for dynamic values. Joins and aggregate queries are supported; schema and data changes are forbidden. Results are paginated: use offset for the next page when hasMore is true. Inspect the schema instead of guessing column names, date formats, price fields, or order status semantics.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| limit | No | ||
| offset | No | ||
| params | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| limit | Yes | ||
| offset | Yes | ||
| columns | Yes | ||
| hasMore | Yes | ||
| rowCount | Yes |