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

データベース管理

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.

主な機能

0 GitHub stars
Troubleshoot common Postgres migration errors like IMMUTABLE function requirements
Generate idempotent SQL scripts using IF NOT EXISTS patterns for re-runnable migrations
Structure migration files with standardized templates for triggers, views, and functions
Apply performance best practices including composite indexing and VACUUM/ANALYZE strategies
Implement advanced Full-Text Search with generated columns and GIN indexes

ユースケース

Creating automated audit logs and self-updating timestamps for database tables
Refactoring a production database schema without losing data or causing downtime
Optimizing slow search queries using specialized Postgres indexing and tsvectors

概要

主な機能

0 GitHub stars
Troubleshoot common Postgres migration errors like IMMUTABLE function requirements
Generate idempotent SQL scripts using IF NOT EXISTS patterns for re-runnable migrations
Structure migration files with standardized templates for triggers, views, and functions
Apply performance best practices including composite indexing and VACUUM/ANALYZE strategies
Implement advanced Full-Text Search with generated columns and GIN indexes

ユースケース

Creating automated audit logs and self-updating timestamps for database tables
Refactoring a production database schema without losing data or causing downtime
Optimizing slow search queries using specialized Postgres indexing and tsvectors