Loading.
Back to work
CASE 02 FULL-STACK AI REAL-TIME

igdesk —
Instagram command centre

Full-stack platform replacing a dozen browser tabs and three spreadsheets. Real-time comment ingestion, AI sentiment scoring, SLA-tracked inbox, and a fluid reply workflow — for a brand running posts, reels, ads, stories and collabs at the same time.

Role Full-stack solo
Stack React · Node · Postgres
AI GPT-4o-mini
Deployment AWS EC2 · Tokyo

Instagram is the storefront. Nothing was built for it.

The brand was managing Instagram across posts, reels, carousels, ads, stories and collabs with a stack of native tools: Meta Business Suite for one thing, a third-party scheduler for another, Google Sheets for SLA tracking, and a Telegram group for crisis comments. Comments were missed. Sentiment was guessed at. There was no source of truth.

One platform, one inbox, one feed.

Meta webhooks push every comment, mention, and DM into a Node ingestion layer the moment it happens. Token threading and automatic media refresh handle Meta's quirks. PostgreSQL stores the canonical event log; SSE pushes updates to the frontend so the inbox feels live, not polled.

  • Real-time comment pipeline via Meta webhooks with full error-recovery and replay.
  • GPT-4o-mini sentiment scoring per comment: positive, negative, crisis, spam, question — flowing into weekly and monthly trend dashboards.
  • SLA-tracked inbox with unanswered detection, keyboard shortcuts, reply workflows, and SSE-powered live updates.
  • Setup & Webhook Log viewer for live payload debugging with full event history.

A side-quest that became a moat.

Building igdesk solo meant constantly hitting context-window walls in AI coding sessions. So I built graphify: a codebase knowledge graph that produces semantic subgraphs of just the relevant code for the task at hand. It gets injected into AI coding sessions — cutting token usage by roughly 75%.

~75% Token reduction
5 Content surfaces
SSE Live updates
Token reduction
0%
Content surfaces
5
Live update speed
SSE

Boring stack, sharp execution.

Stack chosen for reliability and ownership, not novelty. AWS EC2 Tokyo. Caddy for automatic HTTPS. Cloudflare DNS. systemd for service management. Daily Postgres backups.

React Node.js PostgreSQL Meta Graph API GPT-4o-mini SSE AWS EC2 Caddy Cloudflare systemd

From three tools to none.

The social team works inside igdesk now. No tab-switching, no SLA spreadsheet, no missed crisis comment. Sentiment trends show up where they're useful: in monthly content reviews. The team replies faster, because the inbox is built for replying, not browsing.

Next case · 03 SupportDesk — CS Ticketing