pacman-pkgbyrepo archlinux show your installed packages and their origin repos

pacman-pkgbyrepo.py

#!/usr/bin/python3

import configparser

import pyalpm

def get_repo_list():
  c = configparser.ConfigParser(strict=False, allow_no_value=True)
  c.read('/etc/pacman.conf')

  return [
    section
    for section in c.sections()
    if c.get(section, 'Include', fallback=None)
    or c.get(section, 'Server', fallback=None)
  ]

def which_repo(dbs, pkg):
  for repo, db in dbs.items():
    if db.get_pkg(pkg):
      return repo

  return 'local'

def main():
  repos = get_repo_list()

  h = pyalpm.Handle('/', '/var/lib/pacman')
  dbs = {repo: h.register_syncdb(repo, 0) for repo in repos}

  by_db = {repo: [] for repo in repos}
  by_db['local'] = []

  ldb = h.get_localdb()
  for pkg in ldb.pkgcache:
    by_db[which_repo(dbs, pkg.name)].append(pkg.name)

  for repo, pkgs in by_db.items():
    pkgs.sort()
    for pkg in pkgs:
      print(f'{repo} {pkg}')

if __name__ == '__main__':
  main()