PostgreSQL integration
Transactions, balances, holdings and trades from 12k+ banks, written into a table in your own PostgreSQL database on a schedule. Appended or upserted, ready to query.
analytics=> SELECT date, description, amount, category, account_nameanalytics-> FROM transactions ORDER BY date DESC LIMIT 6; date | description | amount | category | account_name ------------+--------------------+----------+------------+---------------- 2026-10-19 | Stripe payout | 4200.00 | Income | Chase Checking 2026-10-19 | Whole Foods Market | -86.42 | Groceries | Amex Gold 2026-10-18 | Gusto payroll | -6850.00 | Payroll | Chase Checking 2026-10-18 | Figma | -45.00 | Software | Amex Gold 2026-10-17 | Shell | -52.30 | Transport | Amex Gold 2026-10-17 | Blue Bottle Coffee | -6.75 | Eating out | Amex Gold (6 rows)
From bank to PostgreSQL in three steps.
- 01
Connect PostgreSQL
Host, database and a least-privilege user, or paste a connection string. Test it before you save.
Hostdb.acme.internalPort5432Userbanksync_writerSSL moderequireTest● Connection successful - 02
Pick a table
Choose a schema and table, or let BankSync create one. Append, or upsert on a key.
SchemapublicTabletransactionsAppendUpsertMatch rows ontransaction_id - 03
Pick a schedule
Hourly, daily or weekly, or on demand. Every run is on the record.
HourlyDailyWeeklyNext runTomorrow, 6:00amLast run● 3 new rows, 6:02am
PostgreSQL, set up start to finish.
Setting up PostgreSQL in BankSync, filmed with sample accounts.
What lands in your table.
- transaction_id
- The bank’s stable id for the transaction. Your upsert key. 4bdd8e6931727cd
- date
- The day the bank posted it. 2026-10-19
- description
- The description the bank gives it. Whole Foods Market
- amount
- Signed, in the account’s currency: money out is negative. -86.42
- currency
- ISO 4217 code. USD
- category
- A spending category to group and filter by. Groceries
- account_name
- The account it came from, so many banks share one table. Amex Gold
- pending
- True until the bank posts it. false
The same data can also go to spreadsheets, workspaces, AI assistants and your own code.
PostgreSQL, in short.
- Data
- Transactions, balances, trades, holdings and loans, one data type per feed.
- Works with
- Supabase, Neon, Timescale, CockroachDB, Amazon RDS and self-hosted Postgres.
- Write modes
- Append inserts a row each sync. Upsert matches on the key columns you choose and updates in place.
- Security
- SSL mode disable, require or verify-full, a least-privilege user, and a small fixed set of BankSync IPs you can allowlist.
- Schedule
- Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
- Access
- Read-only, authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
- Setup
- About 10 minutes. Works with managed (Supabase, Neon, Aurora, RDS) and self-hosted databases.
- Status
- Available today.
Questions, answered.
Which PostgreSQL hosts does BankSync work with?
Any reachable PostgreSQL database, including Supabase, Neon, Timescale, CockroachDB, Amazon RDS and self-hosted Postgres.
Should I use append or upsert?
Upsert, for most feeds. Append inserts a new row every sync, so re-syncs can duplicate. Upsert matches rows on the key columns you choose, such as transaction_id, and updates them in place.
Can BankSync create the table for me?
Yes. "Set this up for me" creates a table for the feed’s data type, maps every column, and adds the unique index upserts need.
How do I lock down access to my database?
Give BankSync a user that can only insert (and create, if BankSync should make the table), use SSL mode require or verify-full, and allowlist the fixed IP addresses BankSync connects from.
Can BankSync move money or see my bank password?
No. Bank access is read-only and authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
Bank data in your PostgreSQL database.
BankSync is not affiliated with, endorsed by, or an official partner of PostgreSQL. PostgreSQL trademarks belong to their respective owners.
