read_records
Retrieve records from a SQL Server table with optional column selection, filtering, ordering, and pagination for efficient data access.
Instructions
Read/Select records from a table with optional column selection, WHERE filtering, ordering, and pagination.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return (default: 100). | |
| offset | No | Row offset for pagination (default: 0). | |
| params | No | Parameter values for the WHERE clause placeholders. | |
| columns | No | Specific list of columns to retrieve. | |
| order_by | No | SQL ORDER BY expression (e.g., "id DESC"). | |
| table_name | Yes | Target table name. | |
| schema_name | No | Target schema name (default: 'dbo'). | dbo |
| where_clause | No | SQL WHERE clause expression (e.g., "status = ? AND created_at > ?"). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |