n8n Integration

Table of contents

• Prerequisites
• Connect CloudBeaver to n8n
• Available operations
• Example workflow

Connect CloudBeaver to n8n to automate your database workflows. Build workflows that execute SQL queries, select rows, insert data, update records, and delete data across your configured connections.

The CloudBeaver node is a verified n8n community node. It lets your workflows run database operations through CloudBeaver's GraphQL API.

Prerequisites

Gather the necessary details before you build your workflow.

• Deploy CloudBeaver.

  For instruction on deployment, see CloudBeaver Deployment.

• Host n8n.

• Create a CloudBeaver access token or use local credentials.

• Find your database connection ID.

  Tip: To find your connection ID, right-click the database in the CloudBeaver Database Navigator, select Open, and copy the ID from the connection window.

Connect CloudBeaver to n8n

Connect your node to your server:

1. Open your n8n workflow editor and click + in the top right to open the Nodes panel.

2. Search for CloudBeaver and install the node.

   

   For more details, see how to work with nodes in the n8n documentation.

3. Choose an action and create credentials:

   1. Select your authentication type.

   2. Enter your CloudBeaver server URL.

   3. Provide your credentials or access token.

   4. Save your connection settings.

      

   5. Click Save to test your connection. You'll see a Connection tested successfully message if it works.

   Learn more on how to create and edit credentials.

Available operations

• Execute SQL Query: run custom SQL statements.
• Select Rows: retrieve rows from a table without writing SQL.
• Insert Rows: add records to a table.
• Update Rows: modify existing records.
• Delete: remove rows, truncate a table, or drop a table.

Example workflow

Use CloudBeaver to pull database records and feed them into other apps in your n8n pipeline.

1. Add a Schedule Trigger node to run your workflow automatically.
2. Connect the trigger node to the CloudBeaver node.
3. Configure the CloudBeaver node with your connection ID and target database name.
4. Add your query to the SQL Query field.
5. Click Execute step to test the query and preview the results.

Use the output from the CloudBeaver node in any downstream n8n node, for example to filter data, send notifications, or trigger additional actions.

For information on creating workflows, see the official n8n documentation.