⚡Streamtime automation & MCP tools

Streamtime is the project-management platform the agency runs on — every job, quote, timesheet and invoice lives there. This is the family of tools I built around it so that reporting, profitability analysis and day-to-day admin largely run themselves.

The analytics platform syncs Streamtime into a reporting database through a rate-limited, resumable sync engine, then serves revenue and profitability dashboards used for leadership reporting: revenue by client, work type and creator, with invoice totals prorated across line items, multi-currency amounts normalised and integrity-flagged, and AI classification of work types with a keyword fallback. An analytics chat answers plain-English questions through guarded, SELECT-only text-to-SQL.

A second app wraps Streamtime in three surfaces served by one core: an MCP server exposing ~20 reporting, forecasting and scheduling tools to ChatGPT — with charts rendered server-side and returned inline — a live budget-burn dashboard driven by a rules-based job-health engine, and a Slack bot that DMs each project manager a weekly burn digest grouped by risk, on timezone-aware crons with idempotency markers.

The third piece is quieter: a Sage HR–Streamtime holiday sync that reconciles approved leave into scheduled time. It diffs before it writes, so re-runs never double-book anyone, handles half-days and partial failures, and its cleanup tool refuses to touch time a human logged. Together the suite eliminates hundreds of hours of manual administration a year.