Statli

Project status tracking dashboard with AI-powered data ingestion.

Prerequisites: Node.js 24+, Docker (optional)

git clone https://github.com/jbrinkman/statli.git
cd statli
npm ci
cp .env.example .env  # edit with real secrets
npm run dev

Open http://localhost:4321.

Generate secrets:

openssl rand -base64 32  # AUTH_SECRET
openssl rand -hex 32     # STATLI_API_KEY

SQLite with custom migration system. Database file lives in data/ (gitignored).

Migrations run automatically on startup. Add new migrations in src/lib/db/migrations/ with ascending numeric prefixes.

Dual auth scheme:

• Browser sessions: Better Auth with email/password (cookie-based)
• Machine clients: Bearer API key via Authorization: Bearer <STATLI_API_KEY>

All /api/* routes (except /api/auth/*) require authentication.

npm run test              # unit + integration tests (Vitest)
npm run test:coverage     # with 80% threshold enforcement
npm run test:e2e:install  # install Playwright browsers (first time)
npm run test:e2e          # e2e tests (Playwright)

docker build -t statli .
docker run --rm -p 127.0.0.1:4321:4321 statli

Or run both services (app + MCP server) together:

cp .env.example .env  # edit with real secrets
docker compose up --build

This starts:

• App at http://127.0.0.1:4321 (dashboard + API)
• MCP at http://127.0.0.1:4322/mcp (agent tools)

The project includes an MCP (Model Context Protocol) server for AI agent integration. It uses the streamable HTTP transport and listens on port 4322 by default.

npm run build:mcp             # Compile TypeScript
STATLI_API_KEY=<key> STATLI_API_URL=http://127.0.0.1:4321 npm run start:mcp

The MCP endpoint is available at http://127.0.0.1:4322/mcp.

Add to ~/.kiro/crew/mcp.json:

{
  "statli": {
    "url": "http://127.0.0.1:4322/mcp"
  }
}

Project management: list_projects, get_project, create_project, update_project, delete_project, lock_project, unlock_project

Review items: list_review_items, add_review_item, resolve_review_item

History: get_change_history

Reports: generate_report

npm run seed -- --report-path path/to/status-report.md
npm run validate:sources   # compare against Confluence (requires atlas CLI)

npm run report:generate                          # stdout, last 7 days
npm run report:generate -- --since 2026-08-01    # custom date range
npm run report:generate -- --output report.md    # write to file

An automated KiroCrew cron job runs at 8am ET to:

• Check submitted PRs for merges/closures (via gh CLI)
• Detect releases for merged projects
• Auto-promote merge_is_complete projects
• Flag ambiguous situations for human review

Prerequisites: gh CLI authenticated (gh auth login), Statli server running, MCP server registered.

Registration (via KiroCrew):

cron_add(name: "statli-daily-update", at_time: "8am", message: "Run the Statli daily update. Read ~/projects/statli/cron/daily-update.md and follow its instructions using the statli MCP tools and gh CLI.")

Astro SSR application serving a dashboard UI and API routes, backed by SQLite. Single process — no separate backend service.

See CONTRIBUTING.md.