Can I test the redaction logic before running it in production?

Yes, the skill includes integration tests and can be run locally via Python to verify the logic against your specific data schema.

How frequently does the redaction process run?

The default schedule is set to run weekly (every Sunday at 2:00 AM), though this can be configured in your environment settings.

Does this skill delete entire rows from my database?

No, it performs a 'soft-deletion' by nullifying specific PII fields (like names or IPs). This allows you to keep the record structure for analytics while removing sensitive identifiers.

What databases does the PII Redaction skill support?

The skill is currently designed to manage PII redaction across ClickHouse and Postgres databases.

How is the redaction process tracked for auditing?

Every write operation includes a generated UUID run ID, a trace ID from Langfuse, and a source reference, providing a clear audit trail of all privacy actions.

PII Redaction & Privacy Manager

Name: PII Redaction & Privacy Manager
Author: OrionArchitekton

byOrionArchitekton

•

セキュリティとテスト

Automates the soft-deletion of expired PII from ClickHouse and Postgres databases to ensure data privacy compliance.

The PII Redaction skill facilitates automated data privacy governance by identifying and nullifying expired personally identifiable information across multiple database systems. It targets sensitive fields such as actor display names and audit log IP or User Agent strings based on configurable retention periods—typically 30 to 90 days. By nullifying specific fields rather than deleting entire records, this skill ensures that personal identifiers are removed in accordance with regulatory requirements like GDPR while preserving the underlying row structure for continued, anonymized analytical processing.

主な機能

01Cross-database support for both ClickHouse and Postgres

02Automated weekly soft-deletion of expired sensitive data

031 GitHub stars

04Preservation of record structure for consistent data analytics

05Configurable retention windows for specific PII fields

06Robust provenance tracking with UUID run IDs and trace IDs

ユースケース

01Anonymizing historical audit logs by removing IP and User Agent data

02Automating GDPR and CCPA compliance for user-facing applications

03Maintaining privacy-safe datasets for business intelligence and reporting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add orionarchitekton/cosmocrat-core ops

For use in Claude.ai and ChatGPT

Download Skill