MySQL integration
Transactions, balances, holdings and trades from 12k+ banks, written into a table in your own MySQL database on a schedule. Appended or upserted, ready to query.
mysql> SELECT date, description, amount, category, account_name -> 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 in set (0.01 sec)
From bank to MySQL in three steps.
- 01
Connect MySQL
Host, database and a least-privilege user, or paste a connection string. Test it before you save.
Hostdb.acme.internalPort3306Userbanksync_writerSSL moderequireTest● Connection successful - 02
Pick a table
Choose a database and table, or let BankSync create one. Append, or upsert on a key.
DatabaseanalyticsTabletransactionsAppendUpsertMatch 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
MySQL, set up start to finish.
Setting up MySQL 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.
MySQL, in short.
- Data
- Transactions, balances, trades, holdings and loans, one data type per feed.
- Works with
- MariaDB, PlanetScale, Amazon Aurora, RDS and self-hosted MySQL.
- 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 (PlanetScale, Aurora, RDS) and self-hosted databases.
- Status
- Available today.
Questions, answered.
Which MySQL hosts does BankSync work with?
Any reachable MySQL database, including MariaDB, PlanetScale, Amazon Aurora, RDS and self-hosted MySQL.
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 MySQL database.
BankSync is not affiliated with, endorsed by, or an official partner of MySQL. MySQL trademarks belong to their respective owners.
