n8n-nodes-cloudbeaver

This is an n8n community node for CloudBeaver - a web-based database management
tool. It lets you interact with any database connected to your CloudBeaver server directly from n8n workflows.

n8n is a fair-code licensed workflow automation
platform.

• Installation
• Operations
• Credentials
• Compatibility
• Usage
• Resources

Installation

Follow the installation guide in the
n8n community nodes documentation.

Operations

• Execute SQL Query - run any SQL query with support for limit, offset, ORDER BY, and WHERE filters
• Select Rows - retrieve rows from a table with optional WHERE, ORDER BY, limit, and offset
• Insert Rows - insert a new row by specifying column/value pairs
• Update Rows - update rows by specifying column/value pairs and a WHERE condition
• Delete - delete rows (with optional WHERE), truncate, or drop a table

Note: Only connections from the Shared project in CloudBeaver are supported.

Credentials

Create a CloudBeaver API credential with:

Compatibility

Requires n8n 1.0.0 or later. Designed for self-hosted CloudBeaver instances (Community, Enterprise or AWS Edition).

Usage

Finding the Connection ID

Right-click a database in CloudBeaver's Database Navigator -> Open -> copy the ID from the connection window (e.g.
postgres-jdbc-19d5ca3a223-2f46e1a321049b15).

Default Database

The Default Database field lets you specify which database or catalog to use when executing SQL. Leave it empty to
use the connection's default. Useful when a single CloudBeaver connection has access to multiple databases and you want
to target a specific one.

Database Type

The Database Type field (Select, Insert, Update, Delete operations) controls identifier quoting style:

For databases not listed, PostgreSQL is a safe default - ANSI double-quote quoting works with most SQL databases.

Execute SQL Query

The Where and Order By fields are applied on top of your SQL query:

SQL Query:

SELECT id, name, email
FROM users

Where: status = 'active'
Order By: created_at DESC
Limit: 50

Executes as:

SELECT *
FROM (SELECT id, name, email FROM users) AS _q
WHERE status = 'active'
ORDER BY created_at DESC LIMIT 50

Insert / Update value types

Insert and Update operations let you choose how each value is formatted in the generated SQL query.

Use Raw SQL for database-specific expressions, casts, functions, or complex values, such as NOW(),
CAST('42' AS INTEGER), or '{"a":1}'::jsonb.

Warning: Use Raw SQL only with trusted values. Raw SQL is inserted into the query without escaping.

Getting Started (Local Testing)

1. Start CloudBeaver:

   docker run -d -p 8978:8978 dbeaver/cloudbeaver:latest
   

   Or follow
   the full installation guide.

2. Configure authentication - follow
   the Local Access Authentication guide. Create a
   user (login/password) or use admin credentials.

3. Create a database connection - follow
   the Create Connection guide.

4. Get the Connection ID - open Database Navigator,
   right-click a database -> Open, and copy the connection ID from the opened window.

5. In n8n:

   • Create CloudBeaver credentials (Local auth: login/password)
   • Add the CloudBeaver node to your workflow
   • Set the Connection ID
   • Choose an operation and configure its fields
   • Execute the node

Resources

• n8n community nodes documentation
• CloudBeaver documentation
• CloudBeaver API token guide