Skills

Skill 16 of 41

SQLite Schema

1 minute · 149 words · 6 sections

Install

$ npx skills add n8n-io/n8n --skill sqlite-schema

$ npx skills add n8n-io/n8n

» /plugin marketplace add n8n-io/n8n

The first command installs just this skill, by the name in its SKILL.md; the second installs the whole repository.

skill

Description

CREATE TABLE "skill" ("id" varchar(36) PRIMARY KEY NOT NULL, "projectId" varchar(36), "source" varchar(16) NOT NULL, "createdById" varchar, "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')), "availableToAssistant" boolean NOT NULL DEFAULT (false), "availableToMCP" boolean NOT NULL DEFAULT (false), CONSTRAINT "FK_4de4501583cd1fcd6f5ea85f547" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT "FK_402ed37bff0d3134f6e782455ed" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)

Columns

Name	Type	Default	Nullable	Children	Parents
availableToAssistant	boolean	false	false
availableToMCP	boolean	false	false
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
createdById	varchar		true		user (opens in a new tab)
id	varchar(36)		false	agent_skill_dependency (opens in a new tab) agent_version_skill_dependency (opens in a new tab) skill_source_link (opens in a new tab) skill_version (opens in a new tab)
projectId	varchar(36)		true		project (opens in a new tab)
source	varchar(16)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Constraints

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_skill_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
IDX_402ed37bff0d3134f6e782455e	CREATE INDEX “IDX_402ed37bff0d3134f6e782455e” ON “skill” (“projectId”)
sqlite_autoindex_skill_1	PRIMARY KEY (id)

Relations

erDiagram

"skill" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_skill_dependency" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_version_skill_dependency" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill_source_link" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill_version" }o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill" }o--o| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"skill" {
  boolean availableToAssistant
  boolean availableToMCP
  datetime_3_ createdAt
  varchar createdById FK
  varchar_36_ id PK
  varchar_36_ projectId FK
  varchar_16_ source
  datetime_3_ updatedAt
}
"user" {
  datetime_3_ createdAt
  boolean disabled
  varchar_255_ email
  varchar_32_ firstName
  varchar id PK
  VARCHAR_16_ kind
  date lastActiveAt
  varchar_32_ lastName
  boolean mfaEnabled
  TEXT mfaRecoveryCodes
  TEXT mfaSecret
  varchar password
  TEXT personalizationAnswers
  varchar_128_ roleSlug FK
  TEXT settings
  datetime_3_ updatedAt
}
"agent_skill_dependency" {
  varchar_36_ agentId PK
  datetime_3_ createdAt
  varchar_36_ skillId PK
  varchar skillVersionId FK
}
"agent_version_skill_dependency" {
  varchar_36_ agentVersionId PK
  datetime_3_ createdAt
  varchar_36_ skillId PK
  varchar skillVersionId FK
}
"skill_source_link" {
  varchar_64_ baseContentHash
  varchar_255_ baseRevision
  datetime_3_ createdAt
  TEXT pendingContent
  varchar_64_ pendingContentHash
  varchar_255_ pendingRevision
  TEXT pendingScan
  TEXT remoteRef
  varchar_36_ skillId PK
  varchar_64_ skippedContentHash
  TEXT skippedFiles
  varchar sourceId FK
  varchar_32_ state
  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
}
"project" {
  datetime_3_ createdAt
  varchar creatorId FK
  TEXT customTelemetryTags
  varchar_512_ description
  TEXT icon
  varchar_36_ id PK
  varchar_255_ name
  varchar_36_ type
  datetime_3_ updatedAt
}

Generated by tbls (opens in a new tab)

Colophon for this issue

Colophon

How this issue was made

Source

github.com/n8n-io/n8n, branch master, last pushed 8 November 2026.

Licence

Other — the text of every skill is reproduced unmodified, frontmatter included, under the upstream licence.

Discovery

41 skills found by walking the repository tree for SKILL.md, not by matching a directory convention. 6 distinct layouts observed: .agents/skills/*/SKILL.md, .claude/plugins/n8n/skills/*/SKILL.md, .opencode/skills/*/SKILL.md, docs/generated/*/skill.md, packages/@n8n/cli/skills/*/SKILL.md, packages/@n8n/instance-ai/skills/*/SKILL.md.

Authorship

14 of 41 skills are installed into the repository rather than published from it. They are shelved in the closing “Credited skills” part and remain the work of their own authors. A skill counts as credited when its only copy lives under one agent’s dot directory; visible directories, per-agent mirror sets, and skills installable from this repository on skills.sh all count as published.

Issue colours

Resolved from a curated brand profile — hue 10°, chroma 0.190. Two accent tones are generated per issue and each is proven against its own ground before it ships: a single accent that passes AA on both light and dark paper is arithmetically impossible.

Heading repairs

1 repair applied to this skill so the document has one h1 and no skipped levels:

Shifted “6 headings” from h1 to h2 so the skill title is the only h1.

Spec compliance

