Inspiration In large engineering organizations, task visibility breaks down as teams scale. A VP has no real-time view of what's bottlenecked three levels down, and a manager spends hours chasing approvals up the chain. We asked: what if every leader had an intelligent agent scoped exactly to their span of control? One surface that rolls up every task from everyone who reports to them—directly or indirectly—so they can approve, reassign, or escalate in seconds. SpanCommand was born from the frustration of hierarchical blind spots in enterprise workflows.

What we learned Recursive org-tree traversal is deceptively tricky when you need it to be performant at query time—we learned to balance eager subtree loading with scoped queries. Designing a single UI that feels relevant to a VP (seeing 18 people's tasks) and an engineer (seeing just their own) required careful thought around role-aware filtering and progressive disclosure. SQLite is surprisingly capable for hackathon-speed prototyping with relational integrity (foreign keys, CTEs) without any infra overhead.

Built With

  • agent
  • better-sqlite3
  • frontend:-react
  • hierarchical
  • langchain
  • lucide-icons-backend:-express.js
  • multi-agent-systems
  • node.js
  • openai-api
  • react-router
  • rest-api-agentic-ai:-langgraph
  • sqlite
  • tailwind-css
  • vite
Share this project:

Updates