pkgfile is a tool that tells you which package owns a specific file.
After installing the package, you should update the filelist:
# pkgfile --update
$ pkgfile makepkg # Search for a package that contains a file named 'makepkg'. core/pacman # Your searched file is in 'pacman' package in [core] repository.