HeadlinesBriefing favicon HeadlinesBriefing.com

micasa: Terminal Home Management with SQLite

Hacker News •
×

A developer has created micasa, a terminal-based home management system built entirely with AI assistance. The tool tracks maintenance schedules, projects, incidents, appliances, vendors, quotes, and documents using a single SQLite file, eliminating the need for cloud services or subscriptions.

The project emerged from frustration with scattered notes and forgotten tasks. Built on Charmbracelet's TUI framework with GORM and go-sqlite, micasa features a Vim-style modal interface inspired by VisiData. Users can navigate with keyboard commands, sort multi-column data, perform fuzzy searches, and drill into related records. All features work offline, with optional local LLM chat for those who want it.

What makes this notable is that 99% of the code was written by an AI agent, with the developer reviewing and merging changes. The entire application state lives in one SQLite database file, including document attachments stored as BLOBs. While the creator acknowledges this won't scale indefinitely, they argue it's remarkably simple to work with. The project represents an interesting case study in AI-assisted development for practical personal tools, demonstrating how modern AI can accelerate building useful applications without sacrificing control over the final product.