Does it support idempotent migrations?

Yes, it provides patterns for checking the existence of columns, indexes, and constraints before attempting to create them, making your migration scripts safer to re-run in various environments.

Can I use this for large dataset updates?

Yes, the skill includes batched update patterns using PL/pgSQL to process data in small chunks, preventing transaction log bloat and long-duration locks on your tables.

How does this skill help with production database migrations?

It provides specific SQL patterns that minimize table locking, such as using CONCURRENTLY for indexes and NOT VALID for constraints, ensuring your application remains responsive during schema changes.

Is this skill compatible with modern PostgreSQL versions?

Yes, it is designed for PostgreSQL 11 and above, specifically leveraging features like instant column addition with defaults and transactional DDL capabilities.

PostgreSQL Migration Patterns

Name: PostgreSQL Migration Patterns
Author: bradtaylorsf

bybradtaylorsf

•

データベース管理

Implements safe, zero-downtime PostgreSQL schema migrations using industry-standard patterns and best practices.

This skill equips Claude with a robust library of PostgreSQL migration strategies designed to prevent database downtime and performance degradation during schema changes. It includes detailed templates for adding or renaming columns, creating indexes concurrently, and implementing non-blocking constraints on high-traffic tables. By following these patterns, developers can confidently handle complex schema evolutions, manage database locks effectively, and perform large-scale data backfills using safe, batched transaction patterns that maintain application responsiveness.

主な機能

01Transactional DDL and lock monitoring queries

026 GitHub stars

03Non-blocking constraint validation scripts

04Concurrent index creation and management

05Zero-downtime schema evolution patterns

06Batched data migration and backfill loops

ユースケース

01Updating production schemas without application downtime

02Writing idempotent migration scripts for CI/CD pipelines

03Managing complex data refactoring and table restructuring

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team postgres-migrations

For use in Claude.ai and ChatGPT

Download Skill