Installed Nodes · SQLite Schema · n8n-io/n8n · Skills Docs

Installed Nodes · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "installed_nodes" (
				"name" char(200) NOT NULL,
				"type" char(200) NOT NULL,
				"latestVersion" REAL DEFAULT 1,
				"package" char(214) NOT NULL,
				PRIMARY KEY ("name"),
				FOREIGN KEY ("package") REFERENCES "installed_packages" ("packageName") ON DELETE CASCADE ON UPDATE CASCADE
			)

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (package) REFERENCES installed_packages (packageName) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE
name	PRIMARY KEY	PRIMARY KEY (name)
sqlite_autoindex_installed_nodes_1	PRIMARY KEY	PRIMARY KEY (name)

erDiagram

"installed_nodes" }o--|| "installed_packages" : "FOREIGN KEY (package) REFERENCES installed_packages (packageName) ON UPDATE CASCADE ON DELETE CASCADE MATCH NONE"

"installed_nodes" {
  REAL latestVersion
  char_200_ name PK
  char_214_ package FK
  char_200_ type
}
"installed_packages" {
  char_70_ authorEmail
  char_70_ authorName
  datetime_3_ createdAt
  char_50_ installedVersion
  char_214_ packageName PK
  datetime_3_ updatedAt
}