Registry / database / n8n-nodes-plug-database-advanced

n8n-nodes-plug-database-advanced

library1.1.2jsnpmunverified

Advanced n8n community nodes for interacting with Plug Database via REST and consumer socket (Socket.IO) transport. Current stable version is 1.1.2, with monthly minor releases. Includes consolidated 'Plug Database Advanced' node supporting SQL execution, client access management, and user access approval. Key differentiators: consumer socket execution with automatic relay fallback, chunked streaming output, paginated access listing, and agent/client token override per node. Requires n8n-workflow peer dependency. Not intended for n8n verification.

database workflow

npm install n8n-nodes-plug-database-advanced

github ↗package ↗

INSTALL

IMPORT

SIG · N8N-NODES-PLUG-DAT

n8n-nodes-plug-database-advanced

databasejavascriptv1.1.2

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.

Plug Database Advanced

✓ import { PlugDatabaseAdvanced } from 'n8n-nodes-plug-database-advanced'

✗ const PlugDatabaseAdvanced = require('n8n-nodes-plug-database-advanced')

This is a n8n node package; import is used for type-checking or extension, but typical usage is via n8n's node loader. ESM-only since v1.0.

ICredentialType

✓ import { PlugDatabaseApi } from 'n8n-nodes-plug-database-advanced'

Named export for the credential type, used when defining custom credential classes in n8n.

default

✓ import pkg from 'n8n-nodes-plug-database-advanced'

✗ import { default } from 'n8n-nodes-plug-database-advanced'

The package exports a default object containing all node and credential definitions for n8n loading.

Shows how to install and use the Plug Database Advanced node in n8n for SQL execution via REST or socket with chunked output.

// Install the package in your n8n custom nodes directory // npm install n8n-nodes-plug-database-advanced // In n8n, add a 'Plug Database Advanced' node to your workflow. // Configure credentials with your Plug user email and password. // Example: Execute a SQL query via REST. // Resource: SQL | Operation: Execute SQL | Channel: REST // SQL Query: SELECT * FROM agents WHERE active = true // Output mode: Aggregated JSON // Run the workflow to see agent list. // For socket consumer, set Channel: Socket and Output mode: Chunk Items // to stream results.

Debug

Known issues

gotchaPackage not intended for n8n verification; may not appear in n8n node library without manual installation.

fix

Install package in custom nodes directory or use n8n's community node installation feature if available.

affects: all

breakingHidden legacy nodes may break existing workflows that reference them directly; new workflows should use consolidated 'Plug Database Advanced' node.

fix

Update workflows to use 'Plug Database Advanced' node with appropriate Resource selection.

affects: >=1.1.0

deprecatedOlder relay-based socket execution is deprecated; new socket executions use consumer socket with agents:command capability.

fix

Ensure server supports consumer socket; fallback to relay is automatic but may lack features like Execute Batch over socket.

affects: >=1.1.0

gotchaExecute Batch operation fails over socket if server does not support agents:command; must use REST.

fix

Switch to REST channel for Execute Batch when server lacks agents:command capability.

affects: >=1.1.0

gotchaLarge socket streams have local buffer guardrails that may truncate output if exceeded.

fix

Use chunked output mode or break queries into smaller batches.

affects: >=1.1.0

Errors

Common errors & fixes

Error: Credentials 'Plug Database Api' not found

Credential type not registered when using node outside n8n context.

fix

Ensure the package is properly loaded in n8n custom nodes directory and restart n8n.

TypeError: Cannot read properties of undefined (reading 'consumer')

Socket connection attempt without proper server support for consumer socket.

fix

Ensure Plug server version supports consumer socket transport (agents:command).

Validation Error: Agent ID is required for this operation

Missing Agent ID in both node configuration and credential defaults.

fix

Provide Agent ID in the node fields or set default Agent ID in credential.

Error: Access denied - client token expired or invalid

Client token used is expired or not authorized for the operation.

fix

Renew client token via 'Set Client Token' operation or use a valid token.

Upgrade

Version history

1.1.2latest on npm

Audit

Dependencies

n8n-workflowrequiredPeer dependency required for n8n node runtime compatibility

socket.io-clientrequiredRuntime dependency for consumer socket transport

Agent activity

16 hits · last 30 days

node

Amazon

OpenAI (training)

Resources

githubhttps://github.com/cesar-carlos/plug_node ↗

packagehttps://www.npmjs.com/package/n8n-nodes-plug-database-advanced ↗