OpenBSD have a package called sqlports and sqlports-compact which contain sqlite database about ports.
add to your system using
pkg_add sqlports-compact
see pkg_info on sqlports-compact below
Location of the database and sample query
We can use a GUI sqlite manager program called sqliteman, its easier.
Add it to your system
pkg_add sqliteman
see below the look and fee of sqliteman
bye for now …