Query database
query_databaseExecutes read-only SQLite SELECT queries against the e-commerce database, returning paginated results with bind parameters for safe data retrieval.
Instructions
Executes exactly one read-only SELECT or WITH ... SELECT query. Data definition, data modification, transactions, attachments, PRAGMA, and multiple statements are refused. Pagination is server-applied and results include paging metadata; include stable ORDER BY when retrieving multiple pages.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | One read-only SQLite SELECT query. CTEs beginning with WITH are allowed when their final statement is SELECT. Do not send multiple statements or PRAGMA. Use parameter placeholders for values supplied through parameters. | |
| page | No | One-based page number. | |
| pageSize | No | Maximum rows returned for this page; server maximum is 100. | |
| parameters | No | Optional positional values bound to ? placeholders, in order. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||