PostgreSQL Migrations Expert

What problem does it solve?

This Skill provides comprehensive guidance to navigate complex PostgreSQL database schema changes, helping you avoid common migration errors, ensure idempotency, and optimize performance. It streamlines your database development, preventing costly production issues.

Core Features & Use Cases

• Error Resolution: Offers solutions for common PostgreSQL migration errors like "Subquery uses ungrouped column" or "Functions in index expression must be IMMUTABLE."
• Idempotent Migrations: Guides you on best practices for creating re-runnable migrations using IF (NOT) EXISTS clauses, ensuring safety and consistency.
• Advanced Features: Provides expertise on generated columns, full-text search optimization, composite indexes, materialized views, and efficient migration file structures.
• Use Case: When you're performing a critical database schema update, this skill ensures your migration is robust, handles edge cases, and won't break if run multiple times, saving you from costly production errors and manual rollbacks.

Quick Start

Idempotent Table Creation

CREATE TABLE IF NOT EXISTS users ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), name VARCHAR(255) );

Idempotent Column Addition

ALTER TABLE users ADD COLUMN IF NOT EXISTS email VARCHAR(255);