滴答清单(TickTick)本地数据库 CLI 工具 - 只读版本。
直接从本地 SQLite 数据库读取滴答清单数据,无需登录,无网络依赖。
- 列出项目 - 查看所有滴答清单项目
- 列出任务 - 支持按项目/标签筛选
- 查看任务 - 显示任务详情
- 列出标签 - 查看所有标签
- 番茄钟记录 - 查看专注记录,支持按日期/任务/项目筛选和按天汇总
默认读取以下路径的数据库文件:
| 平台 | 路径 |
|---|---|
| Windows | %APPDATA%\Tick_Tick\TickTick.db |
| macOS | ~/Library/Application Support/Tick_Tick/TickTick.db |
| Linux | ~/.local/share/Tick_Tick/TickTick.db |
cargo build --release编译产物位于 target/release/ticktick-cli(或 ticktick-cli.exe)
从 Releases 页面下载对应平台的二进制文件。
命令格式:ticktick-cli <noun> <verb>
# 列出所有项目
ticktick-cli projects list# 列出所有待办任务
ticktick-cli tasks list
# 列出所有任务(含已完成和已取消)
ticktick-cli tasks list --show-all
# 按项目筛选
ticktick-cli tasks list --project inbox # 收集箱
ticktick-cli tasks list --project 4 # 项目ID
# 按标签筛选
ticktick-cli tasks list --tags work
# 查看任务详情
ticktick-cli tasks show 10# 列出所有标签
ticktick-cli tags list# 查看最近番茄钟记录
ticktick-cli pomos list
# 查看指定日期的记录
ticktick-cli pomos list --date 2026-05-07
# 按日期范围查看
ticktick-cli pomos list --from 2026-05-01 --to 2026-05-07
# 按天汇总
ticktick-cli pomos list --from 2026-05-01 --to 2026-05-07 --summary
# 按任务或项目筛选
ticktick-cli pomos list --task 10
ticktick-cli pomos list --project inbox
# 限制显示条数
ticktick-cli pomos list --limit 20# 指定数据库路径
ticktick-cli --db /path/to/TickTick.db tasks list| 状态 | 符号 | 说明 |
|---|---|---|
| Pending | [ ] |
未完成 |
| Completed | [x] |
已完成 |
| Cancelled | [-] |
已取消 |
| 优先级 | 符号 |
|---|---|
| 高 | 🔴 |
| 中 | 🟡 |
| 低 | 🟢 |
| 无 | ⚪ |
- Rust 1.75+
本工具为只读工具,不会修改任何数据。使用前请自行备份数据库。
TickTick CLI - A read-only CLI tool for accessing your local TickTick database.
Directly reads TickTick data from your local SQLite database. No login required, no network dependency.
- List Projects - View all TickTick projects
- List Tasks - Filter by project/tags
- Show Task - Display task details
- List Tags - View all tags
- Pomodoro Records - View focus records with date/task/project filters and daily summaries
Default database paths by platform:
| Platform | Path |
|---|---|
| Windows | %APPDATA%\Tick_Tick\TickTick.db |
| macOS | ~/Library/Application Support/Tick_Tick/TickTick.db |
| Linux | ~/.local/share/Tick_Tick/TickTick.db |
cargo build --releaseBinary will be at target/release/ticktick-cli (or ticktick-cli.exe)
Get the binary for your platform from the Releases page.
Command format: ticktick-cli <noun> <verb>
# List all projects
ticktick-cli projects list# List pending tasks
ticktick-cli tasks list
# List all tasks (including completed and cancelled)
ticktick-cli tasks list --show-all
# Filter by project
ticktick-cli tasks list --project inbox
ticktick-cli tasks list --project 4
# Filter by tags
ticktick-cli tasks list --tags work
# Show task details
ticktick-cli tasks show 10# List all tags
ticktick-cli tags list# Show recent pomodoro records
ticktick-cli pomos list
# Show records on a specific date
ticktick-cli pomos list --date 2026-05-07
# Show records in a date range
ticktick-cli pomos list --from 2026-05-01 --to 2026-05-07
# Show daily totals
ticktick-cli pomos list --from 2026-05-01 --to 2026-05-07 --summary
# Filter by task or project
ticktick-cli pomos list --task 10
ticktick-cli pomos list --project inbox
# Limit number of rows
ticktick-cli pomos list --limit 20# Specify database path
ticktick-cli --db /path/to/TickTick.db tasks list| Status | Symbol | Description |
|---|---|---|
| Pending | [ ] |
Incomplete |
| Completed | [x] |
Done |
| Cancelled | [-] |
Cancelled |
| Priority | Symbol |
|---|---|
| High | 🔴 |
| Medium | 🟡 |
| Low | 🟢 |
| None | ⚪ |
- Rust 1.75+
This tool is read-only and will not modify any data. Please backup your database before use.
MIT