Mine macports sqlite database for package of origin for each program in /opt/local/bin.

macports-bin.sh

#!/usr/bin/env bash
#

DB="/opt/local/var/macports/registry/registry.db"
QUERY="select ports.name,files.path
          from files
          inner join ports
          on files.id=ports.id AND files.path GLOB '/opt/local/bin/*'"

sqlite3 -list -separator ' ' "$DB" "$QUERY" \
  | while read -r port path; do echo "$port: $(basename "$path")"; done \
  | sort