Project: Getting Claude to See My Bank Transactions
I built a simple personal finance pipeline that automatically syncs my N26 transactions to NeonDB PostgreSQL, then lets me chat about my spending patterns directly in Claude.
The Flow
Every day at 5 PM, a launchd service runs a script that:
- Fetches last 5 days of transactions from GoCardless API
- Inserts new transactions into NeonDB PostgreSQL (with deduplication)
Neon's MCP Integration
Thanks to Neon's MCP integration, I can easily connect my database to Claude. I ask it things like "How much did I spend on groceries last week?" and it queries my actual transaction data.
Why This Works
GoCardless API: European Open Banking regulations mean banks must provide API access to your own data. GoCardless standardizes this across institutions.
Scheduled Service: Using macOS launchd instead of cron means it runs even if my laptop was sleeping.
NeonDB: PostgreSQL with built-in MCP support. My transactions are queryable from Claude conversations without any additional setup.
Result
I now have conversational access to my financial data. "Show me all transactions over €100 this month" or "What's my average daily spending?" work instantly in Claude, querying live data from my database.