What is the Expand-Contract pattern for migrations?

It is a multi-phase migration strategy that allows for schema changes without downtime by adding new structures, syncing data, and only removing old structures once the code is updated.

Does this skill support GDPR and CCPA requirements?

Yes, it provides specific logic for 'Right to Access' data exports and 'Right to Erasure' through anonymization and deletion scripts.

Can these scripts be used with large databases?

The skill includes batch-processing techniques for migrations to avoid table locking on datasets with millions of rows.

Is this skill limited to PostgreSQL?

While the examples utilize PostgreSQL syntax, the architectural patterns are easily adaptable to MySQL, SQL Server, and other relational databases.

Data Management Patterns

Name: Data Management Patterns
Author: antoineschaller

byantoineschaller

•

Database Management

Implements robust database strategies for zero-downtime migrations, automated backups, and regulatory data compliance.

About

The Data Management skill for Claude Code provides a comprehensive set of production-ready patterns to manage the entire data lifecycle. It features specialized guidance for performing complex schema migrations using the expand-contract pattern to eliminate downtime, alongside multi-tier backup and recovery strategies. Designed for high-stakes environments, it also includes specific templates for GDPR/CCPA compliance, automated data retention cleanup, and soft-delete implementations, ensuring your database remains performant, secure, and legally compliant.

Key Features

Automated data retention and cleanup configuration
1 GitHub stars
Batch-processed migrations for large-scale tables
Multi-tier backup scripts with automated retention
GDPR and CCPA compliant data export and erasure workflows
Zero-downtime expand-contract migration patterns

Use Cases

Renaming columns or changing schemas on high-traffic production databases
Automating database maintenance tasks like backups and index optimization
Implementing 'Right to be Forgotten' requests for privacy law compliance

About

Key Features

Automated data retention and cleanup configuration
1 GitHub stars
Batch-processed migrations for large-scale tables
Multi-tier backup scripts with automated retention
GDPR and CCPA compliant data export and erasure workflows
Zero-downtime expand-contract migration patterns

Use Cases

Renaming columns or changing schemas on high-traffic production databases
Automating database maintenance tasks like backups and index optimization
Implementing 'Right to be Forgotten' requests for privacy law compliance