todo-manager

name	todo-manager
description	Manage the SQLite todos database for the project. Use when you need to list, add, delete, or mark todos as completed. This skill provides a consistent and auditable interface via a management script.

ToDo Manager

This skill allows you to manage the SQLite todos.db database using a Python script. It ensures that all database operations are consistent and follow the project's schema.

Core Procedures

1. List Todos

To see all currently stored todos:

python3 .gemini/skills/todo-manager/scripts/manage_todos.py list

2. Add a New Todo

To add a new todo to the list:

python3 .gemini/skills/todo-manager/scripts/manage_todos.py add "Your todo title"

3. Delete a Todo

To remove a todo by its ID:

python3 .gemini/skills/todo-manager/scripts/manage_todos.py delete [ID]

4. Complete a Todo

To mark a todo as completed:

python3 .gemini/skills/todo-manager/scripts/manage_todos.py complete [ID]

Schema Information

• Database File: todos.db
• Table: todos
• Columns:
  • id: INTEGER (Primary Key)
  • title: TEXT
  • completed: BOOLEAN

Always use the provided script instead of raw SQL to maintain consistency.