Duaer

Integrations

Use CrateDB in Duaer

In Duaer, the CrateDB node works with CrateDB from a workflow. It offers 3 operations: Execute Query, Insert, and Update.

Add CrateDB to a Duaer workflow

  1. On the Duaer canvas, open the node panel, search for CrateDB, and connect it after the previous node.
  2. In Credential to connect with, pick or create a CrateDB credential. Refer to CrateDB credentials.
  3. Pick an Operation, for example Update.
  4. Fill the fields that operation shows, such as Schema, Table, Update Key, and Columns.
  5. If needed, select Add Option for the optional settings listed below.
  6. Select Execute step and check the output.

CrateDB operations in Duaer

  • Execute Query: Execute an SQL query.
  • Insert: Insert rows in database.
  • Update: Update rows in database.

CrateDB options in Duaer

Under Add Option, CrateDB offers Mode and Query Parameters.

Use CrateDB as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for CrateDB and add it. The agent decides when to call it. For a field the model should fill, select the sparkle next to it or write $fromAI('name', 'what to put here'); fixed values stay as you set them.

Call a CrateDB endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick CrateDB as the credential type, and select the same credential. Duaer signs the request with it, so you only fill in the method and URL. Refer to custom operations.

Questions

What can the CrateDB node do in Duaer?

In Duaer, CrateDB offers Execute Query, Insert, and Update.

Which credential does CrateDB use in Duaer?

Duaer's CrateDB uses a CrateDB credential. The secret stays in the credential, not in node parameters.

In this section