Hermes Agent + Supabase: Ask Your Receipts Anything (Voice to Insights) | No code tutorial
I built a AI bookkeeper with Supabase and an open-source agent that reads every receipt and answers any money question in plain English. In this tutorial I show you exactly how I turned three years of crumpled, multi-currency, faded receipts into a database I own — and an AI bookkeeper I can literally talk to. The whole system runs on Supabase's free tier ($0, no credit card) and an open-source self-improving agent called Hermes from Nous Research, all controlled from Telegram. The receipt pile is every business owner's black hole. Instead of a spreadsheet, I hand the whole mess to an AI agent that reads each receipt with a vision model, extracts the vendor, date, amount, tax, and category, and files it as a clean row in Supabase. A thousand receipts, a thousand rows, none skipped. The part most people skip — and the reason this actually worked — is the official Supabase agent skill. It's a free, open-source instruction manual that stops AI agents from quietly wrecking your database: enforcing Row Level Security, granting data API access correctly, writing modern policies, and verifying every change. I break down the six things it forced Hermes to do that a bare agent would have skipped. Then the payoff: I ask my receipts questions in plain English. How much did I spend on AWS last year? Which vendor grew the most? How much of this is recurring charges on a single card? Hermes writes SQL on the fly through an MCP connection and queries my own database live. That's the difference between a finance app and a finance brain. I'll also show you the auto-import workflows, scheduled nightly digests, and a Q4 forecast that works like a CFO in your phone. Resources: - Try Supabase: https://supabase.plug.dev/LLcnYRW - Supabase Agent Skill (free, open-source): https://github.com/supabase/agent-skills - Hermes Deep Dive Course (Udemy) + discount code: https://www.udemy.com/course/hermes-agent-masterclass-build-autonomous-ai-workflows/?couponCode=HERMES_AGENT - Hermes (Nous Research): https://github.com/nousresearch/hermes-agent TIMESTAMPS: 0:00 - The Question That Scared Me (One Card, $1,900 a Year) 0:39 - Building an AI Bookkeeper You Can Talk To 0:49 - The Receipt Black Hole Problem 1:31 - The Plan: Hand the Pile to an AI Agent 2:00 - The Three Pieces: Receipts, Hermes & Supabase 2:36 - Meet Hermes: The Open-Source Self-Improving Agent 3:16 - The Free Supabase Agent Skill (The Part Most People Skip) 4:01 - Designing the Receipts Table from the First Receipt 4:47 - Row Level Security & Why a Bare Agent Gets It Wrong 6:46 - Reading the First Receipt with a Vision Model 8:13 - Running It Across 1,000 Receipts 8:49 - Building a Dashboard in Plain English 10:37 - Talking to Your Finances: Natural Language Queries 12:48 - How It Works: SQL on the Fly via MCP 13:34 - Getting Receipts In: Photo, Batch & Scheduled Import 14:25 - Bonus: Forecasting Q4 Like a CFO 14:54 - The Pattern Beyond Receipts 15:55 - The Cost: Running It All on Supabase's Free Tier 16:35 - Recap & Next Steps 📧 FREE Weekly AI Automation Newsletter: Get weekly tutorials, free workflow templates, and the latest AI news straight to your inbox 👉 https://aifornoncoders.com/newsletter 🤝 Join the AI Automation Engineering Community: Go deeper — interact with me and the community, get feedback on your builds, and stay ahead of the curve 👉 https://www.skool.com/ai-automation-engineering-3014