rest_query
Query or mutate database tables via PostgREST REST API, supporting GET, POST, PATCH, and DELETE methods with custom query parameters.
Instructions
Query or mutate data via the PostgREST REST API. Supports GET/POST/PATCH/DELETE with query params.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| body | No | Request body for POST/PATCH (JSON object or array) | |
| table | Yes | Table name to query | |
| method | No | HTTP method | GET |
| params | No | PostgREST query params (e.g. {select: 'id,name', order: 'id.asc', limit: '10'}) | |
| key_type | No | Which key to use: anon (default, respects RLS) or service (bypasses RLS) | anon |
| project_id | No | The project ID (defaults to the active project) |