Cred Sync icon

Cred Sync

Share n8n credentials between users via SSH + Docker + PostgreSQL/SQLite

Cred Sync

AI-generated

Summary

Interact with n8n's underlying Dockerized database and containers over SSH to manage users, credentials, and workflows securely, supporting PostgreSQL or SQLite. Automatically detects the database type unless specified, connects to the relevant containers, and performs operations such as listing users, sharing credentials, changing user roles, and sharing workflows.

Inputs

  • Database Type — Database type used by n8n ('auto', 'postgres', or 'sqlite'); determines how to connect to n8n data.
  • PostgreSQL Container (required) — Docker container name running PostgreSQL, required if 'postgres' database type is chosen.
  • n8n Container (required) — Docker container name running n8n service, required if 'auto' or 'sqlite' database type is chosen.
  • Resource (required) — The type of resource to operate on: users, credentials, workflows, or shared credentials.
  • Operation (required) — The specific operation to perform on the selected resource, such as listing all, sharing, creating, or changing roles.
  • User (roleUserId) (required) — User ID whose role will be changed (for user resource with changeRole operation).
  • New Role (required) — Role to assign to the user (owner, admin, or member).
  • Credential (credentialId) (required) — ID of the credential to share (for credential resource with share operation).
  • User (userId) (required) — User to share the credential or workflow with.
  • Source Credential (createSourceCredentialId) (required) — Credential ID to use as a template when creating a new credential copy.
  • New Credential Name (credentialName) (required) — Name for the new credential copy.
  • Share with User (shareWithUser) — Boolean indicating whether to share the new credential immediately.
  • User (createShareUserId) — User ID to share the newly created credential with, if sharing is enabled.
  • Workflow (workflowId) (required) — Workflow ID to share (for workflow resource with share operation).
  • User (workflowShareUserId) (required) — User to share the workflow with.
  • Role (workflowShareRole) (required) — Permission level for workflow sharing, either editor or viewer.
  • Shared Credential (sharedCredentialId) (required) — ID of the shared credential to add to the local n8n instance (for shared resource with addCredential operation).

Output shape

a list of JSON objects representing users, credentials, workflows, or operation results depending on the selected resource and operation

Supports multiple operations and returns data accordingly: lists of users/credentials/workflows, confirmation of sharing or role changes, or error messages. Operations may require selection of specific containers and specify database type to properly connect.

Examples

Example 1: To list all n8n users, select resource 'user' and operation 'getAll'. Provide SSH credentials and database connection details. The node returns an array of user objects with id, email, firstName, and lastName fields.

Set 'dbType' (auto/postgres/sqlite), select appropriate Docker containers for PostgreSQL and n8n, add SSH credential (sshCredentialsApi), and choose 'user' resource with 'getAll' operation.

Links

Discussion