Skill File · SQLite Schema · n8n-io/n8n · Skills Docs

Skill File · SQLite Schema · n8n-io/n8n · Skills Docs

CREATE TABLE "skill_file" ("skillVersionId" varchar NOT NULL, "path" varchar(512) NOT NULL, "content" text NOT NULL, "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')), CONSTRAINT "FK_e9ab50b795ec8858702b7333d13" FOREIGN KEY ("skillVersionId") REFERENCES "skill_version" ("id") ON DELETE CASCADE, PRIMARY KEY ("skillVersionId", "path"))

Name	Type	Default	Nullable	Children	Parents	Comment
content	TEXT		false
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
path	varchar(512)		false
skillVersionId	varchar		false		skill_version
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (skillVersionId) REFERENCES skill_version (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
path	PRIMARY KEY	PRIMARY KEY (path)
skillVersionId	PRIMARY KEY	PRIMARY KEY (skillVersionId)
sqlite_autoindex_skill_file_1	PRIMARY KEY	PRIMARY KEY (skillVersionId, path)

erDiagram

"skill_file" |o--|| "skill_version" : "FOREIGN KEY (skillVersionId) REFERENCES skill_version (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"skill_file" {
  TEXT content
  datetime_3_ createdAt
  varchar_512_ path PK
  varchar skillVersionId PK
  datetime_3_ updatedAt
}
"skill_version" {
  varchar_64_ contentHash
  datetime_3_ createdAt
  varchar createdById FK
  varchar_1024_ description
  TEXT frontmatter
  varchar id PK
  TEXT instructions
  varchar_128_ name
  varchar_36_ skillId FK
  varchar_255_ sourceRevision
  datetime_3_ updatedAt
  INTEGER version
}