Projects

MCP Server for Blockchain Analytics

Built an MCP server enabling analysts to explore standardized blockchain metrics. Consolidated 10+ tools down to 4 to minimize agent decision complexity, and reduced context per call from ~20,000 tokens to ~200 through progressive disclosure.

TypeScript, MCP, Claude API, SQLite, FTS5

Text-to-SQL Agent over 2PB Data Warehouse

Engineered a chat-based agent that translates natural language into SQL queries against thousands of undocumented BigQuery tables. Automated table and column description generation to provide the agent with contextual metadata and improve query accuracy.

TypeScript, Vercel AI SDK, BigQuery, LLM Agents

Semantic Discovery Layer

Designed a discovery system using SQLite and FTS5 full-text search within an isolated container, enabling agents to resolve ambiguous queries across thousands of different entities.

SQLite, FTS5, TypeScript, Cloudflare Workers, Docker

Warehouse Packing Application

Developed a custom packing app that cut order pack errors by 65% and enabled delivery of 5MM+ products. Later rolled out batch packing sessions that halved warehouse packing times.

TypeScript, React, Next.js, Node.js

Platform-Agnostic Ordering System

Developed an ordering system using a workflow engine, launching an Uber Eats integration that increased total revenue by 8%.

TypeScript, Node.js, Workflow Engine

Event Ticket Pricing Aggregator

Scraped ticket sites, storing 400K rows of sales and listing data daily using automated scripts and browser tools.

Python, Web Scraping, Data Pipelines