query
Run read-only SELECT, WITH, VALUES, TABLE, or SHOW against PostgreSQL to inspect runtime state safely; results are bounded and sensitive values redacted.
Instructions
Run one read-only SQL statement (SELECT, WITH, VALUES, TABLE, SHOW) against PostgreSQL. Runs in a read-only transaction that is always rolled back, with server-side timeouts. Results are bounded: has_more means more rows existed (truncated_by says whether the row cap or byte budget stopped retrieval), and long values are cut with a …[+size] marker. Columns with sensitive-looking names (password, token, api_key, ...) come back as [redacted], counted in columns_redacted and values_redacted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single read-only SQL statement |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| columns | Yes | ||
| has_more | Yes | ||
| warnings | No | ||
| row_count | Yes | ||
| duration_ms | Yes | ||
| truncated_by | Yes | ||
| values_redacted | Yes | ||
| columns_redacted | Yes | ||
| values_truncated | Yes |