It could be nice to include `bin/sqlite3_analyzer` (available from the sqlite download page) in the port, or in a different port (I think it depends on TCL).
In the distribution that is used for this port, there are no corresponding files. But, do not despair. You can use the new port.
or their source
Created attachment 215100 [details]
Created attachment 215101 [details]
Created attachment 215102 [details]
You can try to use linux binaries built via meta-port.
There's no need to use linux binaries for this.
sqlite3 provides complete source tarball, sqlite-src-3340100.zip (as opposed to currently used sqlite-autoconf-3340100.tar.gz), which contain analyzer and a bunch of other stuff (such as tests). sqlite3 should probably be switched to it.
Created attachment 222490 [details]
A proposed patch to switch sqlite3 from sqlite-autoconf distfile to sqlite-src. Because of that, tcl is now required at buildtime, manpage needs to be installed manually, patch is no longer needed. Additionally, add TCL option which installs sqlite_analyzer and tcl extensions along the way. Also, switch to pkg-plist, PLIST_FILES this long is discouraged.