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

0•

Database Management

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

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

01Troubleshooting for common PostgreSQL errors and grouping issues

02Performance tuning via EXPLAIN ANALYZE and composite index strategies

03Idempotent migration patterns using IF NOT EXISTS logic

04Full-text search optimization with tsvector and GIN indexing

05Implementation of generated columns with immutable helper functions

060 GitHub stars

Use Cases

01Optimizing slow-running queries through materialized views and specialized indexing

02Designing production-ready database schema changes that are safe to re-run

03Implementing complex search functionality using native PostgreSQL capabilities

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill