← Back to Skills Marketplace
laoyutang

Todo SQLite

by LaoYutang · GitHub ↗ · v1.1.0 · MIT-0
cross-platform ⚠ suspicious
175
Downloads
0
Stars
0
Active Installs
4
Versions
Install in OpenClaw
/install todo-sqlite
Description
Manage multi-project todos with SQLite, supporting subtasks, priority/urgency levels, keyword search, time filters, smart sorting, and scheduled reminders.
Usage Guidance
This skill appears to be a local SQLite todo CLI and does not ask for secrets or network access, but there are notable incoherences between the documentation and the bundled Python code that could cause runtime errors or unexpected behavior. Before installing or enabling it: 1) Inspect the full todo.py for any network or subprocess calls (the provided portion shows none, but the file was truncated). 2) Be aware it will create/modify ~/.openclaw/workspace/data/todo.db — back up any existing data there. 3) Test the script in an isolated environment (container or throwaway account) to confirm it works and doesn't crash; several bugs are visible (mismatched types for importance/urgency, incorrect SQL ordering using string labels vs stored integers, and a join/print that may raise TypeError). 4) Prefer a skill with a known source/homepage or request the maintainer to fix the implementation/documentation mismatches before using it in production.
Capability Analysis
Type: OpenClaw Skill Name: todo-sqlite Version: 1.1.0 The skill is a standard SQLite-based todo management tool. Analysis of todo.py and SKILL.md shows no evidence of data exfiltration, malicious execution, or prompt injection; all database queries use parameterized inputs to prevent SQL injection, and the code relies solely on the Python standard library.
Capability Assessment
Purpose & Capability
Name/description match the implementation intent: a local SQLite-based todo manager storing DB at ~/.openclaw/workspace/data/todo.db. The skill does not request unrelated credentials or binaries. However, the code and SKILL.md disagree on how importance/urgency are represented (SKILL.md says numeric 1/2/3; parts of todo.py use string labels like 'critical'/'high'/'medium'/'low' and other parts treat levels as ints). These inconsistencies suggest poor implementation or drift between docs and code.
Instruction Scope
SKILL.md instructions stay within scope: create/list/edit/delete todos, and using OpenClaw cron to run 'todo list-all --pending' for reminders. Instructions do not ask the agent to read unrelated files or environment variables, nor to send data to external endpoints beyond the platform's cron/send mechanism.
Install Mechanism
There is no install spec (instruction-only plus a bundled todo.py). Nothing is downloaded from external URLs and no installers are declared, so there is no install-time network risk. The script will create a local directory and DB file, which is expected.
Credentials
The skill requires no environment variables, no external credentials, and no config paths beyond its own DB path. That is proportionate for a local todo manager.
Persistence & Privilege
always is false and the skill does not request elevated or cross-skill configuration. It will create and write a single DB file under the user's home workspace, which is expected behavior.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install todo-sqlite
  3. After installation, invoke the skill by name or use /todo-sqlite
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.1.0
等级系统改为数字:1=普通, 2=重要🟠🔥, 3=紧急🔴🔥🔥
v1.0.2
low 级别不显示任何标记,只有 medium🟠🔥 和 high🔴🔥🔥 才显示
v1.0.1
修复显示规则:high🔴🔥🔥、medium🟠🔥、low[一般];默认级别改为 low
v1.0.0
初始版本:多项目待办管理,支持子待办、重要/紧急程度、智能排序、定时提醒
Metadata
Slug todo-sqlite
Version 1.1.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 4
Frequently Asked Questions

What is Todo SQLite?

Manage multi-project todos with SQLite, supporting subtasks, priority/urgency levels, keyword search, time filters, smart sorting, and scheduled reminders. It is an AI Agent Skill for Claude Code / OpenClaw, with 175 downloads so far.

How do I install Todo SQLite?

Run "/install todo-sqlite" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Todo SQLite free?

Yes, Todo SQLite is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Todo SQLite support?

Todo SQLite is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Todo SQLite?

It is built and maintained by LaoYutang (@laoyutang); the current version is v1.1.0.

💬 Comments