Cross-Environment PostgreSQL Extensions

This skill provides the DO block pattern for PostgreSQL extensions that works across different hosting environments.

When This Skill Activates

Claude automatically uses this skill when you:

• Enable PostgreSQL extensions in migrations
• Disable PostgreSQL extensions in rollback migrations
• Create migrations that need CREATE EXTENSION
• Work with multiple PostgreSQL environments (cloud, self-hosted, CNPG)

The Problem: Permission Errors Across Environments

Different PostgreSQL environments have different permission models: