tdlite

A lightweight CLI task manager for npm projects using SQLite for local storage.

Features

• Category-based Organization: Organize tasks into custom categories
• SQLite Storage: Local database storage with no external dependencies
• Flexible Task Management: Add, update, search, and track task status
• JSON Integration: Import/export tasks in JSON format
• Status Tracking: Mark tasks as work-in-progress (wip) or done
• Search Capabilities: Full-text search across task names and descriptions

Quick Start

1. Initialize the database in your project:

npx tdlite init

2. Add some tasks:

npx tdlite add backend '[{"customId": "api-001", "name": "Create user API", "description": "Implement user CRUD operations"}]'

3. List your tasks:

npx tdlite show backend

Commands

Database Management

init [--force]

Initialize the database in your project root. Creates tasks.db file.

• --force: Recreate database if it already exists

npx tdlite init
npx tdlite init --force

Task Management

add <category> <jsonArray>

Add or update tasks in a specific category. Tasks are upserted based on customId.

npx tdlite add backend '[
  {
    "customId": "api-001",
    "name": "Create user API",
    "description": "Implement user CRUD operations"
  },
  {
    "customId": "auth-001", 
    "name": "Implement authentication",
    "description": "Add JWT-based authentication"
  }
]'

get <category> <id|customId>

Retrieve a specific task by ID or custom ID.

npx tdlite get backend api-001
npx tdlite get backend 1

list <category>

List all tasks in a category (JSON format).

npx tdlite list backend

show <category>

Display tasks in a formatted table.

npx tdlite show backend

Task Status

todo <category>

List tasks with "wip" (work-in-progress) status.

npx tdlite todo backend

done <category> <id|customId> [comment]

Mark a task as completed with optional comment.

npx tdlite done backend 1 "API implementation completed"
npx tdlite done backend api-001 "API implementation completed"

wip <category> <id|customId> [comment]

Mark a task as work-in-progress with optional comment.

npx tdlite wip backend 1 "Starting API development"
npx tdlite wip backend api-001 "Starting API development"

Search and Remove

search <category> <query>

Search tasks by customId, name, or description.

npx tdlite search backend API
npx tdlite search backend auth

remove <category> <id>

Remove a task by ID.

npx tdlite remove backend 1

Task Structure

Each task contains the following fields:

| Field | Type | Description | |-------|------|-------------| | id | integer | Auto-incrementing primary key | | customId | string | User-defined unique identifier | | category | string | Task category | | name | string | Task name | | description | string | Detailed description | | status | string | Either "wip" or "done" | | comment | string | Additional comments | | createdAt | timestamp | Creation time | | updatedAt | timestamp | Last update time |

Use Cases

Project Planning

# Initialize and add project tasks
npx tdlite init
npx tdlite add frontend '[{"customId": "ui-001", "name": "Design homepage"}]'
npx tdlite add backend '[{"customId": "db-001", "name": "Setup database"}]'

Development Workflow

# Start working on a task
npx tdlite wip frontend ui-001 "Starting homepage design"

# Check current work
npx tdlite todo frontend

# Complete a task
npx tdlite done frontend ui-001 "Homepage design completed"

Team Coordination

# View all project tasks
npx tdlite show backend
npx tdlite show frontend

# Search for specific features
npx tdlite search backend authentication

Development

This project is built with:

• TypeScript for type safety
• SQLite with Drizzle ORM for data persistence
• tsdown for building
• Vitest for testing
• Biome for linting and formatting

Build Commands

pnpm build      # Production build
pnpm typecheck  # Type checking
pnpm lint       # Linting
pnpm test       # Run tests

License

MIT