micasa

Your house is quietly plotting to break while you sleep -- and you're dreaming about redoing the kitchen. micasa tracks both from your terminal.

Single SQLite file. No cloud. No account. No subscriptions.

Features

• When did I last change the furnace filter? Maintenance schedules, auto-computed due dates, full service history.
• What if we finally did the backyard? Projects from napkin sketch to completion -- or graceful abandonment.
• How much would it actually cost to... Quotes side by side, vendor history, and the math you need to actually decide.
• Is the dishwasher still under warranty? Appliance tracking with purchase dates, warranty status, and maintenance history tied to each one.
• The basement is leaking again. Log incidents with severity and location, link them to appliances and vendors, and resolve them when fixed.
• Who did we use last time? A vendor directory with contact info, quote history, and every job they've done for you.
• Where's the warranty card? Attach files (manuals, invoices, photos) directly to projects and appliances. Stored as BLOBs in the same SQLite file -- one cp backs up everything.
• How much have I spent on plumbing? Press @ to chat with a local LLM about your data. It writes the SQL, runs the query, and summarizes the results -- all on your machine.

Keyboard driven

Vim-style modal keys: nav mode to browse, edit mode to change things. Sort by any column, jump to columns with fuzzy search, hide what you don't need, and drill into related records.

See the full keybinding reference.

Local LLM chat

Ask questions about your home data in plain English. micasa connects to a local Ollama server (or any OpenAI-compatible API) and translates your question into SQL, executes it, and summarizes the results.

The model has access to your schema and actual database values, so it can handle fuzzy references like "plumbing stuff" or "planned projects." Toggle ctrl+s to see the generated SQL, or ctrl+o for mag mode that replaces dollar amounts with their order of magnitude.

See the LLM chat guide and configuration reference for setup.

Install

Requires Rust stable:

cargo install --path crates/micasa-cli

Or grab a binary from the latest release.

Linux, macOS, and Windows binaries are currently published for amd64.

micasa --demo         # poke around with sample data
micasa                # start fresh with your own house
micasa --print-path   # show where the database lives

One SQLite file. Your data, your machine. Back it up with cp.

Need Nix or container install options? Use the full installation guide.

Documentation

Full docs at micasa.dev/docs -- start with Installation and First Run, then use the Guide and Reference.

Development

Rust with a synchronous terminal stack: ratatui + rusqlite + SQLite. TUI design remains inspired by VisiData -- modal navigation, column-level operations, and keyboard-driven data exploration. Developed with AI coding agents (Claude, Claude Code).

PRs welcome -- including AI-assisted ones, as long as you've reviewed and curated the code. See the contributing guide for details. The repo uses a Nix dev shell with reproducible checks:

nix develop          # enter dev shell
cargo test --workspace           # run tests

License

Apache-2.0 -- see LICENSE.