Menú
Answer questions about personal finances — balances, transactions, spending patterns, account status, recent purchases, merchant history, income tracking. Use when the user asks anything about their money, accounts, or transactions.
Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.
Basado en la clasificación ocupacional SOC
Financial advisor intake — run when a user first sets up this project, says "onboard", "set up my profile", "get started", "intake", "configure my finances", or when CLAUDE.md has no Client Context section. Conducts a structured interview modeled on the CFP Board's 7-step process and writes personalized context to memory files (never to CLAUDE.md). USE THIS SKILL for any first-time setup or when the user wants to update their financial profile.
Quarterly financial health assessment. Use when the user asks for a full financial review, health check, "how am I doing", quarterly review, ratio check, financial assessment, or wants to know if they're on track. Also use when more than 30 days have passed since the last health check. Compares current state against goals, checks all key ratios, identifies which layer of the financial pyramid needs attention, and produces a prioritized action plan. Spawns research agents for tactical implementation details.
Answer "what should I do with my next dollar?" Apply the financial order of operations to the user's ACTUAL situation. Use when someone asks what to do with money, how to allocate a paycheck, where to put savings, whether to pay debt or invest, what to do with a bonus/raise/windfall/tax refund, or any variant of "I have $X — what's the best use?" Also use for "should I pay off X or save?" questions. THIS IS THE MOST COMMON FINANCIAL QUESTION — trigger aggressively.
Optimize HOW you execute financial strategies with your specific accounts, cards, and tools. Use when the user asks "how should I use my cards?", "optimize my rewards", "balance transfer options", "which account for X?", "am I leaving money on the table?", "what am I not taking advantage of?", or any variant of tactical account optimization. Also trigger after /next-dollar gives a strategic recommendation — this skill provides the implementation playbook. USE THIS SKILL when someone wants to squeeze maximum value from existing financial instruments. This skill spawns research agents for deep analysis.
Audit spending for waste, unused subscriptions, and overspending by category. Use when the user asks to find waste, cut spending, review subscriptions, check for recurring charges they forgot about, or do a financial audit.
Generate a weekly personal finance report. Use when the user asks for a weekly report, spending summary, finance review, or budget status.
| name | finance-query |
| description | Answer questions about personal finances — balances, transactions, spending patterns, account status, recent purchases, merchant history, income tracking. Use when the user asks anything about their money, accounts, or transactions. |
| allowed-tools | Bash, Read |
Answer the user's financial question using the unified SQLite ledger.
Primary: data/finance.db (SQLite — unified ledger of all transactions from Plaid + CSVs)
Query with: sqlite3 data/finance.db "SELECT ..."
Fallback (if DB missing): data/latest/*.json
transactions (
id TEXT PRIMARY KEY,
date TEXT, -- ISO format YYYY-MM-DD
description TEXT,
amount REAL, -- POSITIVE = debit (money spent), NEGATIVE = credit (income/refund)
merchant TEXT,
category TEXT, -- Plaid category (may be empty for CSV-sourced)
account_name TEXT,
account_mask TEXT, -- last 4 digits
account_type TEXT, -- depository, credit, loan, investment
institution TEXT,
source TEXT, -- 'plaid' or 'csv'
source_file TEXT
);
accounts (
account_id TEXT PRIMARY KEY,
name TEXT,
type TEXT,
subtype TEXT,
mask TEXT,
institution_id TEXT,
balance_current REAL,
balance_available REAL,
balance_limit REAL,
last_updated TEXT
);
data/finance.db exists. If not, suggest running python3 scripts/ingest.py first.# Date range spending
sqlite3 data/finance.db "SELECT description, amount, date FROM transactions WHERE date >= '2026-06-01' AND amount > 0 ORDER BY amount DESC LIMIT 20"
# Spending by merchant
sqlite3 data/finance.db "SELECT description, SUM(amount), COUNT(*) FROM transactions WHERE amount > 0 GROUP BY description ORDER BY SUM(amount) DESC LIMIT 20"
# Monthly totals
sqlite3 data/finance.db "SELECT substr(date,1,7) as month, SUM(CASE WHEN amount > 0 THEN amount ELSE 0 END) as spent, SUM(CASE WHEN amount < 0 THEN ABS(amount) ELSE 0 END) as income FROM transactions GROUP BY month ORDER BY month"
# Search by merchant
sqlite3 data/finance.db "SELECT date, description, amount FROM transactions WHERE LOWER(description) LIKE '%quills%' ORDER BY date DESC"
# Account balances
sqlite3 data/finance.db "SELECT name, mask, type, balance_current, balance_limit FROM accounts ORDER BY balance_current DESC"
# Income sources
sqlite3 data/finance.db "SELECT date, description, ABS(amount) FROM transactions WHERE amount < 0 AND ABS(amount) > 100 ORDER BY date DESC LIMIT 20"
-header -column for readable output: sqlite3 -header -column data/finance.db "..."