{"id":27975,"library":"n8n-nodes-plug-database-advanced","title":"n8n Plug Database Advanced Nodes","description":"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.","status":"active","version":"1.1.2","language":"javascript","source_language":"en","source_url":"https://github.com/cesar-carlos/plug_node","tags":["javascript","n8n-community-node-package","n8n","plug","database","socket.io","relay","consumer-socket"],"install":[{"cmd":"npm install n8n-nodes-plug-database-advanced","lang":"bash","label":"npm"},{"cmd":"yarn add n8n-nodes-plug-database-advanced","lang":"bash","label":"yarn"},{"cmd":"pnpm add n8n-nodes-plug-database-advanced","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Peer dependency required for n8n node runtime compatibility","package":"n8n-workflow","optional":false},{"reason":"Runtime dependency for consumer socket transport","package":"socket.io-client","optional":false}],"imports":[{"note":"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.","wrong":"const PlugDatabaseAdvanced = require('n8n-nodes-plug-database-advanced')","symbol":"Plug Database Advanced","correct":"import { PlugDatabaseAdvanced } from 'n8n-nodes-plug-database-advanced'"},{"note":"Named export for the credential type, used when defining custom credential classes in n8n.","wrong":null,"symbol":"ICredentialType","correct":"import { PlugDatabaseApi } from 'n8n-nodes-plug-database-advanced'"},{"note":"The package exports a default object containing all node and credential definitions for n8n loading.","wrong":"import { default } from 'n8n-nodes-plug-database-advanced'","symbol":"default","correct":"import pkg from 'n8n-nodes-plug-database-advanced'"}],"quickstart":{"code":"// Install the package in your n8n custom nodes directory\n// npm install n8n-nodes-plug-database-advanced\n\n// In n8n, add a 'Plug Database Advanced' node to your workflow.\n// Configure credentials with your Plug user email and password.\n// Example: Execute a SQL query via REST.\n// Resource: SQL | Operation: Execute SQL | Channel: REST\n// SQL Query: SELECT * FROM agents WHERE active = true\n// Output mode: Aggregated JSON\n// Run the workflow to see agent list.\n\n// For socket consumer, set Channel: Socket and Output mode: Chunk Items\n// to stream results.","lang":"javascript","description":"Shows how to install and use the Plug Database Advanced node in n8n for SQL execution via REST or socket with chunked output."},"warnings":[{"fix":"Install package in custom nodes directory or use n8n's community node installation feature if available.","message":"Package not intended for n8n verification; may not appear in n8n node library without manual installation.","severity":"gotcha","affected_versions":"all"},{"fix":"Update workflows to use 'Plug Database Advanced' node with appropriate Resource selection.","message":"Hidden legacy nodes may break existing workflows that reference them directly; new workflows should use consolidated 'Plug Database Advanced' node.","severity":"breaking","affected_versions":">=1.1.0"},{"fix":"Ensure server supports consumer socket; fallback to relay is automatic but may lack features like Execute Batch over socket.","message":"Older relay-based socket execution is deprecated; new socket executions use consumer socket with agents:command capability.","severity":"deprecated","affected_versions":">=1.1.0"},{"fix":"Switch to REST channel for Execute Batch when server lacks agents:command capability.","message":"Execute Batch operation fails over socket if server does not support agents:command; must use REST.","severity":"gotcha","affected_versions":">=1.1.0"},{"fix":"Use chunked output mode or break queries into smaller batches.","message":"Large socket streams have local buffer guardrails that may truncate output if exceeded.","severity":"gotcha","affected_versions":">=1.1.0"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Ensure the package is properly loaded in n8n custom nodes directory and restart n8n.","cause":"Credential type not registered when using node outside n8n context.","error":"Error: Credentials 'Plug Database Api' not found"},{"fix":"Ensure Plug server version supports consumer socket transport (agents:command).","cause":"Socket connection attempt without proper server support for consumer socket.","error":"TypeError: Cannot read properties of undefined (reading 'consumer')"},{"fix":"Provide Agent ID in the node fields or set default Agent ID in credential.","cause":"Missing Agent ID in both node configuration and credential defaults.","error":"Validation Error: Agent ID is required for this operation"},{"fix":"Renew client token via 'Set Client Token' operation or use a valid token.","cause":"Client token used is expired or not authorized for the operation.","error":"Error: Access denied - client token expired or invalid"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}