A solo-built smart farm platform for sweet basil (DWC hydroponics) in Chiang Mai. 12 iterations across 4 subsystems: landing page, blog, owner command center, and a feature-rich LINE OA bot with Claude Opus powering weekly AI insight reports.
PROBLEM
A working smart farm needs more than sensors. The owner needs to sell product, track inventory, monitor the environment, respond to VIP customers, and see trends before they become problems — all from a phone, in Thai, without hiring a dashboard engineer.
Off-the-shelf farm software doesn't connect to LINE (the daily-driver messaging app in Thailand). Off-the-shelf e-commerce doesn't understand hydroponics. Off-the-shelf analytics doesn't generate business-grade weekly reports in natural language.
VerdeX Farm solves all of it from one codebase: a LINE OA bot that is simultaneously a sales channel for customers and a command console for the owner, a web-based command center for deeper work, and a Claude Opus-backed weekly pulse report that reads the sensor logs, the revenue, and the harvest weight — then explains the week in two paragraphs. The software is fully functional through 12 refinement rounds; the hardware sensor rig is pending final assembly.
ARCHITECTURE
Cloudflare Workers deliver the web surface at the edge. Supabase stores orders, stock, sensor logs, harvest records, and customer profiles with RLS. The LINE OA webhook lives in the same Workers runtime — Rich Menu + Flex Messages render the UI, while commands dispatch to typed handlers. Claude Opus runs once a week (Sunday 07:00 ICT) against the last 7 days of sensor + business data, generating a natural-language Weekly Pulse Report that posts to the owner's LINE thread. An automated Morning Report runs daily at 07:00 with live sensor snapshot + open orders.
METRICS
12
Iterations
Round 12 — continuous refinement with real farm feedback
Automated sensor + orders snapshot to owner's LINE
Targets reflect engineering standards. Actual values tracked in Sentry + Finops dashboard.
ADMIN WALKTHROUGH
The owner's primary surface is LINE OA — the same app they already check every few minutes. Rich Menu lets them jump between modes (sales / stock / sensors / reports); Flex Messages render order cards, stock states, and the Weekly Pulse. The web-based Command Center handles deeper work: customer CRM detail, batch harvest logging, historical sensor analysis. Both are gated per customer type (owner vs. regular customer) via LINE user-ID mapping.
Public landing at verdex-web.verdexfarm.workers.dev — brand-first narrative for the smart farm concept.Blog surface for project updates + AI agriculture content.Owner-facing Command Center — real-time farm status, orders, CRM, operations. The brain alongside the LINE bot.Automated 07:00 ICT Morning Report — live sensor snapshot + open orders, posted to owner's LINE thread.Weekly Pulse Report — Claude Opus analyzes 7 days of sensor + business data. Example: Sensor Stability 44/100, water 22.9°C (33% in range), air 27.3°C (67% in range), humidity 60.4%, revenue 360 THB, 3 orders, 5.5 kg harvested.
SECURITY
→LINE user-ID tenancy
Owner vs customer surfaces dispatched from the same webhook by user-ID lookup — no shared admin surface exposed to regular customers.
→Row-Level Security
Supabase RLS on orders, stock, sensor_logs, harvests, and customers — service-role only for webhook writes.
→LINE signature verification
Every webhook request HMAC-verified against the channel secret before dispatch.
→Edge-scoped secrets
Channel access token, Supabase service-role key, and Anthropic key live in Cloudflare Workers secrets — never bundled in client code.
OBSERVABILITY
Workers logs stream every webhook event with the owner / customer tag and the dispatched command. Supabase's built-in query logs catch slow queries. The Weekly Pulse itself is an observability signal — if sensor stability drops week-over-week, Claude's AI Insight flags it before the owner notices in the raw numbers.
WORKFLOW
Twelve iteration rounds, each triggered by a real constraint from operating the farm: early rounds added ordering + stock; middle rounds added sensor logging and the owner CRM; later rounds layered in the Weekly Pulse AI report, VIP tracking, and automated morning reports. Each round shipped as a discrete release — the system's been working in production the entire time, with the owner as primary QA.
WORK WITH ME
Build me something like this
If you run a business that lives on LINE OA and needs a bespoke system — e-commerce, customer-ops, internal workflow, or AI-powered analytics — I can build it end-to-end, solo. Start with a free 15-minute consultation.
