Data Operations

Data CRUD operations

📄️ Query Records

Query data in table, supports complex queries, join queries, pagination, sorting, etc.

📄️ Count Data Records

Count data records in table that match conditions

📄️ Insert or Upsert Records

Insert single or multiple records, supports upsert operation

📄️ Update Records

Update data according to conditions, WHERE conditions must be provided

📄️ Delete Records

Delete data according to conditions, WHERE conditions must be provided

📄️ RPC Call

Call stored procedures or custom functions in PostgreSQL (powered by PostgREST RPC). Supports passing parameters and returns function execution results.