Can it help with database performance?

Yes, it provides guidance on creating composite indexes, optimizing full-text search, and using EXPLAIN/ANALYZE to debug slow queries.

What are idempotent migrations?

These are migrations designed to be run multiple times safely without failing, typically using 'IF NOT EXISTS' and 'IF EXISTS' clauses in SQL statements.

How does this skill handle migration errors?

It identifies common PostgreSQL pitfalls like function mutability and ungrouped column errors, providing specific SQL fixes and CTE patterns to resolve them.

Does it support advanced features like JSONB?

Yes, the skill includes patterns for indexing JSONB keys and specific paths to improve the performance of document-style data in Postgres.

PostgreSQL Migrations & Schema Management

Name: PostgreSQL Migrations & Schema Management
Author: Activer007

byActiver007

0•

Database Management

Provides expert guidance on PostgreSQL migrations, including idempotent patterns, index optimization, and resolving complex database errors.

This skill equips Claude with specialized knowledge to manage PostgreSQL database migrations safely and efficiently. It covers a broad range of topics from common error resolution—such as immutable function requirements and ungrouped column issues—to advanced optimization techniques like full-text search indexing and materialized views. By following industry best practices for idempotent migrations and circular dependency management, it helps developers maintain schema integrity across multiple environments while minimizing downtime and performance bottlenecks.

Key Features

010 GitHub stars

02Troubleshoot common Postgres migration errors like IMMUTABLE function requirements

03Generate idempotent SQL scripts using IF NOT EXISTS patterns for re-runnable migrations

04Structure migration files with standardized templates for triggers, views, and functions

05Apply performance best practices including composite indexing and VACUUM/ANALYZE strategies

06Implement advanced Full-Text Search with generated columns and GIN indexes

Use Cases

01Creating automated audit logs and self-updating timestamps for database tables

02Refactoring a production database schema without losing data or causing downtime

03Optimizing slow search queries using specialized Postgres indexing and tsvectors

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