Does it provide templates for migration files?

Yes, it includes a comprehensive migration file structure covering extensions, tables, indexes, views, functions, and triggers.

What are idempotent migrations?

Idempotent migrations are database scripts designed to be executed multiple times without changing the result beyond the initial application, typically achieved using 'IF NOT EXISTS' and 'IF EXISTS' clauses.

How does this skill handle PostgreSQL immutable function errors?

It provides wrapper function patterns to convert stable functions into immutable ones, which is a requirement for using them in generated columns and indexes.

Can I use this for full-text search optimization?

Yes, the skill includes specific patterns for creating generated tsvector columns and GIN indexes to enable high-performance full-text search.

How can I check if my migrations are performant?

The skill includes guidance on using EXPLAIN ANALYZE to verify index usage and ANALYZE/VACUUM commands to maintain database health after bulk changes.

PostgreSQL Migration & Schema Expert

Name: PostgreSQL Migration & Schema Expert
Author: Activer007

byActiver007

Database Management

Provides comprehensive guidance and implementation patterns for robust, idempotent PostgreSQL database migrations and schema design.

About

This skill equips Claude with deep expertise in PostgreSQL migration strategies, helping developers avoid common pitfalls such as 'relation does not exist' errors, immutable function requirements, and circular dependencies. It provides standardized templates for idempotent SQL scripts, advanced patterns for full-text search using GIN indexes, and optimization techniques for materialized views and generated columns. Whether you are building a new schema or refactoring a production database, this skill ensures your migrations are safe, performant, and reproducible.

Key Features

Troubleshooting for common PostgreSQL errors and grouping issues
Performance tuning via EXPLAIN ANALYZE and composite index strategies
Idempotent migration patterns using IF NOT EXISTS logic
Full-text search optimization with tsvector and GIN indexing
Implementation of generated columns with immutable helper functions
0 GitHub stars

Use Cases

Optimizing slow-running queries through materialized views and specialized indexing
Designing production-ready database schema changes that are safe to re-run
Implementing complex search functionality using native PostgreSQL capabilities

About

Key Features

Troubleshooting for common PostgreSQL errors and grouping issues
Performance tuning via EXPLAIN ANALYZE and composite index strategies
Idempotent migration patterns using IF NOT EXISTS logic
Full-text search optimization with tsvector and GIN indexing
Implementation of generated columns with immutable helper functions
0 GitHub stars

Use Cases

Optimizing slow-running queries through materialized views and specialized indexing
Designing production-ready database schema changes that are safe to re-run
Implementing complex search functionality using native PostgreSQL capabilities