Production analysis MCP server
Used by analysts and managers where I work.
A FastMCP server over the production database, with a knowledge base built from the bag-machine and extrusion manuals. SQL execution, document generation and retrieval are exposed as separate tools, with schema introspection and audit logging, so a language model can reach production data safely and every access leaves a record.
It replaced ad-hoc analysis requests. It is now the tool I reach for first rather than the exception.
Python · FastMCP · SQL Server · RAG
Pipelines and dimensional models
Used by every report the business runs on.
Fact and dimension models in SQL Server, fed by around fifteen batch and streaming pipelines across production, material and QC. Terabyte-scale ingestion from the ERP system and from machine sensors, with acquisition taken straight off the hardware through PLCs and Kepware over OPC-UA.
Python · PySpark · SQL Server · Kepware / OPC-UA
Screenshot to come: the Titan dashboard, cropped to the panel — once
showing 3/3 online · leader #1, once after killing node 1 showing
2/3 online · leader #2.
Titan — distributed SQLite
Used by anyone who pip installs it.
A distributed, highly available SQLite database written in Rust, with the Raft consensus engine built from scratch: leader election, failover, replicated multi-table transactions, an HTTP API and a Python client. A three-node cluster survives losing a node without losing data.
Rust · Raft · SQLite · Tokio
Screenshot to come: one real screen of MenuWeek in use — the planned dinner, the grocery list and who is cooking.
MenuWeek
Used by ten roommates, every evening.
A dinner planner for a ten-person household: the menu, the groceries, the prep tasks and who cooks what, for around twenty plates, pure vegetarian with no onion or garlic. A React progressive web app with accounts behind it, installable to a phone's home screen.
React · Supabase · Vercel
Also built
- Product lineage platform. Products, orders, components, materials and scrap in one connected model — single-click lineage for hundreds of finished goods. Used by plant managers and executives.
- Weekly production email pipeline. Structured data in, HTML card reports out, on a seven-pillar framework. Replaced a Power Automate flow.
- Daily production report app. Real-time reporting. Replaced paper forms filled in by hand, and the transcription errors that came with them.
- SQL alert engine. Config-driven and packaged, with cooldown logic against notification fatigue. A new alert is a config change, not a code change.
- Opportunity Cost Widget. Shows the real cost of an Amazon purchase as future investment value and hours worked. On the Chrome Web Store, used by strangers.
- JobFlow. A job application manager with a browser extension that fills in application forms. Built for myself.
- First-click attribution pipeline. Kafka, Flink and Postgres, joining checkouts to clicks in event time. A learning project, on synthetic data.
About
I'm a data engineer. The work has the same shape wherever I've done it: an ocean of raw data in, something clean and usable out — pipelines, models, and tools people actually open. Right now that's a manufacturer in New York, where the data comes off physical machines; before that it was a data lake on AWS. Evenings, I build small things that remove a bottleneck. Titan is Rust, a language I learned by building it. Badminton is the love; pickleball and volleyball are what actually get played.
Photograph to come.