ranbot-ai/privacy-by-design

Privacy by Design

Overview

Integrate privacy protections into software architecture from the beginning, not as an afterthought. This skill applies Privacy by Design principles (GDPR Article 25, Cavoukian's framework) when designing databases, APIs, and user flows. Protects real users' data and builds trust.

When to Use This Skill

• Use when building apps that collect personal data (names, emails, locations, preferences)
• Use when designing database schemas, APIs, or authentication flows
• Use when the user mentions forms, user accounts, analytics, or third-party integrations
• Use when deploying to production—verify privacy controls before launch

Legal Frameworks

GDPR (EU) — Primary reference. Article 25 mandates "data protection by design and by default." Applies to EU users and often adopted globally.

CCPA (California) — Right to know, delete, opt-out of sale. Similar principles: minimize, disclose, allow control.

LGPD (Brazil) — Aligned with GDPR. Purpose limitation, necessity, transparency. Applies to Brazil users.

Design for the strictest framework you target; it often satisfies others.

---

Core Principles

1. Data Minimization

Collect only what is strictly necessary. Every field needs a documented justification. Avoid "we might need it later."

2. Purpose Limitation

Store the purpose of each data point. Do not reuse data for purposes the user did not consent to.

3. Storage Limitation

Define retention periods. Implement automated deletion or anonymization when retention expires. Never keep data "forever" by default.

4. Privacy as Default

Opt-in for optional collection, not opt-out. Sensitive settings (analytics, marketing) off by default. No pre-checked consent boxes.

5. End-to-End Security

Encrypt at rest and in transit. Use RBAC. Log access to sensitive data for audit.

6. Transparency

Document what is collected and why. Clear privacy policies. Easy access and deletion for users.

---

User Rights (GDPR)

Ensure these are implementable from day one:

| Right | What to build | |-------|---------------| | Access | Endpoint or flow to return all user data | | Rectification | Ability to update/correct data | | Erasure | Account deletion + data purge (including backups) | | Portability | Export data in machine-readable format (JSON, CSV) |

---

Deep Dive: Why It Matters

Data minimization — Less data = less breach impact, lower storage cost, simpler compliance. Each field is a liability.

Purpose limitation — Reusing data without consent is illegal under GDPR. Document purpose in schema or metadata.

Retention — Indefinite storage increases risk and violates GDPR. Define retention_days per data type; automate cleanup.

Logging — Logs often leak PII. Redact emails, IDs, tokens. Use structured logging with allowlists.

Third parties — Every SDK (analytics, crash reporting, ads) may send data elsewhere. Audit dependencies; require consent before loading.

---

Code Examples

JavaScript/Node — Minimal User Model

// BAD: Collecting everything "just in case"
const user = { email, name, phone, address, birthdate, ipAddress, userAgent, ... };

// GOOD: Minimal, documented purpose
const user = {
  email,        // purpose: authentication
  displayName,  // purpose: UI display
  createdAt,    // purpose: account age
};

JavaScript — Consent Before Tracking

// BAD: Track first, ask later
analytics.track(userId, event);

// GOOD: Check consent first
if (userConsent.analytics) {
  analytics.track(userId, event);
}

Python — Safe Logging

# BAD: Logging PII in plain text
logger.info(f"User {user.email} logged in from {request.remote_addr}")

# GOOD: Redact or hash identifiers
logger.info(f"User {hash_user_id(user.id)} logged in")
# Or: logger.info("User login", extra={"user_id_hash": hash_id(user.id)})

SQL — Schema with Purpose and Retention

-- GOOD: Document purpose and retention in schema
CREATE TABLE users (
  id UUID PRIMARY KEY,
  email VARCHAR(255) NOT NULL,  -- purpose: auth, retention: account lifetime
  display_name VARCHAR(100),   -- purpose: UI, retention: account lifetime
  created_at TIMESTAMPTZ,      -- purpose: audit, retention: 7 years
  last_login_at TIMESTAMPTZ    -- purpose: security, retention: 90 days
);

-- Add retention policy (PostgreSQL example)
-- Schedule job to anonymize/delete last_login_at after 90 days

API — Return Only Needed Fields

# BAD: Returning full user object
return jsonify(user)  # May include internal fields, hashed passwords

# GOOD: Explicit allowlist
return jsonify({
    "id": user.id,
    "email": user.email,
    "displayName": user.display_name,
})

---

Common Pitfalls

| Pitfall | Solution | |---------|----------| | Logs contain emails, IPs, tokens | Redact PII; use hashed IDs or structured logs | | Error messages expose data | Return generic errors to clien