# Send Copilot Money Mac to your agent Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually. ## Fast path - Download the package from Yavira. - Extract it into a folder your agent can access. - Paste one of the prompts below and point your agent at the extracted folder. ## Suggested prompts ### New install ```text I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete. ``` ### Upgrade existing ```text I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run. ``` ## Machine-readable fields ```json { "schemaVersion": "1.0", "item": { "slug": "copilot-money-mac", "name": "Copilot Money Mac", "source": "tencent", "type": "skill", "category": "数据分析", "sourceUrl": "https://clawhub.ai/chardigio/copilot-money-mac", "canonicalUrl": "https://clawhub.ai/chardigio/copilot-money-mac", "targetPlatform": "OpenClaw" }, "install": { "downloadUrl": "/downloads/copilot-money-mac", "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=copilot-money-mac", "sourcePlatform": "tencent", "targetPlatform": "OpenClaw", "packageFormat": "ZIP package", "primaryDoc": "SKILL.md", "includedAssets": [ "README.md", "SKILL.md" ], "downloadMode": "redirect", "sourceHealth": { "source": "tencent", "status": "healthy", "reason": "direct_download_ok", "recommendedAction": "download", "checkedAt": "2026-04-23T16:43:11.935Z", "expiresAt": "2026-04-30T16:43:11.935Z", "httpStatus": 200, "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=4claw-imageboard", "contentType": "application/zip", "probeMethod": "head", "details": { "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=4claw-imageboard", "contentDisposition": "attachment; filename=\"4claw-imageboard-1.0.1.zip\"", "redirectLocation": null, "bodySnippet": null }, "scope": "source", "summary": "Source download looks usable.", "detail": "Yavira can redirect you to the upstream package for this source.", "primaryActionLabel": "Download for OpenClaw", "primaryActionHref": "/downloads/copilot-money-mac" }, "validation": { "installChecklist": [ "Use the Yavira download entry.", "Review SKILL.md after the package is downloaded.", "Confirm the extracted package contains the expected setup assets." ], "postInstallChecks": [ "Confirm the extracted package includes the expected docs or setup files.", "Validate the skill or prompts are available in your target agent workspace.", "Capture any manual follow-up steps the agent could not complete." ] } }, "links": { "detailUrl": "https://openagent3.xyz/skills/copilot-money-mac", "downloadUrl": "https://openagent3.xyz/downloads/copilot-money-mac", "agentUrl": "https://openagent3.xyz/skills/copilot-money-mac/agent", "manifestUrl": "https://openagent3.xyz/skills/copilot-money-mac/agent.json", "briefUrl": "https://openagent3.xyz/skills/copilot-money-mac/agent.md" } } ``` ## Documentation ### Copilot Money Query local data from the Copilot Money Mac app to analyze transactions, spending patterns, account balances, investments, and budgets. Data is stored in both SQLite (transactions, balances) and Firestore LevelDB cache (recurring names, budgets, investments). ### Database Location ~/Library/Group Containers/group.com.copilot.production/database/CopilotDB.sqlite ### Transactions Table Primary table for all financial transactions. ColumnTypeDescriptionidTEXTPrimary keydateDATETransaction datenameTEXTMerchant/transaction nameoriginal_nameTEXTRaw name from bankamountDOUBLETransaction amount (positive = expense)iso_currency_codeTEXTCurrency (e.g., "USD")account_idTEXTLinked account referencecategory_idTEXTCategory referencependingBOOLEANWhether transaction is pendingrecurringBOOLEANWhether transaction is recurringrecurring_idTEXTLinks to recurring definition (see Firestore)user_noteTEXTUser-added notesuser_deletedBOOLEANSoft-deleted by user ### accountDailyBalance Table Daily balance snapshots per account. ColumnTypeDescriptiondateTEXTSnapshot dateaccount_idTEXTAccount referencecurrent_balanceDOUBLEBalance on that dateavailable_balanceDOUBLEAvailable balance ### Firestore Cache (LevelDB) Additional data is stored in Firestore's local LevelDB cache, not in the SQLite database. Location: ~/Library/Containers/com.copilot.production/Data/Library/Application Support/firestore/__FIRAPP_DEFAULT/copilot-production-22904/main/*.ldb ### Collections CollectionDescriptionitemsLinked bank accounts/institutionsinvestment_pricesHistorical security pricesinvestment_performanceTWR (time-weighted return) per holdinginvestment_splitsStock split historysecuritiesStock/fund metadatausers/.../budgetsBudget definitions (amount, category_id)users/.../recurringsRecurring transaction definitionsamazonAmazon order matching data ### Recurring Definitions FieldDescriptionnameDisplay name (e.g., "Water / Sewer", "Rent")match_stringTransaction name to match (e.g., "CHECK PAID")plaid_category_idCategory ID for the recurringstate"active" or "inactive" ### Data Not in SQLite Recurring names - human-readable names like "Rent", "Netflix" Budget amounts - monthly budget per category Investment data - holdings, prices, performance, splits Account/institution names - Chase, Fidelity, etc. Category names - Restaurants, Travel, Groceries, etc. ### Extracting Data from LevelDB List all recurring names: for f in ~/Library/Containers/com.copilot.production/Data/Library/Application\\ Support/firestore/__FIRAPP_DEFAULT/copilot-production-22904/main/*.ldb; do strings "$f" 2>/dev/null | grep -B10 "^state$" | grep -A1 "^name$" | grep -v "^name$" | grep -v "^--$" done | sort -u | grep -v "^$" List all collections: for f in ~/Library/Containers/com.copilot.production/Data/Library/Application\\ Support/firestore/__FIRAPP_DEFAULT/copilot-production-22904/main/*.ldb; do strings "$f" 2>/dev/null done | grep -oE "documents/[a-z_]+/" | sort | uniq -c | sort -rn Find category names: for f in ~/Library/Containers/com.copilot.production/Data/Library/Application\\ Support/firestore/__FIRAPP_DEFAULT/copilot-production-22904/main/*.ldb; do strings "$f" 2>/dev/null done | grep -iE "^(groceries|restaurants|shopping|entertainment|travel|transportation|utilities)$" | sort -u ### Recent Transactions SELECT date, name, amount, category_id FROM Transactions WHERE user_deleted = 0 ORDER BY date DESC LIMIT 20; ### Monthly Spending Summary SELECT strftime('%Y-%m', date) as month, SUM(amount) as total FROM Transactions WHERE amount > 0 AND user_deleted = 0 GROUP BY month ORDER BY month DESC; ### Spending by Category SELECT category_id, SUM(amount) as total, COUNT(*) as count FROM Transactions WHERE amount > 0 AND user_deleted = 0 AND date >= date('now', '-30 days') GROUP BY category_id ORDER BY total DESC; ### Search Transactions SELECT date, name, amount FROM Transactions WHERE name LIKE '%SEARCH_TERM%' AND user_deleted = 0 ORDER BY date DESC; ### List Recurring Transactions SELECT DISTINCT name, recurring_id FROM Transactions WHERE recurring = 1 AND user_deleted = 0 ORDER BY name; ### Usage Use sqlite3 to query the database: sqlite3 ~/Library/Group\\ Containers/group.com.copilot.production/database/CopilotDB.sqlite "YOUR_QUERY" For formatted output: sqlite3 -header -column ~/Library/Group\\ Containers/group.com.copilot.production/database/CopilotDB.sqlite "YOUR_QUERY" ### Notes Category IDs are opaque strings - group by them for analysis (names are in Firestore cache) Amounts are positive for expenses, negative for income Filter user_deleted = 0 to exclude deleted transactions Both databases are actively used by the app; read-only access is safe SQLite has recurring_id linking to Firestore recurring definitions Use strings on LevelDB files to extract human-readable data from Firestore cache ## Trust - Source: tencent - Verification: Indexed source record - Publisher: chardigio - Version: 1.0.0 ## Source health - Status: healthy - Source download looks usable. - Yavira can redirect you to the upstream package for this source. - Health scope: source - Reason: direct_download_ok - Checked at: 2026-04-23T16:43:11.935Z - Expires at: 2026-04-30T16:43:11.935Z - Recommended action: Download for OpenClaw ## Links - [Detail page](https://openagent3.xyz/skills/copilot-money-mac) - [Send to Agent page](https://openagent3.xyz/skills/copilot-money-mac/agent) - [JSON manifest](https://openagent3.xyz/skills/copilot-money-mac/agent.json) - [Markdown brief](https://openagent3.xyz/skills/copilot-money-mac/agent.md) - [Download page](https://openagent3.xyz/downloads/copilot-money-mac)