rest_query
Send HTTP requests to PostgREST to query or alter Postgres data, supporting GET, POST, PATCH, DELETE and query parameters for filtering, sorting, and pagination.
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) |