rest_query
Query or mutate database tables using RESTful operations with PostgREST. Supports GET, POST, PATCH, DELETE and customizable 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 |
|---|---|---|---|
| project_id | No | The project ID (defaults to the active project) | |
| 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'}) | |
| body | No | Request body for POST/PATCH (JSON object or array) | |
| key_type | No | Which key to use: anon (default, respects RLS) or service (bypasses RLS) | anon |