KateSQL PostgreSQL not an option for connection

Hi I have a PostgreSQL database that I would like to connect to via Kate. However when trying to setup a connection using the KateSQL plugin, it only shows me MySQL, MariaDB, and SQLite as options to setup. Does anyone know how I might be able to get the appropriate QT SQL module driver for PostgreSQL setup so I can connect using Kate?

As of now I am using:

  1. Kate version 21.12.0
  2. KDE version 5.23.4
  3. QT version 5.15.2

I had found a package called qt6-sql-postgresql, but that package did not fix the issue.

I think kate uses Qt5 and you may need this package

libQt5Sql5-postgresql

However, it seems like kate still suffers from being unable to store the db connections. This is a long standing bug and it does not look like it will ever be fixed. Maybe look for alternatives