run_query
Execute read-only SELECT queries to retrieve structured rows from PostgreSQL, with optional parameters, role, limit, and offset for controlled pagination.
Instructions
Execute a read-only SELECT query and return structured rows (FR-003)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only SQL query to execute (e.g. SELECT) | |
| role | No | Optional PostgreSQL role to assume (SET ROLE) for this query only | |
| limit | No | Maximum number of rows to return (capped by server maxRowLimit) | |
| offset | No | Number of rows to skip before returning results | |
| params | No | Optional parameterized query values ($1, $2, etc.) |