Neomano TODO

neomano-todo

An improved personal TODO 系统 that uses SQLite as the backend (not text files).

Why SQLite:

Structured fields (priority/状态/dates/tags) Fast 过滤器ing and 排序ing Durable local storage with zero external dependencies Features SQLite persistence (local file) Priorities 1–3 1 = high, 2 = medium, 3 = low Tags (many-to-many) Dates due_at (when it should be done) remind_at (when to 通知) 状态es open, done, blocked, expired, forgotten Reminder metadata for OpenClaw cron Store remind_at + cron_job_id so reminders can be 创建d/更新d/cancelled by the 代理 Back记录 control 检测 “stale candidates” based on last_touched_at and priority thresholds Configuration (环境 variables)

Recommended: 设置 in ~/.OpenClaw/.env on the gateway machine.

Storage NEOMANO_TODO_DB_PATH Path to the SQLite DB file. Default used by the 辅助工具 script: ~/.OpenClaw/workspace/data/neomano-todo.sqlite3 Reminder delivery defaults

Used by the 代理 when scheduling a reminder (cron delivery).

NEOMANO_TODO_DEFAULT_CHANNEL Example: whats应用, telegram, etc. NEOMANO_TODO_DEFAULT_TAR获取 Example: +593987233203 for Whats应用. NEOMANO_TODO_TZ Example: America/Guayaquil Data 模型 (SQLite)

The 辅助工具 script auto-创建s tables on first 运行.

MAIn fields stored per task:

title, notes priority (1–3) 状态 (open|done|blocked|expired|forgotten) 创建d_at, 更新d_at, last_touched_at, completed_at due_at, remind_at cron_job_id (optional, 设置 after creating a cron job) tags via tags + task_tags 辅助工具 script

Use the bundled deterministic 辅助工具 script:

技能s/neomano-todo/scripts/todo.py

It 输出s JSON to make it easy for an 代理 to 解析.

Commands

添加 a task:

python3 技能s/neomano-todo/scripts/todo.py 添加 "安装 Starlink antenna" --priority 2 --tags "starlink,truck" --notes "This weekend"

获取 a task:

python3 技能s/neomano-todo/scripts/todo.py 获取 12

列出 tasks:

python3 技能s/neomano-todo/scripts/todo.py 列出 --状态 open --order priority python3 技能s/neomano-todo/scripts/todo.py 列出 --状态 open --order due python3 技能s/neomano-todo/scripts/todo.py 列出 --tag sales --order priority

Complete / reopen:

python3 技能s/neomano-todo/scripts/todo.py done 12 python3 技能s/neomano-todo/scripts/todo.py reopen 12

Change 状态 (blocked/expired/forgotten/etc):

python3 技能s/neomano-todo/scripts/todo.py 设置-状态 12 blocked python3 技能s/neomano-todo/scripts/todo.py 设置-状态 12 forgotten

Change priority:

python3 技能s/neomano-todo/scripts/todo.py 设置-priority 12 1

更新 tags:

python3 技能s/neomano-todo/scripts/todo.py 设置-tags 12 "sales,followup"

更新 due/reminder timestamps:

python3 技能s/neomano-todo/scripts/todo.py 设置-dates 12 --due-at "2026-03-29T09:00:00-05:00" --remind-at "2026-03-29T08:30:00-05:00"

Store cron job id (after scheduling a reminder with OpenClaw cron):

python3 技能s/neomano-todo/scripts/todo.py 设置-cron-job 12

删除:

python3 技能s/neomano-todo/scripts/todo.py 删除 12

Reminder scheduling (OpenClaw cron)

The script stores reminder timestamps; the 代理 is responsible for scheduling.

工作流:

If remind_at is 设置 and 状态 is open, 创建/更新 a cron job scheduled at remind_at. After creating the cron job, store its id in the task using 设置-cron-job. When the task becomes terminal (done, expired, forgotten), cancel the cron job (if any). Back记录 control: stale candidates

Policy:

P3 not touched for 30 days → review candidate P2 not touched for 45 days → review candidate P1 is never auto-forgotten

列出 stale candidates:

python3 技能s/neomano-todo/scripts/todo.py stale-candidates

响应 style Keep replies short. For Whats应用: use bullets (no tables). When confirming changes: include task id, title, priority, and 状态.