> **sqlite-schema** — skill 16 of 41 in [n8n-io/n8n](https://skillsdocs.com/n8n-io/n8n).
>
> Book (all skills, one file): https://skillsdocs.com/n8n-io/n8n.md
> Machine manifest: https://skillsdocs.com/n8n-io/n8n/.well-known/agent-skills/index.json
> Install the book: `npx skills add n8n-io/n8n`
> Upstream: https://github.com/n8n-io/n8n/blob/master/docs/generated/sqlite-schema/skill.md @ `master`
> Raw bytes, no header: https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/skill.md
> Base for relative paths: https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/
> Licence: Other — https://github.com/n8n-io/n8n
>
> Bundled files (176), referenced from this skill's directory:
>   - `activity_event.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/activity_event.md
>   - `agent_background_job.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_background_job.md
>   - `agent_budget_applied_call.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_budget_applied_call.md
>   - `agent_budget_spend.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_budget_spend.md
>   - `agent_channel_status.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_channel_status.md
>   - `agent_chat_attachments.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_chat_attachments.md
>   - `agent_chat_subscriptions.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_chat_subscriptions.md
>   - `agent_checkpoints.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_checkpoints.md
>   - `agent_credential_dependency.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_credential_dependency.md
>   - `agent_eval_dataset.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_eval_dataset.md
>   - `agent_eval_rating.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_eval_rating.md
>   - `agent_eval_result.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_eval_result.md
>   - `agent_eval_run.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_eval_run.md
>   - `agent_execution_message_links.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_execution_message_links.md
>   - `agent_execution_threads.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_execution_threads.md
>   - `agent_execution.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_execution.md
>   - `agent_file_grants.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_file_grants.md
>   - `agent_files.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_files.md
>   - `agent_history.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_history.md
>   - `agent_message_queue.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_message_queue.md
>   - `agent_plan_history.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_plan_history.md
>   - `agent_plan.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_plan.md
>   - `agent_publish_history.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_publish_history.md
>   - `agent_skill_dependency.md` — https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/sqlite-schema/agent_skill_dependency.md
>   - …and 152 more, listed in https://skillsdocs.com/api/v1/books/n8n-io/n8n/skills/sqlite-schema
>
> Content © its authors, served unmodified. Takedown: https://github.com/DreambaseAI/skillsdocs/issues/new?labels=takedown&title=Takedown+request

<!-- Verbatim upstream SKILL.md follows, YAML frontmatter included. -->

# skill

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
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)
```

</details>

## Columns

| Name | Type | Default | Nullable | Children | Parents | Comment |
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
| availableToAssistant | boolean | false | false |  |  |  |
| availableToMCP | boolean | false | false |  |  |  |
| createdAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false |  |  |  |
| createdById | varchar |  | true |  | [user](user.md) |  |
| id | varchar(36) |  | false | [agent_skill_dependency](agent_skill_dependency.md) [agent_version_skill_dependency](agent_version_skill_dependency.md) [skill_source_link](skill_source_link.md) [skill_version](skill_version.md) |  |  |
| projectId | varchar(36) |  | true |  | [project](project.md) |  |
| 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

```mermaid
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](https://github.com/k1LoW/tbls)