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.

About

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

Troubleshooting for common SQL errors including ungrouped columns and function immutability.
Patterns for idempotent migrations using IF NOT EXISTS and defensive extension handling.
Standardized templates for migration files including triggers, views, and comments.
81 GitHub stars
Advanced schema management for circular dependencies, JSONB indexing, and soft deletes.
Optimization strategies for full-text search using generated columns and GIN indexes.

Use Cases

Generating re-runnable SQL migration scripts that safely handle existing database objects.
Refactoring database schemas to include automated timestamps and audit triggers.
Optimizing query performance by implementing composite indexes and materialized views.

About

Key Features

Troubleshooting for common SQL errors including ungrouped columns and function immutability.
Patterns for idempotent migrations using IF NOT EXISTS and defensive extension handling.
Standardized templates for migration files including triggers, views, and comments.
81 GitHub stars
Advanced schema management for circular dependencies, JSONB indexing, and soft deletes.
Optimization strategies for full-text search using generated columns and GIN indexes.

Use Cases

Generating re-runnable SQL migration scripts that safely handle existing database objects.
Refactoring database schemas to include automated timestamps and audit triggers.
Optimizing query performance by implementing composite indexes and materialized views.