supabase-data-handling

实现Supabase PII处理、数据保留和GDPR/CCPA合规模式。在处理敏感数据、实施数据编辑、配置保留策略或确保Supabase集成符合隐私法规时使用。通过如“supabase数据”、“supabase PII”、“supabase GDPR”、“supabase数据保留”、“supabase隐私”、“supabase CCPA”等短语触发。

📖 中文导读:实现Supabase PII处理、数据保留和GDPR/CCPA合规模式。在处理敏感数据、实施数据编辑、配置保留策略或确保Supabase集成符合隐私法规时使用。通过如“supabase数据”、“supabase PII”、“supabase GDPR”、“supabase数据保留”、“supabase隐私”、“supabase CCPA”等短语触发。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: supabase-data-handling description: | Implement Supabase PII handling, data retention, and GDPR/CCPA compliance patterns. Use when handling sensitive data, implementing data redaction, configuring retention policies, or ensuring compliance with privacy regulations for Supabase integrations. Trigger with phrases like "supabase data", "supabase PII", "supabase GDPR", "supabase data retention", "supabase privacy", "supabase CCPA". allowed-tools: Read, Write, Edit version: 1.0.0 license: MIT author: Jeremy Longshore jeremy@intentsolutions.io

Supabase Data Handling

Overview

Handle sensitive data correctly when integrating with Supabase.

Prerequisites

  • Understanding of GDPR/CCPA requirements
  • Supabase SDK with data export capabilities
  • Database for audit logging
  • Scheduled job infrastructure for cleanup

Data Classification

Category Examples Handling
PII Email, name, phone Encrypt, minimize
Sensitive API keys, tokens Never log, rotate
Business Usage metrics Aggregate when possible
Public Product names Standard handling

PII Detection

const PII_PATTERNS = [
  { type: 'email', regex: /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/g },
  { type: 'phone', regex: /\b\d{3}[-.]?\d{3}[-.]?\d{4}\b/g },
  { type: 'ssn', regex: /\b\d{3}-\d{2}-\d{4}\b/g },
  { type: 'credit_card', regex: /\b\d{4}[- ]?\d{4}[- ]?\d{4}[- ]?\d{4}\b/g },
];

function detectPII(text: string): { type: string; match: string }[] {
  const findings: { type: string; match: string }[] = [];

  for (const pattern of PII_PATTERNS) {
    const matches = text.matchAll(pattern.regex);
    for (const match of matches) {

## Detailed Reference

See `{baseDir}/references/implementation.md` for complete data handling guide.