Automated reporting for small businesses.
Pulls orders from commerce platforms, normalizes them against a bill of materials, and generates production schedules, materials demand, and time-series analytics.
Live demo → — sample data reseeds nightly via a scheduled job so order and due dates always stay current.
Fastify · Kysely · PostgreSQL (Supabase) · Zod · TypeScript
- Aggregates raw orders into KPIs — revenue, lead time, completion rates — with time-series trends across daily, weekly, and monthly buckets and period-over-period comparisons
- Joins orders against a bill of materials to roll up total materials demand and cut lists per production batch — shared logic in
batch-aggregation.ts - Platform adapter pattern for storefronts. Currently integrated with Squarespace (Shopify and Etsy pending)
- Read-only demo mode so anyone can explore the full app with sample data — no signup required
- Unhandled errors are captured to Sentry in production for observability
A few of the more interesting analytics queries are written up in docs/sql-showcase.md — window functions, CTEs, conditional aggregation, and period-over-period comparisons.
Every endpoint is documented with OpenAPI, generated from the Zod schemas that validate each request and response — so the docs always match the live API.
API Docs → · Interactive Docs →
erDiagram
users ||--o{ stores : owns
stores ||--o{ orders : has
stores ||--o{ products : sells
stores ||--o{ production_batches : runs
orders ||--o{ order_items : contains
order_items }o--|| products : references
products ||--o{ bom_items : "defined by"
bom_items }o--|| materials : uses
production_batches }o--o{ orders : groups
- lemmary-app — React application
Built by Artifact Studio.