VFX Dashboard

The Full Case Study

A full production system, one I rely on, not a demo.

The Piece I'm Proudest Of

Full-Stack Shot Tracking System • In Active HBO Production • TypeScript + AI

This is the piece I'm proudest of. It's the live shot-tracker I use every day on my current HBO show, designed around the actual way a VFX editor works, not the way software vendors imagine we work. It watches my EDL folder, ingests cut changes automatically, reads my email, confirms CO3 receipts, catches "zombie shots" that silently disappeared from a cut, and lets me ask it questions in plain English: "which shots are waiting on plates for episode 104?" It has a War Room view for the morning stand-up, a Producer view for the iPad, and an Insights page that surfaces things I'd otherwise miss.

The Views

Five surfaces on the same database, each tuned to a specific moment in the day.

Master lineup sheet, every shot on the show at a glance, filterable by episode, vendor, status, and delivery state.

Producer View, visual shot grid with thumbnails, status/episode/vendor filtering, built for iPad over Wi-Fi.

Shot Tracker, full table with VFX IDs, status, vendor, version, descriptions, timecodes, and marker colors.

War Room, real-time pipeline status for daily standups. Green checkmark when everything is dropped in.

Insights, AI-powered anomaly detection finds "zombie shots" that disappeared or came back from the dead.

Feature Cloud

A full-stack production system with AI, real-time dashboards, and automated pipeline tracking.

War RoomReal-time pipeline status surface for the morning standup

EDL ScannerWatches the EDL folder, ingests cut changes automatically

AI InsightsAnomaly detection that surfaces what I'd otherwise miss

ShotGrid SyncReconciles studio statuses and bulk-fills blank fields

9-Stage PipelineStrictly ordered statuses with forward-only same-version rules

Email AgentReads my mail, parses vendor deliveries and CO3 receipts

Version TrackingPer-shot version history with sent-to-editorial dates

CO3 ReceiptsAuto-confirms what Jason actually conformed at the online

Vendor DashboardPer-vendor lineup, delivery, and outstanding views

Drop-In TrackerLogs every drop-in session and what shots went in

Shot HistoryFull timeline of every status change, note, and event

Plate PullsTracks 80+ plate pulls from request through delivery

Reference ExtractionPulls reference images and metadata directly from email

Image DescriptionsAI-generated captions stored against every reference asset

Producer ViewiPad-friendly thumbnail grid built for over-the-shoulder reviews

Archive BrowserSearches every accessible drive for legacy shot files

Anthropic SDKPlain-English shot queries powered by the Claude API

SQLiteLocal single-file database, fast and reliable on set

PWAInstallable progressive web app, opens like a native tool

macOS AppNative shell for the always-on station at my edit bay

TypeScriptStrict-mode end to end, server and client share types

ThemesLight, dark, and high-contrast presets for room conditions

The Piece I'm Proudest Of

Let's build something together