{"id":27977,"library":"n8n-nodes-plug-database","title":"n8n Plug Database Nodes","description":"n8n community package providing REST-only nodes for the Plug Database blockchain API. Current stable version is 1.1.2, released with patch updates for icons and navigation. It consolidates SQL execution, client access, and user access management into a single node with resource-based navigation, supporting operations like Execute SQL, Request Agent Access, and Approve Access Request. Key differentiators: fixed API base URL, support for both guided and advanced JSON-RPC modes, pagination via Return All, and credential override per node. No socket or realtime trigger support in v1.","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","rest"],"install":[{"cmd":"npm install n8n-nodes-plug-database","lang":"bash","label":"npm"},{"cmd":"yarn add n8n-nodes-plug-database","lang":"bash","label":"yarn"},{"cmd":"pnpm add n8n-nodes-plug-database","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"peer dependency required by all n8n community nodes","package":"n8n-workflow","optional":true}],"imports":[{"note":"Credentials are exported from a separate path; do not import from the main package index","wrong":"import PlugDatabaseApi from 'n8n-nodes-plug-database'","symbol":"Plug Database","correct":"import { Plug Database } from 'n8n-nodes-plug-database/credentials/PlugDatabaseApi.credentials'"},{"note":"The node class is exported from a nested path; the package index does not export it directly","wrong":"import { PlugDatabase } from 'n8n-nodes-plug-database'","symbol":"PlugDatabaseNode","correct":"import { PlugDatabaseNode } from 'n8n-nodes-plug-database/nodes/PlugDatabase/PlugDatabase.node'"},{"note":"Credentials are not re-exported from the package root","wrong":"import { PlugDatabaseApi } from 'n8n-nodes-plug-database'","symbol":"PlugDatabaseApi","correct":"import { PlugDatabaseApi } from 'n8n-nodes-plug-database/credentials/PlugDatabaseApi.credentials'"}],"quickstart":{"code":"// Install: npm install n8n-nodes-plug-database\n// In n8n UI, add a 'Plug Database' node\n// Credentials: fill User (email), Password, optional Default Agent ID, optional Default Client Token\n// Example: Execute SQL\n// Create a node with:\n// Resource: SQL\n// Operation: Execute SQL\n// Agent ID: (override or leave empty to use credential default)\n// SQL Query: SELECT * FROM agents;\n// Output: Aggregated JSON\n// The node returns one item per row.\n// For listing agents: Resource: Client Access, Operation: List Client Agents, Return All: true","lang":"javascript","description":"Demonstrates creating a Plug Database node, setting credentials, and executing a SQL query with aggregated JSON output."},"warnings":[{"fix":"Switch to the consolidated 'Plug Database' node and use Resource-based navigation.","message":"Legacy access-only nodes are hidden from new workflows; existing workflows using them will continue to work but new users must use the consolidated node.","severity":"break","affected_versions":">=1.1.0"},{"fix":"Ensure your Plug Database server is accessible at that URL; no customization available.","message":"The API base URL is fixed to https://plug-server.se7esistemassinop.com.br/api/v1 and cannot be changed via credentials or node settings.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Poll for changes via scheduled workflows or wait for future versions with socket support.","message":"No socket transport or realtime triggers are supported in v1; all operations are REST-only.","severity":"gotcha","affected_versions":">=1.0.0 <=1.1.2"},{"fix":"Consider splitting large batches into smaller sets or use Execute SQL for fewer statements.","message":"Execute Batch runs over REST only; it may be slower than a single SQL execution for large batches.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"last_verified":"2026-05-09T00:00:00.000Z","next_check":"2026-08-07T00:00:00.000Z","problems":[{"fix":"Use correct path: 'n8n-nodes-plug-database/credentials/PlugDatabaseApi.credentials'","cause":"Import path typo or missing file in the package.","error":"Cannot find module 'n8n-nodes-plug-database/credentials/PlugDatabaseApi.credentials'"},{"fix":"Verify user email and password in the credentials dialog, and ensure the account has access.","cause":"Invalid or missing credentials; email/password wrong or expired.","error":"Error: Plug Database API returned 401 Unauthorized"},{"fix":"Set the Agent ID either in the node's 'Agent ID' field or in the credential's 'Default Agent ID'.","cause":"No Agent ID provided via node field or credential default.","error":"Error: Agent ID is required for this operation"},{"fix":"Install the package via npm install n8n-nodes-plug-database and restart n8n, or check admin settings for community node approval.","cause":"n8n instance may not have the package installed or the community node is not approved.","error":"The node type \"Plug Database\" is not known"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}