A local CLI-based personal bookkeeping tool that leverages SQLite to track income, expenses, transfers, and budgets via AI agent commands.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install lyuuo-book
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install lyuuo-book using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is lyuuo-book: Personal CLI Bookkeeping Agent?
lyuuo-book is a robust personal finance management skill designed for integration with AI coding agents. It provides a local, private way to record financial transactions, manage multiple accounts, and categorize spending without leaving your development environment. By utilizing Openclaw Skills, this tool transforms natural language financial intent into structured SQLite data.
The skill operates entirely through a local CLI, ensuring that sensitive financial data stays on your machine. Whether you are tracking daily coffee expenses or generating annual financial summaries, lyuuo-book offers a developer-friendly interface for comprehensive money management.
lyuuo-book: Personal CLI Bookkeeping Agent Use Cases
- Recording daily expenses or income using natural language triggers like 'I spent 50 on lunch'.
- Managing transfers between different financial accounts such as bank accounts and digital wallets.
- Monitoring monthly spending habits and category-wise distributions to improve financial health.
- Setting and tracking monthly budgets with automated alerts for overspending.
- Generating detailed financial reports and balance sheets for personal auditing.
How lyuuo-book: Personal CLI Bookkeeping Agent Works
- The AI agent detects financial intent from user input, such as logging a payment or checking a balance.
- The system performs an environment check to ensure Node.js and the better-sqlite3 dependency are available.
- The agent retrieves necessary IDs for accounts and categories to ensure data integrity.
- Commands are executed via the book.mjs script using JSON parameters to interact with the local SQLite database.
- The skill returns a JSON response which the agent then translates into a user-friendly report or confirmation message.
lyuuo-book: Personal CLI Bookkeeping Agent Setup
First, ensure your environment has the necessary SQLite driver installed:
npm install -g better-sqlite3
You can then verify the installation using:
node -e "require('better-sqlite3')" 2>&1 && echo "ready"
Once ready, all interactions are handled through the Openclaw Skills framework via the scripts/book.mjs script located in the skill directory.
lyuuo-book: Personal CLI Bookkeeping Agent Data Schema & Taxonomy
The skill uses a structured SQLite database to manage financial entities. Key data structures include:
| Entity | Key Fields | Description |
|---|---|---|
| Transaction | type, amount, accountId, categoryId, remark | Stores income, expense, and transfer records. |
| Account | name, type, initialBalance | Manages different money sources (e.g., Bank, Cash, Alipay). |
| Category | name, direction, parentId | Organizes transactions into expense or income groups. |
| Budget | categoryId, amount, periodType | Defines spending limits for specific categories and timeframes. |
lyuuo-book: Personal CLI Bookkeeping Agent Advanced Features
- Automated balance recalculation: Modifying or deleting transactions automatically updates all affected account balances.
- Multi-format data portability: Supports exporting and importing financial records via CSV for external analysis.
- Contextual ID caching: The agent intelligently caches account and category IDs during a session for faster command execution.
- Detailed trend analysis: Generate 12-month trend reports to visualize income and expense changes over time.
- Intelligent budget monitoring: Real-time status checks that alert users when they approach or exceed predefined spending limits.
SKILL.md
Loading
Related Openclaw Skills
TV Launcher Prototype Generator
A specialized tool for generating pure frontend Smart TV Launcher prototypes optimized for remote control interaction and big-screen experiences.
Nano Banana Prompt Generator Skill
A sophisticated prompt engineering engine that transforms user descriptions into structured JSON parameters for Google's Gemini 3.1 Flash Image model.
PPT Visual Designer - Block Style
A strategic visual design skill that transforms complex business logic and organizational structures into logically aesthetic, modular Block style presentation layouts.
Market Overview Skill
A comprehensive crypto market dashboard skill that aggregates global market data, DeFi metrics, and macro indicators into a single briefing.
Seedance Creator
A professional AI creative assistant designed for ByteDance's Seedance 2.0 platform to generate high-quality images and cinematic videos via CLI automation.
Context-Aware Daily Assistant (GroundAPI)
A versatile AI agent skill providing real-time life services including weather, logistics, finance, and localized information through the GroundAPI MCP server.
Featured*
