PGXN

Isok^[1] is a PostgreSQL extension that helps with data cleanup management, data monitoring, and data validation. In brief, give Isok a query that returns questionable data and, after setup, Isok filters the results to show only the data that needs immediate cleanup.

Queries find problems. Isok builds on this and tracks changes in problematic data, changes that might or might not indicate a new problem. When configured to accept some questionable rows but not others of the same kind, Isok acts like a “soft trigger”, with scheduling and note-taking features to support the management of problem resolution.

Useful for "zero code required" batch-based data validation and data cleanup management. Most useful when review is required to determine whether a questionable data pattern should be allowed to remain in a database.