This short tutorial by the folks at osquery will show you how to get its port set up for FreeBSD.

osquery

osquery is an operating system instrumentation framework for OS X and Linux. The tools make low-level operating system analytics and monitoring both performant and intuitive.

osquery exposes an operating system as a high-performance relational database. This allows you to write SQL-based queries to explore operating system data. With osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes.

The easiest way to install osquery on FreeBSD is via the ports tree. Check FreshPorts for the latest version information.

# from ports
cd /usr/ports/sysutils/osquery && make install clean

# from binary package
pkg install osquery

# using portmaster
portmaster sysutils/osquery

Original: https://osquery.readthedocs.org/en/latest/installation/install-freebsd/