If you're stuck on a bridge-based SQLite plugin in Capacitor and hitting performance walls with large result sets or sync-heavy writes, this walks you through swapping to Fast SQL's local HTTP transport. It audits your current SQL dependencies, maps APIs like transactions and batch writes, handles the native platform config for localhost traffic, and cleans up the old plugin. The coverage is solid: it distinguishes raw queries from key-value wrappers, preserves your existing schema migrations, and pushes you toward executeBatch and transaction callbacks instead of naive query loops. One caution: if you're not actually bottlenecked on bridge serialization or don't need encryption and BLOB support, the migration overhead might not pay off.
npx skills add https://github.com/cap-go/capgo-skills --skill sqlite-to-fast-sql