Metadata and data lineage tool

Hi all,

We use PostgreSQL as. our primary data persistence layer and are looking
for a tool to document the database as well as capture additional info.
Looking for suggestions.
The tool should be able to scan the database (PostgreSQL) and generate a
list of entities and attributes and persist this info. We would need to
add tags to the columns (like "PII data").
We also need to manually add information about other data persistence
layers (Redis). It will be great if we can map an attribute in Redis to a
column in PostgreSQL so that we can visualise the data flow.
Any suggestion will be highly appreciated. Open source solutions preferred.

Best Regards,
Jayadevan