raw_query
Run read-only SELECT queries on a MySQL database with automatic pagination and validation. Retrieve paginated results without modifying data.
Instructions
Execute a raw SELECT query on the database. This tool provides read-only access with automatic pagination. The query is validated to ensure only SELECT statements are allowed. Results are paginated to prevent overwhelming responses.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number for pagination (1-indexed). Default: 1 | |
| limit | No | Number of rows per page. Default: 100, Max: 1000 | |
| query | Yes | The SELECT query to execute. Only SELECT statements are allowed. |