+/- table definition
Query
CREATE TABLE agents (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
description TEXT NOT NULL DEFAULT '',
model TEXT NOT NULL DEFAULT 'claude-sonnet-4-6',
permission_mode TEXT NOT NULL DEFAULT 'confirm',
is_main INTEGER NOT NULL DEFAULT 0,
parent_id TEXT,
enabled INTEGER NOT NULL DEFAULT 1,
instructions TEXT NOT NULL DEFAULT '',
soul TEXT NOT NULL DEFAULT '',
identity TEXT NOT NULL DEFAULT '',
tools_config TEXT NOT NULL DEFAULT '{}',
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
user_id TEXT NOT NULL DEFAULT '',
FOREIGN KEY (parent_id) REFERENCES agents(id) ON DELETE SET NULL
)