Query and analyze local Copilot Money transaction and budget data using SQL and shell utilities.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install copilot-money-mac
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 copilot-money-mac 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 Copilot Money Finance Analyzer?
The Copilot Money skill enables deep programmatic access to your personal financial data stored locally on your Mac. Unlike standard exports, this skill leverages Openclaw Skills to interact with the app's internal SQLite database and Firestore LevelDB cache. This allows for real-time analysis of spending, budget tracking, and investment performance directly from the source data used by the Copilot app, ensuring your financial insights are always up to date with your local application state.
Copilot Money Finance Analyzer Use Cases
- Summarizing monthly spending by category to identify saving opportunities.
- Tracking historical account balances and net worth trends across different institutions.
- Auditing recurring transactions and identifying specific merchant patterns to manage subscriptions.
- Extracting investment metadata and security performance metrics managed by Openclaw Skills.
How Copilot Money Finance Analyzer Works
- Locates the primary SQLite database in the macOS Group Containers directory to access core transaction ledgers.
- Queries the Transactions table for dates, amounts, and merchant details using standard SQL syntax.
- Accesses the local Firestore LevelDB cache to map opaque category IDs and recurring IDs to human-readable names.
- Aggregates data across both storage engines to provide a comprehensive financial report to the user.
Copilot Money Finance Analyzer Setup
Accessing your financial data requires the Copilot Money Mac app to be installed. You can verify the database path and test connectivity using the following command:
sqlite3 -header -column ~/Library/Group\ Containers/group.com.copilot.production/database/CopilotDB.sqlite "SELECT date, name, amount FROM Transactions LIMIT 5;"
Ensure your terminal or AI agent environment has the necessary permissions to read from the Library folders within your macOS user directory to enable Openclaw Skills functionality.
Copilot Money Finance Analyzer Data Schema & Taxonomy
The skill interacts with two primary data structures to provide a complete financial picture:
| Data Source | Description |
|---|---|
Transactions (SQLite) |
Core ledger containing dates, amounts, merchant names, and category references. |
accountDailyBalance (SQLite) |
Historical snapshots of account liquidity and available balances. |
Firestore Collections (LevelDB) |
Metadata for budgets, investments, and recurring transaction definitions. |
Note that transaction amounts are stored as positive values for expenses and negative values for income.
Copilot Money Finance Analyzer Advanced Features
- Cross-referencing SQLite transaction IDs with Firestore recurring definitions for automated subscription auditing.
- Scripted extraction of investment prices and time-weighted returns (TWR) from LevelDB blobs.
- Support for analyzing Amazon order matching data stored in the local cache via Openclaw Skills.
- Custom SQL reporting for monthly budget variance analysis and category-specific trend mapping.
SKILL.md
Loading
Related Openclaw Skills
People Memories Skill
A lightweight personal CRM and context-retention skill for AI agents to store and recall specific details about individuals.
Voice Assistant
A high-performance, real-time voice interface for Openclaw agents featuring sub-2 second latency and multi-provider STT/TTS support.
YouTube Summary
A specialized tool for extracting and summarizing YouTube transcripts to save time on video content consumption.
Typefully Social Media Manager
A powerful automation bridge for Typefully to manage social media drafts and multi-platform scheduling directly via the CLI.
Watcha AI Product Finder
An AI-driven discovery tool that leverages the watcha.cn API to find, evaluate, and recommend AI products based on community sentiment and technical specifications.
Unicon
A unified CLI and AI-powered icon library providing access to over 19,000 icons with framework-aware generation and tree-shaking.
Featured*
