In addition to what Katoog has said, a very important tag is:
<ref>Mat 1:1</ref>
This creates "tool tipped" scripture references. Unlike in the Windows version, these must not have an underscore in between the book and chapter:verse reference. So don't write Mat_1:1, or the reference won't work. However, it will appear underlined automatically in e-Sword for Mac/iOS/Android.
I have indeed created resources using an DB Browser for SQLite on the Mac. It takes more technical knowhow to do it, obviously, but it can be done. Katoog has given you some good advice to get you started.