Does this skill support other SQL dialects?

While general SQL principles apply, this skill is specifically optimized for PostgreSQL-exclusive features like GIN indexes, IMMUTABLE function wrappers, and JSONB columns.

Does it provide advice on zero-downtime migrations?

Yes, it includes patterns for non-blocking operations, such as concurrent materialized view refreshes and strategies for adding foreign keys without locking tables.

How does this skill handle migration idempotency?

It provides patterns that utilize IF NOT EXISTS and IF EXISTS clauses for all CREATE and DROP operations, ensuring scripts can be run multiple times without causing errors.

Can I use this with migration tools like Prisma or Flyway?

Yes, the SQL patterns and best practices provided are designed to be used within the raw SQL migration files supported by frameworks like Flyway, Liquibase, or Prisma Migrations.

PostgreSQL Migrations

Name: PostgreSQL Migrations
Author: Microck

byMicrock

•

Database Management

Provides specialized guidance and implementation patterns for resilient, idempotent PostgreSQL database migrations.

This skill equips Claude with comprehensive knowledge for architecting and executing PostgreSQL schema changes with precision. It addresses frequent migration pitfalls—such as subquery errors, immutability requirements for indexes, and circular dependencies—while promoting production-ready best practices. Whether you are implementing full-text search vectors, managing materialized views, or designing soft-delete patterns, this skill ensures your database evolution is idempotent, performant, and follows standardized SQL conventions.

Key Features

01Troubleshooting for common SQL errors including ungrouped columns and function immutability.

02Patterns for idempotent migrations using IF NOT EXISTS and defensive extension handling.

03Standardized templates for migration files including triggers, views, and comments.

0481 GitHub stars

05Advanced schema management for circular dependencies, JSONB indexing, and soft deletes.

06Optimization strategies for full-text search using generated columns and GIN indexes.

Use Cases

01Generating re-runnable SQL migration scripts that safely handle existing database objects.

02Refactoring database schemas to include automated timestamps and audit triggers.

03Optimizing query performance by implementing composite indexes and materialized views.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills postgres-migrations

For use in Claude.ai and ChatGPT

Download Skill