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 · analytics3 rows upserted, 6:02am
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)
Chase Checking and Amex Gold, upserted at 6:02am into the transactions table. A re-sync updates rows in place instead of adding them again.

From bank to MySQL in three steps.

  1. 01

    Connect MySQL

    Host, database and a least-privilege user, or paste a connection string. Test it before you save.

    Hostdb.acme.internal
    Port3306
    Userbanksync_writer
    SSL moderequire
    Test● Connection successful
  2. 02

    Pick a table

    Choose a database and table, or let BankSync create one. Append, or upsert on a key.

    Databaseanalytics
    Tabletransactions
    AppendUpsert
    Match rows ontransaction_id
  3. 03

    Pick a schedule

    Hourly, daily or weekly, or on demand. Every run is on the record.

    HourlyDailyWeekly
    Next runTomorrow, 6:00am
    Last 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
Map bank fields onto the columns you already have, or let BankSync create the table and its unique index for you.

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.