60 editorial notes across 30 of 41 skills. They are printed in the margin of each skill rather than as errors here.

N8n:content Design — 2 notes
N8n:conventions — 2 notes
N8n:create Community Node Lint Rule — 2 notes
N8n:create Issue — 2 notes
N8n:create PR — 2 notes
N8n:create Skill — 2 notes
N8n:db Migrations — 2 notes
N8n:linear Issue — 2 notes
N8n:loom Transcript — 2 notes
N8n:node Add OAuth — 2 notes

and 20 more.

Images

Images inside a skill come from the upstream repository. Where the author gave no alternative text we mark the image decorative rather than inventing a description — a plausible caption we made up is worse than none for the reader who depends on it.

Marketplace

A plugin manifest is published at .claude-plugin/marketplace.json by n8n, declaring 1 plugin. It is read for editorial metadata only — never as the skill index, which is always the repository tree.

Signal

Install counts come from skills.sh. They measure downloads, not quality, and an unranked repository is not an unread one.

Agent surfaces

The whole issue is available as one markdown document at /n8n-io/n8n.md, and each skill at its own .md URL.

Publication

Set by Skills Docs from the source repository. Body text is Literata at the reader’s chosen size and measure; code is Geist Mono. Nothing on this page was written by us except this paragraph.

skill

Description

CREATE TABLE "skill" ("id" varchar(36) PRIMARY KEY NOT NULL, "projectId" varchar(36), "source" varchar(16) NOT NULL, "createdById" varchar, "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')), "availableToAssistant" boolean NOT NULL DEFAULT (false), "availableToMCP" boolean NOT NULL DEFAULT (false), CONSTRAINT "FK_4de4501583cd1fcd6f5ea85f547" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT "FK_402ed37bff0d3134f6e782455ed" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE NO ACTION)

Columns

Name	Type	Default	Nullable	Children	Parents
availableToAssistant	boolean	false	false
availableToMCP	boolean	false	false
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
createdById	varchar		true		user (opens in a new tab)
id	varchar(36)		false	agent_skill_dependency (opens in a new tab) agent_version_skill_dependency (opens in a new tab) skill_source_link (opens in a new tab) skill_version (opens in a new tab)
projectId	varchar(36)		true		project (opens in a new tab)
source	varchar(16)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Constraints

Name	Type	Definition
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_skill_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
IDX_402ed37bff0d3134f6e782455e	CREATE INDEX “IDX_402ed37bff0d3134f6e782455e” ON “skill” (“projectId”)
sqlite_autoindex_skill_1	PRIMARY KEY (id)

Relations

erDiagram

"skill" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
"agent_skill_dependency" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"agent_version_skill_dependency" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill_source_link" |o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill_version" }o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"skill" }o--o| "project" : "FOREIGN KEY (projectId) REFERENCES project (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"skill" {
  boolean availableToAssistant
  boolean availableToMCP
  datetime_3_ createdAt
  varchar createdById FK
  varchar_36_ id PK
  varchar_36_ projectId FK
  varchar_16_ source
  datetime_3_ updatedAt
}
"user" {
  datetime_3_ createdAt
  boolean disabled
  varchar_255_ email
  varchar_32_ firstName
  varchar id PK
  VARCHAR_16_ kind
  date lastActiveAt
  varchar_32_ lastName
  boolean mfaEnabled
  TEXT mfaRecoveryCodes
  TEXT mfaSecret
  varchar password
  TEXT personalizationAnswers
  varchar_128_ roleSlug FK
  TEXT settings
  datetime_3_ updatedAt
}
"agent_skill_dependency" {
  varchar_36_ agentId PK
  datetime_3_ createdAt
  varchar_36_ skillId PK
  varchar skillVersionId FK
}
"agent_version_skill_dependency" {
  varchar_36_ agentVersionId PK
  datetime_3_ createdAt
  varchar_36_ skillId PK
  varchar skillVersionId FK
}
"skill_source_link" {
  varchar_64_ baseContentHash
  varchar_255_ baseRevision
  datetime_3_ createdAt
  TEXT pendingContent
  varchar_64_ pendingContentHash
  varchar_255_ pendingRevision
  TEXT pendingScan
  TEXT remoteRef
  varchar_36_ skillId PK
  varchar_64_ skippedContentHash
  TEXT skippedFiles
  varchar sourceId FK
  varchar_32_ state
  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
}
"project" {
  datetime_3_ createdAt
  varchar creatorId FK
  TEXT customTelemetryTags
  varchar_512_ description
  TEXT icon
  varchar_36_ id PK
  varchar_255_ name
  varchar_36_ type
  datetime_3_ updatedAt
}

Generated by tbls (opens in a new tab)

SQLite Schema

skill

Description

Columns

Constraints

Indexes

Relations

Colophon

SQLite Schema

skill

Description

Columns

Constraints

Indexes

Relations

Appendix 16.1–16.176

Also bundledMarkdown · 176 files

Colophon

Appendix 16.1–16.176

Also bundledMarkdown · 176 files