您可以使用https://npmjs.com/package/@capacitor-community/sqlite作为数据库。
大概是这样的

import { CapacitorSQLite, SQLiteConnection } from '@capacitor-community/sqlite';
import { FilePicker } from '@robingenz/capacitor-file-picker';

async function main() {
  const result = await FilePicker.pickFiles();
  const file = result.files[0];

  const sqlite = new SQLiteConnection(CapacitorSQLite);
  const db = await sqlite.createNCConnection(file.path, 1);
  await db.open();

  // You can now read/write to the database using the db object
}