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

Database Management

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

About

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

Automated DO block generation for resilient extension management
Error-tolerant role escalation logic to bypass permission restrictions
0 GitHub stars
Cross-environment compatibility for Nhost, CNPG, and standard Postgres
Pre-configured patterns for pgvector, PostGIS, and uuid-ossp
Idempotent migration templates for up.sql and down.sql files

Use Cases

Standardizing database migrations for teams using mixed PostgreSQL hosting providers
Implementing geospatial features with PostGIS without platform-specific permission errors
Deploying 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

GitHub