DuckDB

Run analytical SQL queries with embedded DuckDB. In Appbricx, your workflows and server functions call it by name once it is connected.

Connect DuckDBFull reference

What you can do

1 action, each one call from a workflow or a server function. Triggers come from your app: a row changing, a schedule or a webhook.

  • Create and Query DBcreateAndQueryDB
    Create DB from data and run query

Set it up

About two minutes, once per project or once for the whole workspace.

  1. Open Integrations in the builder

    Backend panel, Integrations tab, then DuckDB. To connect it for every project, use Workspace settings, Integrations.

  2. Turn it on

    Nothing to connect: its actions run without credentials.

  3. Call an action

    From a workflow, by integration id and action name. The call answers with success, output and, when it fails, the reason.

    Workflow
    // .workflow.js (native ctx)
export async function run(ctx) {
  const res = await ctx.integrations.invoke("duckdb", "createAndQueryDB", {
    "tables": [],
    "query": "<query>"
  });
  if (!res.success) throw new Error(res.error);
  ctx.log.info("DuckDB answered", { output: res.output });
}

DuckDB and its logo are trademarks of their owner, shown only to identify the service this integration connects to. Their use does not imply endorsement by, or affiliation with, that company.

Connect DuckDB once. Every workflow can use it.

Start freeAll integrations