Supabase & Postgres

🟡 Query (Postgres)

Runs a SQL query on the given Postgres database. Inputs: in, schema, query. Outputs: out, on error, data (the query result), error.

🟡 Update (Supabase)

Updates an existing row in the given Supabase table. Inputs: in, table, schema, filters, columns. Outputs: out, on error, row (the updated row), error.

🟡 Insert (Supabase)

Inserts a new row in the given Supabase table. Inputs: in, table, schema, columns (the values of the new row). Outputs: out, on error, row (the inserted row), error.

🟡 UploadFile (Supabase)

Uploads a file to OpenAI, as listed in the Supabase integration. Inputs: in, type, purpose. Outputs: out, on error, error, fileId, fileName (the identifier and name of the uploaded file).

🟡 Remove (Supabase)

Deletes rows from the given Supabase table, with a warning that the whole table can be deleted if misused. Inputs: in, table, schema, filters, columns, count, error. Outputs: out, on error, count, error.

🟡 Select (Supabase)

Select (Supabase) selects rows from a given table, with optional filters and sorting of the result. Inputs: in, table, schema, filters, columns, rows, count, error. Outputs: out, on error, rows, count, error. It belongs to the Supabase connector.