Work/Dashboards & Internal Tools
Oilfield Chemical Operations Dashboard
One dashboard and write-capable AI chatbot for a chemical supplier's yard
What it is
A prototype operations dashboard for Supreme Chemical Technologies, a production-chemical company serving oilfield wells. It consolidates mineral concentration readings from water, truck shipment status and live chemical yard stock into one overview, with pages for wells, plants, shipments and yards plus alerts. An embedded chatbot on the Anthropic SDK can query the data and, with write access, update it. A companion scope document outlines a production platform and an offline-capable iPad app for delivery drivers.
The problem
Operations ran on Excel workbooks and paper manifests, with no real-time view of inventory, deliveries or well readings.
How it works
- A React, Vite and TypeScript front end with Chart.js, a login flow and an alert context.
- Data services connect to Supabase with a mock-data fallback, and a refresh hook keeps panels live.
- A Vercel api/chat.ts function hosts the chatbot with tool access to the data.
- SQL schema, seed data and an oilfield-chemicals migration, plus Vitest tests for the overview page.
Stack
Disciplines
For your business
A single operations dashboard with an AI assistant that lets field and office staff ask questions of, and update, their live operating data.