ProjectBoard: a SQLite tree for agent work, with a lifecycle that refuses illegal moves

Описание и применение

ProjectBoard – это легковесный инструмент, хранящий задачи в одном SQLite‑файле, обеспечивающий строгую схему переходов состояний и автоматическое прикрепление коммитов, что упрощает отслеживание работы агентских процессов.

Задача

Managing agent work products as markdown files leads to difficulty tracking what is in flight, who owns it, and what actually happened, requiring manual grepping.

Результат

ProjectBoard provides a single SQLite file that enforces a state machine, records evidence, and offers multiple interfaces, reducing manual tracking and preventing illegal state transitions.

Рабочий процесс

• Initialize database with pb init
• Seed demo project with pb seed
• View tree with pb tree
• Serve dashboard and MCP with pb serve
• Use CLI commands to create, move, assign, verify, and search nodes

Доказательства

ProjectBoard is my attempt at the smallest thing that answers those: one SQLite file, one tree, one typed lifecycle, and three faces on top of it (CLI, MCP, read‑only dashboard).

Источник

Illegal transitions are errors, not silent writes. todo → done is refused. So is blocked → review.

Источник

review → done is a separate operation that requires evidence.

Источник

Commits attach themselves. Put a node id in the commit message, e.g. #PROJ/REQ-AUTH/ISSUE-LOGIN-TIMEOUT, and the post‑commit hook calls pb commit attach with the sha.

Источник