How does the DO block pattern solve permission errors?

It attempts to set the necessary role within a block that catches exceptions, allowing the migration to proceed gracefully whether the role change succeeds or is rejected.

Why do standard CREATE EXTENSION commands fail in some environments?

Different providers have unique permission models; some require specific roles like 'postgres' to be set, while others pre-install extensions and forbid role changes, leading to 'permission denied' errors.

Does this skill support rolling back extensions?

Yes, it provides 'down.sql' patterns using the same resilient logic to safely drop extensions using the CASCADE keyword in reverse order.

Cross-Env PostgreSQL Extensions

Name: Cross-Env PostgreSQL Extensions
Author: jovermier

byjovermier

0•

Database Management

Generates environment-agnostic PostgreSQL extension migrations using resilient DO block patterns for Nhost and CNPG.

This Claude Code skill automates the creation of robust PostgreSQL migrations for enabling or disabling extensions like pgvector, PostGIS, and pg_trgm. By implementing a standardized DO block pattern with exception handling, it ensures that migrations execute successfully across diverse hosting environments including Nhost Cloud, CloudNativePG (CNPG), and standard PostgreSQL setups. It eliminates common 'permission denied' errors and idempotency issues, making it an essential tool for developers managing multi-environment database lifecycles and AI-ready data layers.

Key Features

01Automated DO block generation for resilient extension management

02Error-tolerant role escalation logic to bypass permission restrictions

030 GitHub stars

04Cross-environment compatibility for Nhost, CNPG, and standard Postgres

05Pre-configured patterns for pgvector, PostGIS, and uuid-ossp

06Idempotent migration templates for up.sql and down.sql files

Use Cases

01Standardizing database migrations for teams using mixed PostgreSQL hosting providers

02Implementing geospatial features with PostGIS without platform-specific permission errors

03Deploying AI-powered applications with pgvector across local and cloud environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jovermier/claude-code-plugins-ip-labs cross-env-postgresql-extensions

For use in Claude.ai and ChatGPT

Download Skill