rest_query
Query or mutate database tables via REST API. Choose HTTP method, set PostgREST query parameters, and select anon or service key for access.
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) |