Menu
Column-level schema details for all seven app.db tables. Read this when you need exact column names, types, constraints, or indexes before writing queries or creating/updating records.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Use when editing `~/.system2/config.toml` — adding or modifying a database connection, tuning per-agent overrides, or changing operational defaults. Does NOT cover `~/.system2/auth/.auth.toml` (managed by `system2 config`).
Run on first launch (when ~/.system2/knowledge/infrastructure.md is still the template) or whenever the user explicitly asks to re-onboard. Greets the user, learns about them, detects the system, installs and configures the data stack (database, orchestrator, Python environments), scaffolds the pipeline repository, and captures interaction preferences.
Use when building, debugging, deploying, or testing data pipelines with Prefect v3. Trigger on any code importing prefect, prefect YAML config, or user mentioning Prefect flows/tasks/deployments/workers.
Run before declaring project work complete. A self-audit checklist to honestly assess whether the deliverables actually meet the requirements before requesting final review or reporting completion to the Guide.
Run when delegating complex work to a new project. Gathers preliminary requirements with the user, creates the project in app.db, spawns a Conductor and Reviewer, introduces them to each other, updates the user, and schedules a follow-up reminder so a silent Conductor is noticed.
Build interactive HTML dashboard artifacts with live database queries via the postMessage bridge. Includes a copy-paste helper function, workflow steps, and Chart.js integration patterns.
| name | db-schema-reference |
| description | Column-level schema details for all seven app.db tables. Read this when you need exact column names, types, constraints, or indexes before writing queries or creating/updating records. |
| roles | ["guide","conductor","reviewer","worker"] |
Column-level details for the seven tables in app.db. All timestamps are UTC ISO 8601.
A data project managed by System2 agents.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| name | TEXT NOT NULL | Project name |
| description | TEXT NOT NULL | Project description |
| status | TEXT NOT NULL | todo, in progress, review, done, abandoned (default todo) |
| labels | TEXT NOT NULL | JSON array of string labels (default []) |
| start_at | TEXT | ISO 8601 timestamp when work began |
| end_at | TEXT | ISO 8601 timestamp when work completed |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
An AI agent that performs work within System2, assigned to a project or system-wide.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| role | TEXT NOT NULL | guide, conductor, narrator, reviewer |
| project | INTEGER FK | References project(id). NULL for system-wide agents |
| status | TEXT | active, archived (default active) |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
Unique indexes enforce singleton constraints on guide and narrator roles.
A unit of work within a project or standalone.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| parent | INTEGER FK | References task(id). NULL for top-level tasks |
| project | INTEGER FK | References project(id). NULL for standalone tasks |
| title | TEXT NOT NULL | Short task title |
| description | TEXT NOT NULL | Detailed description |
| status | TEXT NOT NULL | todo, in progress, review, done, abandoned (default todo) |
| priority | TEXT NOT NULL | low, medium, high (default medium) |
| assignee | INTEGER FK | References agent(id). NULL if unassigned |
| labels | TEXT NOT NULL | JSON array of string labels (default []) |
| start_at | TEXT | ISO 8601 timestamp when work began |
| end_at | TEXT | ISO 8601 timestamp when work completed |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
A directed link between two tasks.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| source | INTEGER FK NOT NULL | References task(id). The task that has the relationship |
| target | INTEGER FK NOT NULL | References task(id). The task being referenced |
| relationship | TEXT NOT NULL | blocked_by, relates_to, duplicates |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
Unique index on (source, target, relationship).
A comment on a task, authored by an agent.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| task | INTEGER FK NOT NULL | References task(id) |
| author | INTEGER FK NOT NULL | References agent(id). Auto-filled from the calling agent |
| content | TEXT NOT NULL | Comment body |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
updateTaskComment is restricted to the original author so attribution stays honest.
A file artifact created by agents, displayed in the UI.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| project | INTEGER FK | References project(id). NULL for project-free artifacts |
| file_path | TEXT NOT NULL UNIQUE | Absolute path to the file on disk |
| title | TEXT NOT NULL | Human-readable title |
| description | TEXT | Brief summary of content or purpose |
| tags | TEXT NOT NULL | JSON array of string tags (default []) |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
A record of a scheduler job execution.
| Column | Type | Description |
|---|---|---|
| id | INTEGER PK | Auto-incrementing |
| job_name | TEXT NOT NULL | Job identifier (daily-summary, memory-update) |
| status | TEXT NOT NULL | running, completed, failed, skipped (default running) |
| trigger_type | TEXT NOT NULL | cron, catch-up, manual |
| error | TEXT | Error message (failed) or skip reason (skipped) |
| started_at | TEXT NOT NULL | When execution began |
| ended_at | TEXT | When execution finished (NULL while running) |
| created_at | TEXT | Row creation timestamp |
| updated_at | TEXT | Last modification timestamp |
