Connect Data Stores to PostgreSQL

Add or update a single record in your Mazaal AI Data Store.

Add or update multiple records to your Mazaal AI Data Store.

Append to a record in your data store Mazaal AI Data Store. If the record does not exist, a new record will be created in an array format.

Check if a key exists in your Mazaal AI Data Store or create one if it doesn't exist.

Delete a single record in your Mazaal AI Data Store.

Delete all records in your Mazaal AI Data Store.

Get all records in your Mazaal AI Data Store. The memory consumption of the workflow can be affected, since this action will be exposing, to the workflow, the entire data from the selected datastore.

Get the difference between two data stores. Result contains key/value pairs where the key exists in one data store, but not the other. Mazaal AI Data Stores.

Get a single record in your Mazaal AI Data Store or create one if it doesn't exist.

Get all record keys in your Mazaal AI Data Store that matches with your query. The memory consumption of the workflow can be affected, since this action will be exposing, to the workflow, the entire data from the selected datastore

List all keys in your Mazaal AI Data Store.

List all records in your Mazaal AI Data Store.

Update the expiration time for a record in your Mazaal AI Data Store.

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Mazaal AI.

Deletes a row or rows from a table. See the documentation

Finds a row in a table via a lookup column. See the documentation

Finds a row in a table via a custom query. See the documentation

Adds a new row. See the documentation

Retrieves available options for the Schema field.

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Updates an existing row. See the documentation

Adds a new row or updates an existing row. See the documentation