Neomano TODO

Enhanced TODO/task manager backed by a local SQLite database (instead of flat text files) with priorities (1-3), tags, due dates, reminder timestamps, explic...

Security Scan

The skill is internally consistent: it's a local SQLite-backed TODO helper that only reads/writes a local DB and matches its SKILL.md behavior.

Purpose & Capability

Name/description match the included helper script and data model. The script implements task CRUD, tagging, priorities, reminders metadata and stale-candidate logic described in SKILL.md.

Instruction Scope

Runtime instructions and the script only operate on a local SQLite file (default under ~/.openclaw/workspace/data/). The skill stores reminder metadata (cron_job_id) for an external scheduler but does not attempt network access or read unrelated system files.

Install Mechanism

No install spec; this is an instruction-only skill with a bundled deterministic Python helper. Nothing is downloaded or installed automatically.

Credentials

No required environment variables or credentials. Optional env vars (DB path, default channel/target/timezone) are reasonable for reminder delivery and local DB location.

Persistence & Privilege

Skill is not always-enabled and does not request elevated or cross-skill privileges. It only creates/uses its own DB under the user's OpenClaw workspace.

Assessment

This skill appears to do only local task management. Before installing, confirm the DB path (default: ~/.openclaw/workspace/data/neomano-todo.sqlite3) is acceptable, and ensure filesystem permissions protect any sensitive notes or stored reminder targets (phone numbers). Reminders rely on the agent's cron/scheduler and any channel/target you configure — the agent (not this script) must have permission to create/send reminders. If you need stronger assurance, inspect the full script locally and run it in a safe environment; there are no network calls or hidden endpoints in the provided code.

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

Why SQLite:

• Structured fields (priority/status/dates/tags)
• Fast filtering and sorting
• 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 notify)
• Statuses
  • open, done, blocked, expired, forgotten
• Reminder metadata for OpenClaw cron
  • Store remind_at + cron_job_id so reminders can be created/updated/cancelled by the agent
• Backlog control
  • Detect “stale candidates” based on last_touched_at and priority thresholds

Configuration (environment variables)

Recommended: set in ~/.openclaw/.env on the gateway machine.

Storage

• NEOMANO_TODO_DB_PATH
  • Path to the SQLite DB file.
  • Default used by the helper script: ~/.openclaw/workspace/data/neomano-todo.sqlite3

Reminder delivery defaults

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

• NEOMANO_TODO_DEFAULT_CHANNEL
  • Example: whatsapp, telegram, etc.
• NEOMANO_TODO_DEFAULT_TARGET
  • Example: [phone] for WhatsApp.
• NEOMANO_TODO_TZ
  • Example: America/Guayaquil

Data model (SQLite)

The helper script auto-creates tables on first run.

Main fields stored per task:

• title, notes
• priority (1–3)
• status (open|done|blocked|expired|forgotten)
• created_at, updated_at, last_touched_at, completed_at
• due_at, remind_at
• cron_job_id (optional, set after creating a cron job)
• tags via tags + task_tags

Helper script

Use the bundled deterministic helper script:

• skills/neomano-todo/scripts/todo.py

It outputs JSON to make it easy for an agent to parse.

Commands

Add a task:

python3 skills/neomano-todo/scripts/todo.py add "Install Starlink antenna" --priority 2 --tags "starlink,truck" --notes "This weekend"

Get a task:

python3 skills/neomano-todo/scripts/todo.py get 12

List tasks:

python3 skills/neomano-todo/scripts/todo.py list --status open --order priority
python3 skills/neomano-todo/scripts/todo.py list --status open --order due
python3 skills/neomano-todo/scripts/todo.py list --tag sales --order priority

Complete / reopen:

python3 skills/neomano-todo/scripts/todo.py done 12
python3 skills/neomano-todo/scripts/todo.py reopen 12

Change status (blocked/expired/forgotten/etc):

python3 skills/neomano-todo/scripts/todo.py set-status 12 blocked
python3 skills/neomano-todo/scripts/todo.py set-status 12 forgotten

Change priority:

python3 skills/neomano-todo/scripts/todo.py set-priority 12 1

Update tags:

python3 skills/neomano-todo/scripts/todo.py set-tags 12 "sales,followup"

Update due/reminder timestamps:

python3 skills/neomano-todo/scripts/todo.py set-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 skills/neomano-todo/scripts/todo.py set-cron-job 12 <cron_job_id>

Delete:

python3 skills/neomano-todo/scripts/todo.py delete 12

Reminder scheduling (OpenClaw cron)

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

Workflow:

1. If remind_at is set and status is open, create/update a cron job scheduled at remind_at.
2. After creating the cron job, store its id in the task using set-cron-job.
3. When the task becomes terminal (done, expired, forgotten), cancel the cron job (if any).

Backlog 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

List stale candidates:

python3 skills/neomano-todo/scripts/todo.py stale-candidates

Response style

• Keep replies short.
• For WhatsApp: use bullets (no tables).
• When confirming changes: include task id, title, priority, and status.