Secrets Provider Connection · SQLite Schema · n8n-io/n8n · Skills Docs

Secrets Provider Connection · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "secrets_provider_connection" ("id" integer PRIMARY KEY NOT NULL, "providerKey" varchar(128) NOT NULL, "type" varchar(36) NOT NULL, "encryptedSettings" text NOT NULL, "isEnabled" boolean NOT NULL DEFAULT (false), "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')))

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
encryptedSettings	TEXT		false
id	INTEGER		false	project_secrets_provider_access
isEnabled	boolean	false	false
providerKey	varchar(128)		false
type	varchar(36)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

erDiagram

"project_secrets_provider_access" |o--|| "secrets_provider_connection" : "FOREIGN KEY (secretsProviderConnectionId) REFERENCES secrets_provider_connection (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"secrets_provider_connection" {
  datetime_3_ createdAt
  TEXT encryptedSettings
  INTEGER id
  boolean isEnabled
  varchar_128_ providerKey
  varchar_36_ type
  datetime_3_ updatedAt
}
"project_secrets_provider_access" {
  datetime_3_ createdAt
  varchar_36_ projectId PK
  varchar_128_ role
  INTEGER secretsProviderConnectionId PK
  datetime_3_ updatedAt
}