rest_query
Query or mutate Postgres database tables using GET, POST, PATCH, DELETE methods with PostgREST query parameters and optional RLS bypass.
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) |