Web Application

Henry Media Dashboard

Client-facing analytics platform with AI-assisted reporting on top of BigQuery.

RoleArchitect & Lead Developer
DurationOngoing
Year2026
ClientIdea Ranch

Overview

A multi-tenant analytics dashboard platform that turns raw marketing and campaign data into client-ready reporting. Next.js 16 on the front, Drizzle ORM over PostgreSQL for application data, BigQuery for the warehouse, and a background worker for scheduled syncs. An integrated AI layer built on the Claude API and Model Context Protocol lets users interrogate their data conversationally, and dashboards export to shareable PDFs for client delivery.

Technology Stack

Next.js 16TypeScriptDrizzle ORMPostgreSQLBigQueryClaude APIMCPRechartsUpstash Redis

Key Highlights

  • →Multi-source data pipeline syncing campaign data into BigQuery with a dedicated worker process
  • →Conversational AI reporting built on the Claude API and Model Context Protocol
  • →Interactive visualizations with Recharts and d3-geo, exportable to client-ready PDFs
  • →Typed end to end with Drizzle ORM, Biome, and Vitest across the stack

Project Gallery

A walkthrough of Henry in action.

Spend and conversions trend chart with a campaign performance table

Trend charts and sortable campaign tables, synced from the warehouse.