Registry / database / n8n-nodes-cloudbeaver

n8n-nodes-cloudbeaver

library0.4.1jsnpmunverified

n8n-community-node-package to execute SQL queries and manage database rows via the CloudBeaver API within n8n workflows. Current stable version is 0.4.1, released irregularly. It supports self-hosted CloudBeaver instances (Community, Enterprise, AWS Edition) providing operations like Execute SQL, Select, Insert, Update, and Delete with built-in quoting styles for PostgreSQL, MySQL, and SQL Server. Requires n8n 1.0.0+. Compared to using raw HTTP nodes, this node handles authentication, connection resolution, and result parsing automatically.

database

npm install n8n-nodes-cloudbeaver

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · N8N-NODES-CLOUDBEA

n8n-nodes-cloudbeaver

databasejavascriptv0.4.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

CloudBeaver

✓ import { CloudBeaver } from 'n8n-nodes-cloudbeaver'

✗ import CloudBeaver from 'n8n-nodes-cloudbeaver'

The package exports a named class, not a default export.

CloudBeaver (n8n credential class)

✓ import { CloudBeaverApi } from 'n8n-nodes-cloudbeaver'

✗ import { CloudBeaver } from 'n8n-nodes-cloudbeaver'

The credential class is named CloudBeaverApi, not CloudBeaver.

CloudBeaver (declaration)

✓ import type { CloudBeaver } from 'n8n-nodes-cloudbeaver'

Type-only import is safe for type-checking; no runtime impact.

Shows how to import and instantiate the node, configure credentials via environment variables, and set the connection ID.

import { CloudBeaver } from 'n8n-nodes-cloudbeaver'; const node = new CloudBeaver(); console.log('Node description:', node.description.name); // In n8n workflow, add the node and configure credentials: // - Server URL: process.env.CLOUDBEAVER_URL ?? 'https://cloudbeaver.example.com' // - Auth Type: 'localAccess' or 'apiToken' // - Username/Password: process.env.CLOUDBEAVER_USER ?? '', process.env.CLOUDBEAVER_PASS ?? '' // - API Token: process.env.CLOUDBEAVER_TOKEN ?? '' // Then select operation: executeSql, select, insert, update, delete // Provide Connection ID (e.g., 'postgres-jdbc-19d5ca3a223-2f46e1a321049b15') // and Default Database (optional).

Debug

Known issues

gotchaOnly connections from the Shared project in CloudBeaver are supported. Personal project connections will not work.

fix

Ensure the database connection is in the Shared project in CloudBeaver.

affects: >=0.1.0

gotchaThe Execute SQL operation applies WHERE and ORDER BY on top of your SQL via subquery wrapping, which may affect performance or unexpected behavior with complex queries.

fix

For full control, omit WHERE/ORDER BY fields and include them directly in the SQL query.

affects: >=0.1.0

gotchaThe Database Type field affects identifier quoting style; selecting the wrong type can cause SQL syntax errors.

fix

Set Database Type correctly: PostgreSQL for ANSI SQL databases, MySQL for MySQL/MariaDB/TiDB, SQL Server for SQL Server/Azure/Sybase.

affects: >=0.1.0

breakingn8n 1.0.0 or later is required. Older n8n versions are incompatible.

fix

Upgrade n8n to version 1.0.0 or later.

affects: >=1.0.0

gotchaThe Connection ID must be obtained from the CloudBeaver UI; it is not the database host or name.

fix

Right-click the database in CloudBeaver's Database Navigator -> Open -> copy the ID from the connection window.

affects: >=0.1.0

Errors

Common errors & fixes

Error: No credentials found for node 'CloudBeaver'

Credentials not configured or not linked to the node in n8n.

fix

Create a 'CloudBeaver API' credential with correct server URL and authentication details, then select it in the node's credential dropdown.

Error: Connection '...' not found

The provided Connection ID is invalid or the connection is not in the Shared project.

fix

Verify the Connection ID from CloudBeaver UI (right-click database -> Open -> copy ID) and ensure the connection is under Shared project.

Error: Failed to execute query: syntax error at or near "..."

SQL syntax error or incorrect quoting due to wrong Database Type.

fix

Check SQL syntax and ensure Database Type matches your database (PostgreSQL, MySQL, or SQL Server).

Error: Unauthorized (401)

Invalid credentials or missing API token for API Token authentication, or wrong username/password for local access.

fix

Verify credentials in CloudBeaver: for local access, check username/password; for API token, generate a new token in Admin settings.

Upgrade

Version history

0.4.1latest on npm

Audit

Dependencies

n8n-workflowrequiredPeer dependency required by n8n community nodes; provides base classes and runtime.

Agent activity

2 hits · last 30 days

node

Resources

githubhttps://github.com/daelynum/n8n-nodes-cloudbeaver ↗

packagen8n-nodes-cloudbeaver ↗

homepagehttps://github.com/daelynum/n8n-nodes-cloudbeaver#readme ↗