🧠 Prompt Quiz

A database audit tool that discovers hidden, unused data including isolated tables, inactive columns, and unqueried structured text fields.

Design a data cranny discovery tool for a database audit platform. The tool searches every nook and cranny of a PostgreSQL database for undocumented, orphaned, or overlooked data. It identifies: tables with no foreign key relationships (isolated data islands), columns with no data in them for more than 6 months (abandoned fields that may contain legacy data), tables not queried by any current application based on pg_stat_user_tables (potentially orphaned tables), and columns whose data type is text but whose values follow a consistent structured pattern (crannies where structured data is being stored in unstructured fields). Each finding is flagged for review with the discovery context.