query_data
Execute SELECT queries on SQL Server databases with automatic pagination to retrieve table data efficiently while maintaining security by restricting DDL/DML operations.
Instructions
Execute a SELECT query on the SQL Server database with enforced pagination. Only SELECT queries are allowed - DDL and DML operations (CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, etc.) are rejected.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SELECT query to execute. Must be a SELECT statement. Do not include OFFSET/FETCH clauses as pagination is automatically applied. | |
| page | No | Page number (1-based). Defaults to 1. | |
| pageSize | No | Number of records per page. Must be between 1 and 1000. Defaults to 100. |