A little program to save your YNAB transactions to a SQLite Database for fast and easy querying

ynab_to_db.js

const ynab = require("ynab");
const SQL = require("sql-template-strings");
const sqlite = require("sqlite");

let personalAccessToken = process.env.YNAB_ACCESS_TOKEN;
let client = new ynab.API(personalAccessToken);

async function go() {
  const db = await sqlite.open("./transactions.sqlite");

  async function bootstrap() {
    await db.run(SQL`
    create table if not exists data (
      id text not null,
      date date not null,
      amount real not null,
      memo text,
      account text,
      payee text,
      category text
    );
  `);
  }

  async function insertData(t) {
    await db.run(SQL`
    insert into data (id, date, amount, memo, account, payee, category) values (
      ${t.id},
      ${t.date},
      ${t.amount},
      ${t.memo},
      ${t.account_name},
      ${t.payee_name},
      ${t.category_name}
    )
  `);
  }

  await bootstrap();
  let {
    data: { transactions }
  } = await client.transactions.getTransactions(
    // You can get this budget ID with the API as well
    "your-budget-id-here"
  );
  await Promise.all(transactions.map(insertData));
}

go();