n8n Plug Database Advanced Nodes

1.1.2 verified Sat May 09 auth: no javascript

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.

Common errors

error Error: Credentials 'Plug Database Api' not found ↓

cause 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.

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

cause Socket connection attempt without proper server support for consumer socket.

fix

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

error Validation Error: Agent ID is required for this operation ↓

cause 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 Error: Access denied - client token expired or invalid ↓

cause 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.

Warnings

gotcha Package 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.

breaking Hidden 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.

deprecated Older 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.

gotcha Execute 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.

gotcha Large socket streams have local buffer guardrails that may truncate output if exceeded. ↓

fix Use chunked output mode or break queries into smaller batches.

Install

npm install n8n-nodes-plug-database-advanced

yarn add n8n-nodes-plug-database-advanced

pnpm add n8n-nodes-plug-database-advanced

Imports

Plug Database Advanced
wrong
```
const PlugDatabaseAdvanced = require('n8n-nodes-plug-database-advanced')
```
correct
```
import { PlugDatabaseAdvanced } from '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
wrong
```
import { default } from 'n8n-nodes-plug-database-advanced'
```
correct
```
import pkg from 'n8n-nodes-plug-database-advanced'
```
The package exports a default object containing all node and credential definitions for n8n loading.

Quickstart

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.