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.

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

01Automated data retention and cleanup configuration

021 GitHub stars

03Batch-processed migrations for large-scale tables

04Multi-tier backup scripts with automated retention

05GDPR and CCPA compliant data export and erasure workflows

06Zero-downtime expand-contract migration patterns

Use Cases

01Renaming columns or changing schemas on high-traffic production databases

02Automating database maintenance tasks like backups and index optimization

03Implementing 'Right to be Forgotten' requests for privacy law compliance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add antoineschaller/cortex-skills data-management

For use in Claude.ai and ChatGPT

Download Skill