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.