It went under my radar for a long time. I had to reinstall fish today and I saw pkgfile listed as an optional dependency.

It turns out that fish can automatically suggest you which package you need to install when you try to run a command that's not available.

To cut it short:

$ sudo pacman -S pkgfile

# To sync pkgfile db
$ sudo pkgfile --update

# To sync pkgfile db every day automatically
$ systemctl enable pkgfile-update.timer

# now try to run some command you don't have installed
$ lolcat
lolcat may be found in the following packages:
  community/lolcat 100.0.0-2    /usr/bin/lolcat

Source